Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012
    Posts
    8

    Unanswered: Backend locked then unrecognized format twice

    I setup a backend-frontend on a network location, which was working fine for ~30 minutes.

    On two difference occasions, two different users have accessed their own accde front end, which has locked the backend for every other user including myself.

    When I had them exit the front end and try to re-open it, they would be met with the Unrecognized Database Format error.
    The lock file that was created for the backend when they opened their frontend, would remain even after closing the file - this part of the issue?

    All other users would still be receiving the File is Already In Use error even at this point, irrespective of trying to open their frontend, or the backend.

    Deleting the lock file (.laccdb), results in every user receiving the Unrecognized Database Format error.

    By moving the backend to a different location, and opening it, access claims the database is in an incosistent state and manages to recover all the data without error

    The user's involved all have write access to the network folder, and i've setup the fodler as a trusted location in access

    Any help with sorting this would be much appreciated

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by deamo View Post
    I setup a backend-frontend on a network location, which was working fine for ~30 minutes.

    ...two different users have accessed their own accde front end, which has locked the backend
    Just to be clear, each user has a copy of the Front End on their hard drive; they aren't accessing a single copy of the Front End located on the network, correct?

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jun 2012
    Posts
    8
    Yes, each user has their own copy of the Front end that they are accessing.

    Edit, using Access 2010. Have uploaded a copy of the original non-split database if that's of any help.
    Attached Files Attached Files
    Last edited by deamo; 11-04-12 at 19:53.

Posting Permissions

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