ACC: Microsoft Access, Scanners, and Scanning Software (103631)

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.