Attachments

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

Access 2002
I am using Access 2002 and would like to attach scanned
documents to a data record so that when working on a
record form I can view any attached documents to that
record. Is this feacible and if so how would I approach
it. Some guidance would be appreciated.
With thanks.
Frank
 
----- Frank wrote: ----

Access 200
I am using Access 2002 and would like to attach scanned
documents to a data record so that when working on a
record form I can view any attached documents to that
record. Is this feacible and if so how would I approach
it. Some guidance would be appreciated
With thanks

There are several ways to do this. If your document is really a pdf or Word document, or if it's an image file you can link it to the Access record by storing the path in the Access database to open it with ShellExecute. See the following articles on the Access Web

http://www.mvps.org/access/api/api0001.ht

http://www.mvps.org/access/api/api0018.ht

If you want to use Access to scan the document directly in to a bound OLE field, or into an external file, Use something like the DBPix ActiveX Control to scan and store the document

http://www.ammara.co
-
Arvin Meyer, MCP, MV
Microsoft Acces
Free Access download
http://www.datastrat.co
http://www.mvps.or
 
Access 2002
I am using Access 2002 and would like to attach scanned
documents to a data record so that when working on a
record form I can view any attached documents to that
record. Is this feacible and if so how would I approach
it. Some guidance would be appreciated.
With thanks.
Frank
Click to expand...

Storing image data in Access can be VERY inefficient in disk space:
databases bloat with incredible rapidity. See

http://www.mvps.org/access/forms/frm0030.htm

and links therein for ways to do this safely.
 
Back
Top