Microsoft KB Archive/103631

= ACC: Microsoft Access, Scanners, and Scanning Software =

Article ID: 103631

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q103631



SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills.

This article contains general information about Microsoft Access and scanners and scanning software.



MORE INFORMATION
To scan an image into Microsoft Access, you need both a scanner and scanning software.

The following is a list of scanners that are currently supported by all versions of Microsoft Windows:

  Scanner        Manufacturer --  ScanJet        Hewlett-Packard ScanMan       Logitech Hand Scanner  Marstek

The Hewlett-Packard (HP) ScanJet provides TWAIN compliance, the industry's standard protocol for scanning and acquiring graphics from software applications.

If the software that comes with the scanner saves the image in a format that a Windows graphics program can recognize, Microsoft Access can display the image.

The following is a list of graphics software packages and their currently supported formats in Microsoft Windows (all versions):

  Software     Graphic Formats Image-In    .BMP .EPS .TIF CorelDRAW   .BMP .EPS .TIF .PCX Paintbrush  .BMP .PCX .MSP .DIB

Image-In is a computer-aided design (CAD) graphics software package that ships with the Marstek Hand Scanner.

NOTE: In Microsoft Windows 95, please see the Hardware.txt file and Program.txt file on the Microsoft Windows 95 CD-ROM. Also, for additional information, query on the following words in the Microsoft Windows Knowledge Base.

  scanner* win95

For more information about scanners with Microsoft Windows 95, please see the following articles in the Microsoft Windows Knowledge Base:

117923 HP ScanJet IIcx Runs Slowly under Windows 95

129416 Loading HP ScanJet IIcx Driver Causes CD-ROM to Fail

134354 Mustek TrainScan CG-8400 Hand Scanner Does Not Work

132777 Twain32 (for NT) Scanner Driver Does Not Work in Windows 95

The following procedure explains how you can use Paint in Windows 95 (or Paintbrush in Microsoft Windows 3.1x) to bring an image into Microsoft Access from a scanner:


 * 1) Use the scanner software to scan the image, and save it in .bmp file format.
 * 2) Start Microsoft Access. In the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0), open the Employees form.
 * 3) On the Records menu, click Data Entry.
 * 4) Select the Photo field.
 * 5) In Microsoft Access 7.0 or 97, click Object on the Insert menu. In versions 1.x and 2.0, click Insert Object on the Edit menu.
 * 6) In the Insert Object dialog box, click Create on the File menu.
 * 7) Type the full path to your .bmp file you saved in step 1. Note that the scanned image is displayed in the Photo field.

