Skip to Content
0
Former Member
Jul 21, 2008 at 01:16 PM

Aminah

35 Views

I have been creating reports using data on a SQL server. My clients have put a field that they want added to the reports in an access DB. the network guy put the access DB in a folder on the SQL server and I have created an ODBC connection via the start>settings>control panel>Administrative tools.

when I open my report or go to make a new one from scratch I can create a connection to my data on the SQL server using the Database expert, but when I try to create an ODBC(RDO) connection to the access DB using the database expert I get the following:

Logon Failed.

Details: HY000[Microsoft][ODBC Microsoft Access Driver]

The Microsoft Jet database engine cannot open the file '(unknown)'. It is already open exclusively by another user, or you need permission to view its data. [Database Vendor code: -1032]

I have a feeling that the access DB file is not where it should be on the server but this is a new network guy and he just put it in the same folder that contained the SQL tables that we use.