Kindly advise. The most efficient way to do this would be to store the PDF files on the system, and include the path to the file in a text column in a table. It is then a simple matter to open the file from Access. You might like to take a look at BrowseDemo. This little demo file illustrates how to browse to a file, inserting the path into a text box on the form, and how to open or print the file from the form.
In the demo the form is unbound, but could equally well be a bound form. The demo also illustrates how to format the text values in the controls as hyperlinks. Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. Ann K. Thank you. This thread is locked. Follow Report. Community guidelines. Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more. Bernd Alheit. Adobe Community Professional , May 02, May 02, Add-in for Access is not more available.
Jump to latest reply. This is more of an integration and compatibility issue between the MS Office product that you purchased and the Add-ins that Microsoft currently supports. You've answered your own question. Correct answer by Bernd Alheit. It might be possible to leverage the Windows file previewing API, though I'd be certain thumbnails are a definite requirement before investigating this - Access VBA is powerful enough to encourage attempts at complex solutions, but frequently not clean and modern enough to allow fulfilling them in a particularly maintainable fashion.
You can add an attachment field here. When you go into the Datasheet view of the table you can select this field for a particular row and a window will open for you to specify the attachment. This will cause your database to quickly grow in size if you add a lot of large attachments. You can use an OLE field in a table, but I would really suggest you not use this approach.
The database is going to be HUGE in no time, and you're going to regret it. Instead, you should consider adding a field that stores the path to the file, and keep the files in one folder on your network. What's the difference between restoring an Access database and restoring PDF files if something goes wrong?
This will keep your database at a manageable size and reduce the possibility of corruption. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. How to attach and view pdf documents to access database Ask Question. Asked 8 years, 2 months ago. Active 8 years, 2 months ago.
Viewed 23k times.
0コメント