How to store pdf in access 2007

For many years now, Access users have wanted the option of saving a report to the PDF format. An Access report saved as a PDF file can be opened by anyone unlike Access snapshots, which are only viewable by recipients who have Access, or the Access Snapshot Viewer, installed. The Save as PDF utility can be downloaded from here. Figure A. Saving a report to a PDF File. Figure B. Selecting a file name and folder for the PDF file. Public Function ReorderInventory.

GoTo CreateEmail. Export report to snapshot format. CreateItem olMailItem. Add strReportFile. Resume ErrorHandlerExit.

Public Function SendShippingReports. Join Us! By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden. Students Click Here. I can do this, but my question is one of file space. For instance, I also have a database that contains 3, records and over 1, Access automatically compresses the.

My data type for the. Any cautionary suggestions before I attempt to do this? I guess I could first compress the. Thanks to everyone at Tek-tips for all the knowledge I have gained over the years. Much appreciated. Just a suggestion here… Have you considered keeping your PDF files somewhere on the shared Server and keep just the path with the file name to the file s in your Access table? Have fun. Easy test Create a blank db with an ole field and an attachment field Total size: K 1.

Add 3 1 meg pdfs using attachment field total: 20,K PDF are not very compressible, so if you use an attachment field the size of the db will increase basically with the size of the PDF. If security is an issue and the Access file is the only control you have You are unable to set security on the folder containing all the linked files. 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. Asked 12 years, 8 months ago. Active 8 years, 10 months ago. Viewed 34k times. Matthew Jones. Matthew Jones Matthew Jones You don't say what version of Access, but pre, there was huge overhead for this. This database will be accessible from a share drive. So, as I understand it, the filesystem will look different based upon the drive the user has mapped our share to.

This is why we were not using linking. If we can avoid this limitation, obviously I would want to use linking instead of storing the file outright. This is an old thread, but I never say Matthew's response to my question. To it, I'd say: don't use mapped drives, but use UNC paths, which will always be the same unless the server name changes or the share mapping changes.

If either of those things happened, drive mappings would be invalidated, anyway. Add a comment. Active Oldest Votes. Birger Birger 4, 19 19 silver badges 32 32 bronze badges. I tried implementing this code, but being so new to VBA I cannot for the life of me figure out how to implement it. Could you explain, for example, what the " 1" and LOF names mean?

A file is opened, and it is assigned a number 1.