Last post Jan 31, 2009 03:57 AM by Mikesdotnetting
Jan 30, 2009 06:07 PM|tihomir_wwf|LINK
I've developed a site (asp.net 2.0 using MS Access for database, running on Windows 2003). The site works fine when 10-20 users are online in meantime. But when their count reaches 30, the site receives following error:
Could not use "; file already in use
Exception Details: System.Data.OleDb.OleDbException: Could not use "; file already in use.
The exception occurs when OleDbConnection's method Open is called.
Methods Close of OleDbConnection is called always after Opening. Also, I don't think it's permission problem cause site works fine for 10-20 users online in meantime.
Is the problem result of using MS Access as database or the problem could be solved ?
Thank you very much in advanced!
Jan 30, 2009 07:50 PM|rtpHarry|LINK
Its not designed for major use. Is the project too far along for you to change to a proper sql solution?
You can get a free version of sql server 2008 called sql server 2008 express.
Look on the express website:
Jan 31, 2009 03:57 AM|Mikesdotnetting|LINK
If you have too many users, the site just slows to a crawl. Your error message is a permissions-related one. Make sure that the "user" account has "MODIFY" permissions on the folder in which the database is located. On Win 2k3, the users
is NETWORK SERVICE, unless you are using impersonation, in which case it's the IUSR_machinename account.
A "user" in the context of an Access database only exists at the point that Conn.Open() is called, and ceases to exist at the point that conn.Close() is called. In other words, a user is an active open database connection. So 30 people visiting your site
is not heavy traffic for Access, as most of the time, they are inactive as far as Access is concerned. They are simply looking at pages.