Problem accessing Linked tables from ASP.NET

[CaptSx1]

Hi,

I have a linked table in my .mdb file to another database. When i am in access, i can open and query this linked table no problem. However, when i try and query this linked table from my ASP.NET application i get some type of security error.
============================================================
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '<Linked .mdb path and file>'. It is already opened exclusively by another user, or you need permission to view its data.
============================================================

This file isn't opened by anyone else. And the same folder security is set as my other .mdb file is.

Both .mdb files are password protected, and i have a feeling this this may have some cause to this error, but i have no idea on a resolution.

Can anyone help?

Thanks
CaptSx1
:-(

 

[PHV]

Why not accessing the real table instead of te linked one ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886