Splitting Database

Hopefully someone can help me out on this.

So I want to split my database and I am having some trouble viewing the
front end. When I go under TOOLS- DATABASE UTILITIES-DATABASE SPLITTER, it
saves the back end ( name of database_be.mdb). Now how do I view the front
end?

thanks!

stacy05 wrote:
Hopefully someone can help me out on this.

So I want to split my database and I am having some trouble viewing
the front end. When I go under TOOLS- DATABASE UTILITIES-DATABASE
SPLITTER, it saves the back end ( name of database_be.mdb). Now how
do I view the front end?

thanks!

The front end is the file you are currently in when you run the splitter.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

The only way to go through with the splitting is to close my Switchboard and
then split the database. The problem is that i want to switchboard(and the
queries and reports) to be my front end and the tables to be the back end.

any ideas?

"Rick Brandt" wrote:

stacy05 wrote:
Hopefully someone can help me out on this.

So I want to split my database and I am having some trouble viewing
the front end. When I go under TOOLS- DATABASE UTILITIES-DATABASE
SPLITTER, it saves the back end ( name of database_be.mdb). Now how
do I view the front end?

thanks!

The front end is the file you are currently in when you run the splitter.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

stacy05 wrote:
The only way to go through with the splitting is to close my
Switchboard and then split the database. The problem is that i want
to switchboard(and the queries and reports) to be my front end and
the tables to be the back end.

any ideas?

I think there is a basic misunderstanding here. The splitter merely moves your
tables out of the "all in one" file into another file and then creates links to
them in the "formerly all in one" file. The file that you run the splitter
wizard in BECOMES the front end file after the split is completed.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Thu, 28 Dec 2006 07:51:00 -0800, stacy05
wrote:

The only way to go through with the splitting is to close my Switchboard and
then split the database. The problem is that i want to switchboard(and the
queries and reports) to be my front end and the tables to be the back end.

It sounds like you're using the Switchboard Wizard generated
Switchboard form.

The Switchboard Wizard and the Database Splitter Wizard don't get
along at all well (the story goes that one of them put some henbane in
the other's magic potion back at Hogwarts, but I don't know for sure).

The Switchboard requires that there be a LOCAL (not linked) table
named Switchboard in the frontend; the splitter wizard exports it to
the _be file along with all the other tables.

Solution: open your frontend (the database you started with) holding
down the Shift key to bypass the autoexec form. Delete the link to the
Switchboard table (just select Switchboard in the Tables window and
press the Delete key). Use File... Get External Data... Import to
import Switchboard (only) from yourdatabase_be. Close the database;
open the backend and delete Switchboard.

Now open your frontend again and see if it works for you.

John W. Vinson[MVP]