Hi, I'm using ASP to connect to an ACCESS database (db1) via ODBC.
The table that I connect to (table1) in db1 is an ACCESS query linked
to data in another database (db2).
When I try the connection from a web browser I get the following
message:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine cannot open the file 'M:\db2.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.
/asp_dsk.asp, line 25
All the other postings seem to indicate this is a permissions issue
but I've granted full control on both dbs to "everyone" as well as the
default anonymous internet user.
also, If I open db1 directly from ACCESS and open table1 it opens the
linked data from db2 with no problems.
This was all working fine until about a week ago and I can't figure
out what I must have done to break it. Any ideas?
Tim