VBScript – Sample Microsoft Office Access ( MS Access ) – TroubleShooting

Background

Here are some areas to review if you run into problems accessing a Microsoft Office Access DB via an OLE-DB Provider.

 

TroubleShooting

Microsoft

Task Manager

Image

Explanation

  1. Bitness
    1. On a 64-bit machine, make sure you are running as a 32-bit app

Resource Monitor

Image

Highlight

  1. C:\Program Files (x86)\Common Files\Microsoft Shared\Office14
    • ACEOLEDB.DLL
  2. C:\Program Files (x86)\Common Files\System\ado
    • msado15.dll
    • msadrh15.dll
  3. C:\Program Files (x86)\Common Files\System\OLE DB
    • oledb32.dll
    • oledb32r.dll

 

Registry

Microsoft.ACE.OLEDB.*

Search the registry for Microsoft.ACE.OLEDB

Image

UDL File

  1. National Instruments
    • Creating a Microsoft Data Link file (UDL) for Connecting to a Database in LabVIEW
      Link
  2. Microsoft
    • Microsoft | Developer
      • Chaitanya Medikonduri
        • How to run 32-bit UDL file on a 64-bit Operating System
          Link

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s