How to link or attach a pdf file in access database?

[Abeetan]

Hello all,

I wanted to know what is the proper way of linking a pdf file that is stored on my PC in a folder to each record. For example, a pdf of a receipt for each order (a record) goes in a field. I have done something as adding a hyperlink in the field but I hear there is a better approach. Please advise. Thank you.

 

[theDBguy]

Hi. The recommended approach is to store the file path to the file in a Text field.

 

[Abeetan]

Hi. The recommended approach is to store the file path to the file in a Text field

Do you happen to have a YouTube video demonstrating an example? I have failed in the past storing a file path as a text field I am definitely missing something or doing it wrong. Does the datatype have to be a hyperlink?

 

[theDBguy]

Do you happen to have a YouTube video demonstrating an example? I have failed in the past storing a file path as a text field I am definitely missing something or doing it wrong. Does the datatype have to be a hyperlink?

The field's data type can just be Short Text. What do you mean by "failed?"

 

[Abeetan]

The field's data type can just be Short Text. What do you mean by "failed?"

I am unable to link the file, it won't open. It's just stored as text. I can't click on it and open the file. Or even worse, access says it can't find the file.

 

[theDBguy]

I am unable to link the file, it won't open. It's just stored as text. I can't click on it and open the file. Or even worse, access says it can't find the file.

Okay, first of all, I hope you're clicking on it on a form and not in a table. The code you could try to open the file could be something like:

Application.FollowHyperlink Me.FieldName

Edit: Oops, too slow...