upload documents to database

Question

Hi,

I wanted to know if it was possible to have some type of document loader that would allow me to save pdf, excel, and word documents within the access database?  So if needed, staff could select an employee's name on a form with any other criteria and it would display a list of that employee's documents.  From this list, you could then select and save/download it to your desktop.

Thanks!

Answer 1

If you are using an ACCDB file, you should be able to make use of the attachment data type field to do this.  Keep in mind that if you do store documents within the database, you will need to monitor the database size so that it doesn’t exceed the 2GB file size limit.

Attach files and graphics to the records in your database - http://office.microsoft.com/en-us/access-help/attach-files-and-graphics-to-the-records-in-your-database-HA010341505.aspx

Best Regards,

Nathan O.

Microsoft Online Community Support

Answer 2

When you click on the attachment field on the form, you should see an icon that has a left arrow, right arrow, and a paper click icon.  You can scroll through the attachments for that record by clicking the left or right arrow.  If you click the paper clip icon, you should see a list of all the attachments.

Best Regards,

Nathan O.

Microsoft Online Community Support

Answer 3

How can I get this to list the documents and not just the first document?

Answer 4

THANKS! I'll try this out.  I didn't know this was an added feature to the new type of databases.