Splitter error after making back end file.

C

Chris v.

In Access 2007, after the splitter makes the back end file, I get the error
messege "Subscript out of range." and no front end file is created. What
does this error messege mean? Do I have to split the database and link the
files manually?
 
A

Arvin Meyer [MVP]

Chris v. said:
In Access 2007, after the splitter makes the back end file, I get the
error
messege "Subscript out of range." and no front end file is created. What
does this error messege mean? Do I have to split the database and link the
files manually?

I always do it manually. It only takes a couple of minutes and works 100% of
the time.

First make 2 copies of the file.

Rename 1 App.mdb and delete all the tables, then compact it.

Rename the other Data.mdb and delete everything but the tables and compact
it.

Link the tables from Data.mdb to App.mdb

Put Data.mdb on the server, and a copy of App.mdb on the server as a backup.

It took me about the same amount of time to explain it, as to do it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top