Import and export documents

[Imran Ghani]

Hi! I am building my application with MS Access 2007 with VBA. I want to have
buttons in my application, through which users could import documents from MS
Office applications and save them in the database. Also one button to export
documents in MS Office applications. Thanks in advance for guidance.

 

[Klatuu]

Do not put documents in the database. It will bloat the database and will
soon excede the 2 Gig size limit for an mdb or accdb file.
The better way is to use a specific folder to hold the documents and use
either a text or hyperlink field to save the path to the document.

 

[Imran Ghani]

Thanks for your advice. Kindly also guide me about how to achieve this task.

 

[Klatuu]

It is as simple as I described in my first post. You use a text or hyperlink
field to store that path of the document. When you want to open the
document, you either use the Shell function if the field is text or the
FollowHyperLink method is the field is a hyperlink field.