have used split database but back end database has no tables

[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?

 

[Jeff Boyce]

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

 

[John W. Vinson]

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.

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.