SteveL13
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
--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.FollowHyperlin k [YourFullLinkPath]
...All depending on your exact needs...
JeffCoachman
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.FollowHyperlin
...All depending on your exact needs...
JeffCoachman
ASKER