ACC: Microsoft Access, Scanners, and Scanning Software

Last reviewed: May 15, 1997
Article 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, both a scanner and scanning software are required.

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:

   ARTICLE-ID: Q117923
   TITLE     : HP ScanJet IIcx Runs Slowly under Windows 95

   ARTICLE-ID: Q129416
   TITLE     : Loading HP ScanJet IIcx Driver Causes CD-ROM to Fail

   ARTICLE-ID: Q134354
   TITLE     : Mustek TrainScan CG-8400 Hand Scanner Does Not Work

   ARTICLE-ID: Q132777
   TITLE     : 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. Scan the image and save it in .bmp file format using the scanner software.

  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 from File.

  7. Type the full path to your file. 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 : EvnOs kbhw
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 15, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.