473,322 Members | 1,755 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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
Nov 12 '05 #1
2 5523
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
Nov 12 '05 #2
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
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Noah | last post by:
freeBSD 4-8 STABLE cant install Python-2.3.3 configure: creating ./config.status config.status: creating Makefile.pre config.status: creating Modules/Setup.config config.status: error:...
0
by: TERMAN, IRA, ALABS | last post by:
Hello, I am trying to install Python-2.3. I get the following error when I run ./configure --with-csx=gcc on my Solaris machine. config.status: error: cannot find input file:...
0
by: Tim | last post by:
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...
2
by: dskillingstad | last post by:
I'm building a tracking system and I'm having some problems. I thought this was relatively easy, but.... I have the following tables and fields (abbreviated): tblPermitMain PermitID - pk...
0
by: Bob | last post by:
Just thought I'd share my experience today with this error message. I received it when doing an .update on a recordset .add. The fieldname that the error message included wasn't even in the table...
3
by: Rahul B | last post by:
Hi, I have a user UCLDEV1 which is a part of staff and a group(db2schemagrp1) to which i have not given any permissions. The authorizations of that user are shown as db2 =get authorizations...
6
by: warpcon | last post by:
Im trying to build a database starting with one of the templates that come with access. I took out the employee part in all the tables and forms. Now when I pull up a workorder and then try to view...
1
by: vivek samantray | last post by:
I have a query.When i try to create a index on one of the table the index gets created but when i take the output it stuill shows "TABLE ACCESS FULL" Please see below what i did QUERY ======...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.