Is there a way to attach files to records in Access 2003?

[Guest]

I have a database where I would like to attach files, faxes etc...directly to
record. Is there a way to do that in access version 2003? If so, can
someone assist me with the macro or expression to do so?

 

[Guest]

I would HIGHLY suggest not storing the files in Access but store the link to
the location. Access only holds up to 2Gb of data and embedding documents in
the table is a sure way to reach that limit very fast. Also, it isn't that
easy to do things such as open them up from there. It is much easier to use,
say the FollowHyperlink command to open up the documents from a network
location.

 

[Guest]

Thank you, for your input. I am not savy with Access at all, can you explain
how to write the code for followhyperlink?

Thank you, again!

 

[Guest]

To open a file you would use something like this:

FollowHyperlink "file:///D:\Temp\setuplog.txt"

and if using UNC for a network drive:

FollowHyperlink "file:///\\MyServerName\MyShareName\Temp\setuplog.txt"
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Guest]

Michael, I recently learned how to this. HEre is what you do:
1) Say you have a table with customer orders and you want to link an invoice
document to each customer's order. Say you have a form for customer orders
that is based on a table called "Orders."
2) Go into the "orders" table in design view
3) Create a new row in the table. Call it "Invoice" or something like that.
Make it a hyperlink field.
4) Save the table and close it.
5) Go into the form where you see the order data, in design view.
6) Click on the field list to call up all the field on which the form is
based, which should be all the fields in the orders table
7) Drag the new "invoice" field that you just created in the table onto the
form. Put the field where ever you want on the form.
8) Go into the form view and you should see the new field.
9) Put your mouse in that field and right click.
10) on the menu that comes up scroll to "Hyperlink" and then to "edit
hyperlink." When you click on edit hyperlink a window should open that allows
you to browse and choose the file you want to link to.
11)Once the file is a chosen a link will appear with the name of whatever
the filepath is to that file. You can change the name of the link by right
clicking again on the link, then go to "hyperlink" and then to "display text"
which allows you to type in whatever name you want the hyperlink to be on the
form.

This Method Allows you to link unique records to unique files without
storing the files in the database. You are only storing the hyperlinks.

Hope this helps.

-Debbie