Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

splitting a database - where does front end file go? 1

Status
Not open for further replies.

psimonnyco

Programmer
Jan 18, 2008
23
US
Hello

I am splitting my 2007 .mdb by using the Database Splitter. I am following these directions I see that the back end (be) file is created but I'll be damned if I can figure out where the front end file is going.

Any ideas?

Thanks.

How to Split a Microsoft Access Database
Splitting a database into front and back ends is easy when you use the Database Splitter utility. To split a database:

In Access 2003, open the database to be split.
From the main menu, choose Tools » Database Utilities » Database Splitter.
Click the Split Database button.
The default file name for the back end will appear as DatabaseName_be.mdb. If necessary, rename the file.
Browse to the server and directory where the file will be housed.
Click the Split button.

It may take a considerable amount of time for the split process to be completed, depending on the size and complexity of the database, the speed of the computer, and so forth.
Click OK to dismiss the message that appears when the split is complete.
Test both ends of the database to confirm that the proper links have been created and security has been implemented.

 
The original mdb is the front end. The new one is the back end...

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top