If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can't split a database
Hi there
I am currently trying to split my database for my users (since there are 10 of them) but I am getting an error message. It says the following: Database Splitter The database engine could not lock table 'T_ABEA' because it is already in use by another person or process." I'm not sure of how to fix this so any help is greatly appreciated. Thank you in advance. |
#2
|
|||
|
|||
Can't split a database
forest8,
Make very sure no one really has the DB open on another PC. Try to locate a file called (use your own db name) YourDBName.ldb and delete it, if found. I'm thinking that is the best bet as to the problem. If those fail, try splitting the DB manually... Create a MyDBData.mdb Back End File/Import all your tables from your Front End to the BE Link the BE tables to the FE. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "forest8" wrote in message news Hi there I am currently trying to split my database for my users (since there are 10 of them) but I am getting an error message. It says the following: Database Splitter The database engine could not lock table 'T_ABEA' because it is already in use by another person or process." I'm not sure of how to fix this so any help is greatly appreciated. Thank you in advance. |
#3
|
|||
|
|||
Can't split a database
One other thing. When you open the database to split it, hold down the SHIFT
KEY to bypass any code that runs or forms that get opened to ensure that you are not using any of the tables. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Al Campagna wrote: forest8, Make very sure no one really has the DB open on another PC. Try to locate a file called (use your own db name) YourDBName.ldb and delete it, if found. I'm thinking that is the best bet as to the problem. If those fail, try splitting the DB manually... Create a MyDBData.mdb Back End File/Import all your tables from your Front End to the BE Link the BE tables to the FE. |
Thread Tools | |
Display Modes | |
|
|