Results 1 to 3 of 3
  1. #1
    SltPhx is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    41

    Database Splitting Error


    Hello All,
    I am trying to split a database that has two tables and 1 form - this is the message I get when I hit "split database" -
    Database Splitter:
    The database engine could not lock table " because it is already in use by another person or process

    I am not sure what it means and how to come around it. Kindly help me.

    Thank you so much for your time and help.

  2. #2
    razors1968 is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    18
    Do you have any tables open?

  3. #3
    SltPhx is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    41
    No! Tables were not open... but the the form was open - as in, anytime the database was opened the form would also be opened. I designed it such a way that the Form would also open when the database is opened.
    I changed that setting and then I was able to open it.

    Thank you so much for the idea!

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

Similar Threads

  1. Splitting my database.
    By bcox9 in forum Access
    Replies: 7
    Last Post: 12-17-2011, 06:23 PM
  2. Error when splitting database
    By blkmagic in forum Access
    Replies: 1
    Last Post: 09-30-2011, 04:55 PM
  3. Splitting Database
    By injanib in forum Database Design
    Replies: 0
    Last Post: 02-25-2011, 11:08 AM
  4. splitting database
    By colotazzman in forum Database Design
    Replies: 2
    Last Post: 02-10-2011, 09:12 PM
  5. Database Splitting
    By Matthieu in forum Access
    Replies: 8
    Last Post: 02-08-2010, 03:37 PM

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