Can't Open asp.net page If MS Access 2003 db is Opened Directly (1 Viewer)

KevinM

Registered User.
Local time
Today, 20:27
Joined
Jun 15, 2000
Messages
719
I have a MS Access 2003 db in a 'db folder' in my web root which has the necessary read/write permissions set.

If I open the db directly ('normal' mode and NOT 'Design' mode) from my server using MS Access (as an Adminstrator) then web users cannot open any asp.net pages connected to it. I get a 'File already in use' error. But no problems if I close the db from within MS Access.

I never had this problem with 'classic asp' using the same folder and it's useful from a testing point of view to be able to have the db opened in MS access at the same time as on the wb (via asp.net).

Is there something I have to set up on my db connection as i'm pretty sure the folder and db permissions are set up correctly at the server end?

Many Thanks
 

Kodo

"The Shoe"
Local time
Today, 15:27
Joined
Jan 20, 2004
Messages
707
set ASP.NET USER and IUSR_ to have modify rights to the FOLDER that the db is in. Make sure these rights propagate down to child objects.
 

KevinM

Registered User.
Local time
Today, 20:27
Joined
Jun 15, 2000
Messages
719
The IUSR_ account had read/write access to the folder and db as does the 'everyone' account.

There is no 'asp.net' account listed. Should there be?

Many Thanks
 

Users who are viewing this thread

Top Bottom