Best Way to Store Documents?

[andy570]

hello I am a relatively new Access user. I am building a program to upload documents to a database. My question is this is the best way to achieve this by setting a field in a table to be OLE and upload to it....or to upload to a location and have hyperlink to that document? Thanks

 

[willir]

Andy

There is no perfect answer for this. My preference is to use hyper links...
- keeps the size of the database down
- very flexible - can open multiple appls - Word, Excel, PowerPoint, or even reference web sites or local Intranet sites; can reference bookmarks and jump to a specific location within the document
- can use network security to control access

But, you can not control the external site - the document may move.


If you store documents within the database, you have control over the document, and do not have to worry about "broken links".

But, the size of the database will grow.

Please note that when you store OLE objects, this is really not Accesses native format for storing data -- Access uses pointers to the object; unlike data in the tables that can be indexed, sorted, flitered and validated, Access just stores the OLE object.

Richard

 

[handlebars]

I have created a document automation routine for creating documents based on Word or excel, which, automatically creates, names, saves to the correct location and adds a hyperlink to the document.

Would this be of interest for you, it may need a bit of tweaking though?

Andrew

 

[ZmrAbdulla]

Hi,
Take a look on this link

http://www.mile50.com/access/filecat/index.htm

regards

Zameer Abdulla

http://www.geocities.com/zameerabd/