Combining Word documents to Access

[allison]

Hello. I am working on Access 2003. I am creating a database with
contacts, events, vendors, ect... I have hundreds of contracts in word
that needs to be available for each event. What I want to do is put
them in a folder and hyperlink them to each event. That way I do not
bloat my database making them OLE objects. However, I am not sure how
to connect new contracts when someone adds a new event without
physically going in myself to hyperlink them. This database is also
going to a different location as well and I am not there to maintain
it. Is there an easy way to do this? Any help would be greatly
appreciated. Thanks.

Allison

 

[Guest]

Allison,

Your user's should be able to create hyperlink to the contracts themselves.
You will need to use a Open/Save file dialog to allow them to select the file
then with some minor vba take the filepath and name and make the hyperlink

Take a look at the following for the Windows File Open/Save dialog box

http://www.mvps.org/access/api/api0001.htm

Also, the album sample db at the following site would allow you to see how
to make it functional.

http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album

Next, as for maintenance... well if your db is split your back-end will be
in a know location so you should be fine and whenever you make a new
front-end then you just need to send it to your users. When you say
different sites, they are all networked? Also, I used CITRIX to make a db
accessible for 5 different sites and it worked quite well. We would need
some more info about your network, or tools at hand to better guide you.

Daniel