ASP connecting to linked table in ACCESS (cannot find the input table or query)

[Tim]

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

[Jim Allensworth]

On 9 Feb 2004 08:05:42 -0800, en****@hotmail. com (Tim) wrote:

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

You might do better in an ASP or IIS group, but take a look at this...

http://www.aspfaq.com/show.asp?id=2009

- Jim

[Tim]

Thank you Jim,

The answer was in article 189408
(http://support.microsoft.com/?kbid=189408) that you provided.

Symptoms
If you access a local Microsoft Access database that is linked to
a table
where the table linked to is in an Access database on a network
server,
you receive the following error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet
Database engine cannot open the file '******'. It is already
opened
exclusively by another user, or you need permission to view its
data.

RESOLUTION
Disable password synchronization for the Internet Information
Server 4.0 application. For IIS 5.0, do not allow IIS to control
the password. To do this, perform the following steps:

I unchecked "Allow IIS to control password" for the anonymous user
account in IIS and all was golden.

Tim