asp program trying to open ms access 97 database on network fails

03-28-2006

I try to run http://localhost/scroller/scrollertest.asp in my IE 6
browser.

The asp program tries to connect to a MS Access 97 database.

The program works when the database is sitting on any local drive, but
when I put it on a network drive I get this error message:

Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'g:\test97.mdb'.
It is already opened exclusively by another user, or you need
permission to view its data.
/scroller/scrollertest.asp, line 31

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322;
..NET CLR 2.0.50727)

The file is not opened by anyone else and no password is set to view
its data.

This is the important part of the code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<body>
<%
Dim adoCon
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "g:\test97.mdb"
....

Which permissions are needed?

03-28-2006

First thing to realize is that ASP pages don't run as you. So, while you
may have a drive mapped as G: somewhere, the ASP user doesn't also have this
drive.

Will this database exist on a remote share when the application you're
working on goes into production? If not, I'd leave it on the C drive of
your machine for testing purposes. But, if you need to have it remote like
that, take a look at this article: http://www.aspfaq.com/show.asp?id=2168

Ray at work

<> wrote in message
news: ups.com...
>I try to run http://localhost/scroller/scrollertest.asp in my IE 6
> browser.
>
> The asp program tries to connect to a MS Access 97 database.
>
> The program works when the database is sitting on any local drive, but
> when I put it on a network drive I get this error message:
>
> Error Type:
> Microsoft JET Database Engine (0x80004005)
> The Microsoft Jet database engine cannot open the file 'g:\test97.mdb'.
> It is already opened exclusively by another user, or you need
> permission to view its data.
> /scroller/scrollertest.asp, line 31
>
> Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322;
> .NET CLR 2.0.50727)
>
> The file is not opened by anyone else and no password is set to view
> its data.
>
> This is the important part of the code:
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <body>
> <%
> Dim adoCon
> Set adoCon = Server.CreateObject("ADODB.Connection")
> adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=" & "g:\test97.mdb"
> ...
>
> Which permissions are needed?
>

03-28-2006

Thanks Ray!

The database is on a server on the network.

I followed the link you gave. Then I right clicked 'Default Web Site'
in the Internet Services Manager and chose Properties - Directory
Security - Edit (for Anonymous access and authentication control) -
Edit (for Anonymous access) - unchecked 'Allow IIS to control password
- OK - OK - OK.

Now it works!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Database Database Database Database	scott93727@gmail.com	Computer Information	0	09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase	scott93727@gmail.com	Computer Information	0	09-26-2012 09:40 AM
asp program trying to open ms access 97 database on network fails	damezumari	ASP .Net	0	03-27-2006 09:16 PM
Microsoft JET database error while trying to open excel file from ASP.NET	rh.krish@gmail.com	ASP .Net	2	12-30-2005 05:40 PM
How do I open a database connection on an access file that currently open ?	THY	ASP .Net	4	08-22-2003 03:50 PM