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
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