I split my db now can't find objects i created

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a database and split it. Now when I open the be file none of my
forms queries or reports are there. When I try to open the .mdb file it
gives me an error stating that the Switchboard Form is misspelled. Then it
won't open the switchboard and i can't access the database.
 
Are you opening the front end or the back end?
There will be no forms, queries or reports in the back end.
You need to open the front end.

Dorian
 
I created a database and split it. Now when I open the be file none of my
forms queries or reports are there.
Click to expand...

Exactly. That's the idea: the backend (be) file contains the tables,
and only the tables. The forms, queries, and reports are all in the
frontend.
When I try to open the .mdb file it
gives me an error stating that the Switchboard Form is misspelled. Then it
won't open the switchboard and i can't access the database.
Click to expand...

The Switchboard Wizard and the Database Splitter Wizard don't "play
nice" together; the switchboard needs a *local* table named
Switchboard but the splitter sends it to the backend.

Open the frontend .mdb file; delete the Switchboard Table (link) from
the Tables tab; and use File... Get External Data... Import to import
it from the backend. Then open the backend and delete the Switchboard
table from there. The frontend should now work correctly.

John W. Vinson[MVP]
 
Back
Top