Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    6

    Unanswered: Application/database locking up

    I have an application (front end) written in access 2000 with a database (access 2000 as well) in the back end. The application (front end) works in the client's machines and the database is sitting in a share drive in the network. The system was running fine and it started locking up. When it happens it does not let any user add, edit or delete records from the database. There is no errors whatsoever, nothing, it just locked. After a few minutes (sometimes a few hours) it unlocks by itself. This application had a few users and now has probably 25 or so. Any ideas what is going on?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    25 concurrent users? Access backend? This would be pushing limits -- especially if the application is using bound forms. I'd say that has something to do with it.

    Might be time to migrate to SQL Server.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •