Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Tables + Relationships _ Alternative To Attachment Datatype?

Posted by: jabm May 22 2020, 10:57 AM

Hello all!
I've been posting in the "Forms" Forum, but this question seems more appropriate here.

The database I am developing is for a non-profit maternity home which only opened last year (first residents came in Nov or Dec 2019).

In my first incarnation/rough prototype of the database I had used the Access datatype "Attachment" to be able to store scanned documents pertaining to the paperwork checklists for employees, volunteers and residents (for example the NH 2202 DCYF Central Registry Name Search, or copy of State ID/Driver's licence or the confidentiality agreement). I was quickly made aware that attachments could cause the database to bloat rather quickly.

Is the hyperlink datatype a good alternative? Drawbacks? Is there a better alternative?

Thank you!


Posted by: theDBguy May 22 2020, 11:32 AM

Hi Julia,

If it was me, I would simply use a ShortText data type. The Hyperlink data type has some convenience but also some difficulties when using them.

Posted by: jabm May 22 2020, 11:39 AM

Thanks - but would they then have to copy/paste the file path into (old term I know) File Manager instead of just clicking on the link and bringing up the document?

Posted by: theDBguy May 22 2020, 11:46 AM

Hi. Not really. If no one has told you this yet, you shouldn't allow users to have direct access to tables and queries. Instead, you use Forms to interact with the data. With Forms, you have a lot of control over what the users can do. One of those would be when they click on the "file path" textbox. Each form control has a lot of Events you can use. In this case, you can use the Click event, so when the user clicks on the file path, you can have some code execute to open the file pointed to by the file path.

Posted by: jabm May 22 2020, 11:51 AM

Thank you!
I am still learning!

Posted by: theDBguy May 22 2020, 12:04 PM

Of course. That's what we're here for. Keep asking questions...