Error - Accesing a remote Access 2000 database

[rushdib]

Hi,
I have a problem accessing a remote Access 2000 database. Getting the following error
"Microsoft Jet Database Engine cannot open the file path/name of the database. It maybe exlusively opened by another user or do not have permission to view it's data".
I can access this database from the development/test area, but when I deploy this to the web server, it gives the error.
The database has permission for everyone and aspnet user. The folder has permission has permission for everyone.
I tried setting the following in the web.config file
<identitiy impersonate=&quot;true&quot; /> and deployed the file to the web server. It didn't make a difference.
What other configurations I need on IIS and ASP.Net?
Can someone please help me?

Rushdi

 

[Junior1544]

do the users have write access to the directory? the users need to have write access to write the ldb file.

all i can think of off the top of my head, hope it helps.

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[Isadore]

rush: make sure your frontpage extensions are configured properly (one case where I ran into this problem).

 

[rushdib]

Hi,
How do I configure the front page extensions? I don't know whether I am using them.

Rushdi

 

[Isadore]

Go to the Control Panel, Administrative tools, then IIS, then right click on virtual file where tables are stored, open up permissions wizard (frontpage extensions. That's helped me solve this problem a couple of times. There are other less subtle issues re: dot.NET permissions, but have not had to look into that (you can contact Microsoft - they have solutions set up for this problem).

 

[rushdib]

Fixed the problem. Check out the following site.

http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=159108