have used split database but back end database has no tables

  • Thread starter Thread starter Maniceye
  • Start date Start date
M

Maniceye

Hi

I'm trying to split an Access 2007 database into a front and back end to
share on a network. Unfortunately, the resulting back end database ends up
with no tables.

Any ideas?
 
You don't mention "how" you are trying to split it.

Here's an approach:

Create two copies of your database.

Open one copy and take out all the tables.

Open the other copy and take out everything except the tables.

Now re-open the first one (no tables) and "link" (not import) the tables in
the second.


Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You don't mention "how" you are trying to split it.

Here's an approach:

Create two copies of your database.

Open one copy and take out all the tables.

Open the other copy and take out everything except the tables.

Now re-open the first one (no tables) and "link" (not import) the tables in
the second.
Click to expand...

Just be sure to do this on the *second and third* copies of your database -
keep the original! and use Tools... Database Utilities... Compact and Repair
on BOTH databases after you're done.
 
Back
Top