Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

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
SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SteveL13

ASKER

Excellent.  Thanks much!
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
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