switchboard in split databsae

[lou]

I'm using Access 97 with Windows XP. I set up and database
which includes a switchboard. I later split the database
into a front and back end. Everything works fine except
when I try to change the switchboard using the switchboard
manager I get an error message stating that it can't find
the switchboard table. The table is there and is linked and
refreshed. Any ideas?

 

[Jeff Conrad]

Hi,

If I remember correctly, if you use the built-in Access
Switchboard Manager the Switchboard Items table needs to
reside in the front end, not the back end to work properly.

Hope that helps,
Jeff Conrad
Bend, Oregon

-----Original Message-----
I'm using Access 97 with Windows XP. I set up and
database which includes a switchboard. I later split the
databaseinto a front and back end. Everything works fine
except when I try to change the switchboard using the
switchboard manager I get an error message stating that
it can't find the switchboard table. The table is there

and is linked and refreshed. Any ideas?

 

[John Vinson]

I'm using Access 97 with Windows XP. I set up and database
which includes a switchboard. I later split the database
into a front and back end. Everything works fine except
when I try to change the switchboard using the switchboard
manager I get an error message stating that it can't find
the switchboard table. The table is there and is linked and
refreshed. Any ideas?

The Switchboard code requires that the table named Switchboard be
local to the frontend database. For some unaccountable reason the
database splitter wizard doesn't know this (the programmers worked in
different buildings maybe) and moves the table to the backend anyway.

Delete the link to Switchboard, use File... Get External Data...
Import to import the Switchboard table from the backend into the
frontend, and then open the backend and delete Switchboard. That
should get it working again.