Last post Aug 30, 2008 02:33 AM by Mikesdotnetting
Aug 28, 2008 11:38 AM|amodius|LINK
hi, my application use microsoft access as dataabse
If my boss open this databas, my application return an error "unable to use '', database already on use"
however, in my machine of test this not occurs!! WOW
this error also is verified when application asp.net generate error during write or read data from database
on sql server this is nerer verified!!!
how i can adjust this error?
there are some tips?
this is a hight dangerous error!!, i must restart the server every time this error occur!!!
Aug 28, 2008 11:53 AM|Matt-dot-net|LINK
Microsoft Access is not designed for use in a web application. You need to switch to SQL Server.
Aug 28, 2008 03:32 PM|amodius|LINK
i'm sorry, in my server there aren't too much RAM :(
and there aren't space ...access is the one choise :(
Aug 29, 2008 09:58 AM|Matt-dot-net|LINK
Then you are going to have these problems. Access does not handle multiple users.
Aug 29, 2008 04:12 PM|amodius|LINK
oh nooooooo :(
i can't use other databse :(
if i use a try..cath with transaction and 5 second of timeout of execution of query??
this need to resolve some part of the problem?
Aug 29, 2008 04:17 PM|amodius|LINK
Aug 29, 2008 04:30 PM|amodius|LINK
Aug 30, 2008 02:33 AM|Mikesdotnetting|LINK
The problem is that you have not applied the correct permissions to the folder
in which the database file sits. You need to apply MODIFY permissions to the
NETWORK SERVICE account.