Suggestions On Storing External Data

  • Thread starter Thread starter dan.cawthorne
  • Start date Start date
D

dan.cawthorne

Hello,

I was wondering what the best way to store, Word, Excel, pdf,and dwg
documents against a Record in my database.

My Database is a Enquiry Management Database, and when projects come
in they are logged, which when an enquiry is received they have
associated documents with them.

So what the plan is that the User who inputs projects can select the
assign the associated to the record, and then when some else looks up
the project that can see all related documents and also open them from
my database.

1. Do i Store External Documents in the database

or

2, Do I Link to the documents,

I would also like help on how to achieve this, if any one has the time
to spare.

Regards

Dan
 
You should not store external documents in the database. It will cause the
database to exceed its 2Gig limit very quickly.
Use a hyperlink field in your table with the path to the document and the
FollowHyperlink method to open the documents.

Another way is to use a text field in your table and the Shell command to
open the documents.
 
Back
Top