Access 2003 Database Splitter

[ZVIKA]

As I complete the Data base and split it into two files by running the
Database Splitter, I get two files (for example: xxx.mdb and xxx_be.mdb).
But when I transfer these two files to another folder (both) - the result
is: A message they don't recognize and can't open.

 

[Jeff Boyce]

The reason for splitting a database is to put the data in one (that would be
the xxx_be.mdb file) and all the other pieces in the other (that's the
xxx.mdb).

If you used the splitter/wizard, it should have linked from the front-end
(xxx.mdb) to the tables in the back-end (xxx_be.mdb). Note that the
splitter would have "explained" the location of the back-end to the
front-end WHEN IT WAS RUN.

You moved the files. Now the front-end doesn't find the back-end where it
thought it was. You'll have to re-link the tables to point to the new
location.

And you'll need to make a copy of that new updated front-end available on
each user's PC, not a single copy somewhere on the network.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dale Fye]

To relink the files, you will need to use the Linked table Manager.

Tools -> Database Utilities -> Linked Table Manager

HTH
Dale