Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/103631

From BetaArchive Wiki
Knowledge Base

ACC: Microsoft Access, Scanners, and Scanning Software

Article ID: 103631

Article Last Modified on 1/18/2007


  • 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


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

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


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.


For more information about this topic, search the Help Index for "inserting linked objects," or ask the Microsoft Access 97 Office Assistant.

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

Additional query words: ole twain

Keywords: kbhardware kbinfo KB103631