ACC: Microsoft Access, Scanners, and Scanning Software

ID: Q103631

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

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:

Q117923 HP ScanJet IIcx Runs Slowly under Windows 95

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

Q134354 Mustek TrainScan CG-8400 Hand Scanner Does Not Work

Q132777 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:

Use the scanner software to scan the image, and save it in .bmp file format.

Start Microsoft Access. In the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0), open the Employees form.

On the Records menu, click Data Entry.

Select the Photo field.

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.

In the Insert Object dialog box, click Create on the File menu.

Type the full path to your .bmp file you saved in step 1. Note that the scanned image is displayed in the Photo field.

REFERENCES

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          : kbhw 
Version           : 1.0 1.1 2.0 7.0 97
Platform          : WINDOWS 
Issue type        : kbinfo

Last Reviewed: March 25, 1999