View Single Post
  #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.