A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can't split a database



 
 
Thread Tools Display Modes
  #1  
Old April 12th, 2010, 08:45 AM posted to microsoft.public.access.gettingstarted
forest8
external usenet poster
 
Posts: 196
Default 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  
Old April 12th, 2010, 01:09 PM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default 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  
Old April 12th, 2010, 02:19 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.