Results 1 to 5 of 5
  1. #1
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206

    Splitting database problem

    When I try to split my database I get this: The database engine could not lock table "xxx" because it is already in use by another person or process.
    I've googled it and can't seam to find the problem. I did the Shift on startup.
    Thanks, Mad-Tom

  2. #2
    Shadow9449 is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Feb 2017
    Posts
    38
    Did you make sure that no one was using the database when you were splitting it? Maybe you opened it, and then while not realizing, you opened it again and tried to split the second instance?

    What I would do is check the folder and make sure that there is no .ldb (pre-2007) or .laccdb (2007 or more recent) file in the folder containing the application you are splitting.

  3. #3
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206
    Only thing open is the database I'm splitting. No .laccdb folders. I'm using Access 365.
    Thanks

  4. #4
    MadTom's Avatar
    MadTom is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jun 2018
    Location
    CT and VT
    Posts
    206
    OK, I didn't close the form in the database! dumb me!!!
    Thanks!

  5. #5
    Shadow9449 is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Feb 2017
    Posts
    38
    Awesome! Good luck

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 08-09-2020, 03:57 PM
  2. Replies: 3
    Last Post: 09-30-2016, 01:43 PM
  3. Problem Splitting a Database
    By euphonium01 in forum Access
    Replies: 4
    Last Post: 06-30-2015, 07:15 AM
  4. Weird problem after splitting DB
    By crowegreg in forum Programming
    Replies: 1
    Last Post: 09-09-2011, 09:50 AM
  5. problem in splitting Date and time fields
    By swaroop1012 in forum Queries
    Replies: 1
    Last Post: 11-22-2008, 11:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums