Microsoft Jet Database Engine Error (Access 2000)

[ChiTownDiva]

I need to link to a dBaseIV database, but when I try to in Access 2000 I get this message:

"The Microsoft Jet database enginer cannot open the file 'F:\DATANT\Ntorder.dbf. It is already opened exclusively by another user, or you need permission to view its data"

This only happens in Access 2000. Linking the same dBase IV file works fine in Access 97. My boss gets the same message, so we think there may be some sort of bug in the program.

I installed the Jet 4.0 Service Pack 5 for Windows 2000 and it didn't help.

 

[CFields]

You can use the ODBCConnectStr property in an SQL pass-through query to specify the Open Database Connectivity (ODBC) connection string for the query.

Note The ODBCConnectStr property applies only to pass-through queries.

Setting

Enter the ODBC connection string that defines the connection to the SQL database you want to use.

You can set this property by using the query's property sheet or Visual Basic.

You can also use the ODBC Connection String Builder to create the ODBC connection string for this property. This builder establishes a connection to the SQL database server and then ends the connection after the ODBC connection string is created.

Remarks

The default setting for this property is the string "ODBC;", which Microsoft Access restores if you delete an existing setting. When the ODBCConnectStr property is set to "ODBC;", Microsoft Access will prompt you for a connection string whenever the query is used but won't store the connect string. You must enter a connection string in the ODBCConnectStr property box if you want Microsoft Access to store the connection string.

Tip If you know the full connection string for the SQL database, enter it in the ODBCConnectStr property box. This way you will avoid the need to enter the connection string in the ODBC connection dialog box each time you use the query.

The connection string is different for different types of ODBC data sources. For example, to connect to the Human Resources data source on the HRSRVR server (a Microsoft SQL Server) by using the logon identification (ID) Smith and the password Sesame, you can use the following connection string.

ODBC;DSN=Human Resources;SERVER=HRSRVR;UID=Smith;PWD=Sesame