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

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.

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