Access file with attachment data types

I'm helping someone with an Access database that has attachment data types in a few of the tables.  The issue we have is that the Access file is huge and growing as new attachments are added.

So I'm trying to find a better way to handle these attachments so they are not in the actual Access file at all but can easily be accessed from the Access database.

Thoughts/Suggestions?

--Steve
SteveL13Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
...Then you can use any number of techniques to "Link" to the data rather than store it in the db.

Here is a very basic example:
Access-BasicLinkFormReportImages.mdb
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
see the codes from this link

* Add an Attachment to a Record
* Save an Attachment to Disk

http://msdn.microsoft.com/en-us/library/bb258184.aspx
0
 
SteveL13Author Commented:
Excellent.  Thanks much!
0
 
SteveL13Author Commented:
Sorry... I just closed this out and realized that we need to be able to deal with pdf attachments also.  Can this be dealt with in the .mdb example provided?  The Acces version is 2007.

--Steve
0
 
Jeffrey CoachmanMIS LiasonCommented:
Yes, but if you *really* have a need to View the pdf on the form, then this gets complicated.
You have to use a webbrowser control instead of an image control.

You also have to modify the code to filter for PDF files.

It might be easier to use my sample just to select and link to the files...
(and forget about viewing them)

You can create functionality to "Open/View" the files on a button, as there is a distinct difference between "Opening" a file and "Viewing" a file.
So you might be able to use code like this:
http://access.mvps.org/access/api/api0018.htm
...Or something simple like this:
Application.FollowHyperlink [YourFullLinkPath]
...All depending on your exact needs...

JeffCoachman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.