Can't split a database

[forest8]

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.

 

[Al Campagna]

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."

 

[John Spencer]

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