Problem opening Connection from ASP application

[Michael Z.]

Hello, everybody. My asp application needs to access an Access 97 Database
located on the network. When the application tries to open an ADO connection
to this database I receive the following error:

Microsoft JET Database Engine error '80004005'

The Microsoft Jet database engine cannot open the file '\\NYINTPROP\LEASE\lease.mdb'.
It is already opened exclusively by another user, or you need permission
to view its data.

/Time7/global.asa, line 7

I know the problem has something to do with permissions, because only certain
users have permission priveledges to the share where this database is. Do
you know what user account does IIS 4.0 use when it opens a connection to
a database on the network and what additional rights it would need to be
able to open the database successfully.

Thanks to everybody in advance for help.

[Douglas J. Steele]

IUSER_machinename needs to have Change permission (RWXD) on the folder where
the Access database is located.

--
Doug Steele, Microsoft Access MVP
http://i.am/DougSteele/


"Michael Z." <yz64@aol.com> wrote in message
news:3b0a8cac$2@news.devx.com...
>
> Hello, everybody. My asp application needs to access an Access 97
Database
> located on the network. When the application tries to open an ADO
connection
> to this database I receive the following error:
>
> Microsoft JET Database Engine error '80004005'
>
> The Microsoft Jet database engine cannot open the file
'\\NYINTPROP\LEASE\lease.mdb'.
> It is already opened exclusively by another user, or you need permission
> to view its data.
>
> /Time7/global.asa, line 7
>
> I know the problem has something to do with permissions, because only
certain
> users have permission priveledges to the share where this database is. Do
> you know what user account does IIS 4.0 use when it opens a connection to
> a database on the network and what additional rights it would need to be
> able to open the database successfully.
>
> Thanks to everybody in advance for help.