Last post Apr 28, 2009 07:53 AM by shaair
Apr 27, 2009 08:12 AM|shaair|LINK
if Access database is continuously in access so can anyother application can access the database? i have web clint that used to access this databse but at run time it give error that "database already in use".
plz hep me that how can i make connection.plz help me out.
Apr 27, 2009 08:29 AM|nareshprakash|LINK
After using connection, please always close, and when you need then reconnect.
Main problem is that if object is not disposed than connection pooling goes to out of limit so it is throw error. So always close/ disposed connection object after complete your process.
Apr 28, 2009 02:17 AM|Mikesdotnetting|LINK
it give error that "database already in use"
This is a permissions issue. You need to give the user (ASPNET account in XP Pro, or NETWORK SERVICE on Windows Server 2003/8)
MODIFY permissions on the folder that the database is in. That will solve the problem.
However, you should also use OleDb, not ODBC for Access. Otherwise other problems may occur.
Apr 28, 2009 07:53 AM|shaair|LINK
dear problem not going to solve. Excption continusly occor that DB is already in use.