locked
strange problem with MS Access when there're many online users RRS feed

  • Question

  • User77689304 posted

     Hi all,

    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!

     
     Best Regards,
     Tihomir Ivanov

    Friday, January 30, 2009 6:07 PM

Answers

  • User2130758966 posted

     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:

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, January 30, 2009 7:50 PM
  • User-821857111 posted

    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.

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, January 31, 2009 3:57 AM

All replies

  • User2130758966 posted

     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:

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, January 30, 2009 7:50 PM
  • User-821857111 posted

    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.

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, January 31, 2009 3:57 AM