Error Connecting to MS Access

Posted August 8th, 2007 by margie

I have the Data UpLoader to MS Access. When I try to connect to my Access 2000 database I get an error that indicates there is security on the database, but there is not.

‹ Run Data Uploader from a command line?

Connecting to Access

On August 8th, 2007 jterrell said:

This can happen if the Access database to which you are trying to connect is "joined" with a different Workgroup Information File (WIF) than the default WIF that is used at startup. The default WIF filename is usually SYSTEM.MDW. The WIF to which the database is "joined" may have the same filename (but resides in a different folder) than the default WIF, or it may have a different filename.

Follow these steps to try to resolve the error:

  1. Locate the WIF (.MDW) to which the Access database is joined, and verify that it resides on your workstation or is accessible on a network drive.
  2. On the Target tab in the Data UpLoader to MS Access, locate the target property option labeled "SystemDatabase", and click on the ellipsis in the Value cell for that property.
  3. Navigate to the drive and folder in which the required WIF resides, and select the .MDW file.
  4. If there is no security on the Access database to which you are connecting, leave the User ID and Password boxes blank in the connection section of the Target tab.
  5. Click on the down arrow in the Target Table/View box and select the target table to which you want to write the data.

Please let me know if this does not resolve the problem for you.

That Worked

On August 9th, 2007 margie said:

It took me a while to figure out where the .mdw file was located but once I did it worked. Thank you!