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.