Database conection with linked tables. 1

[JimFlower]

I have a database conection to an access database

When I connect to a table in that database I get a set of records.

But when I'm trying to conect to a linked table in the same database I get the following message:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file 'x:\database\xxxDATA.MDB'. It is already opened exclusively by another user, or you need permission to view its data.
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Drivers

The 'x:\database\xxxDATA.MDB' database is a live database which has many users.

Is there something I can do to make this work without moving
xxxDATA.MDB

 

[Palooka]

Hi

This is a "common" error, and most likely you'll find both the cause and the solution for your problem on this page:

http://support.microsoft.com/support/kb/articles/Q189/4/08.ASP

If not, it's probably here:

http://support.microsoft.com/support/kb/articles/q183/0/60.asp

Hope this helps,
Palooka