scanning and linking to a document

[Christopher Glaeser]

From within Access, I want to automate a process to scan a document, assign
a unique file name, save the image in a folder, and create a link to the
document so that it can be opened and viewed from within the database
application. Can someone point me in the right direction? I'm guessing
part of the solution is

- a table with autonums to create the unique file names
- a command button to open the scanner application

Best,
Christopher

 

[Arvin Meyer]

Depends upon your version of Access and Windows. I think Office 97 and
Windows 98 were the last versions to include the Kodak image controls which
allowed you to build this into your applications, Today, with newer
versions, I use the DBPix 2.0 ActiveX control to accomplish the same result
(and do a few more things, like zooming, that were harder to do before).

http://www.ammara.com/
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Christopher Glaeser]

Depends upon your version of Access and Windows. I think Office 97 and

Windows 98 were the last versions to include the Kodak image controls
which
allowed you to build this into your applications,

I am using Access 2003, Windows XP SP2.

Today, with newer
versions, I use the DBPix 2.0 ActiveX control to accomplish the same
result
(and do a few more things, like zooming, that were harder to do before).

Thanks, I'll take a look. Do you store the images within the database, or
as separate files linked from the database? I'm considering the latter to
manage size of the database.

Best,
Christopher

 

[Arvin Meyer]

Thanks, I'll take a look. Do you store the images within the database, or
as separate files linked from the database? I'm considering the latter to
manage size of the database.

I always store in separate files, and use something like the code in my
PictureMgr sample app to act as a helper to create the links:

http://www.datastrat.com/Download/Picture2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access