switchboard problem

  • Thread starter Thread starter Advance Scout
  • Start date Start date
A

Advance Scout

Access 97 sr2

Trying to edit my switchboard (which is working fine when application is
running). When I run the Switchboard manager I get the following error "
The Microsoft Jet Database engine cannot find the input table or query
"Switchboard Items". Make sure it exists and is spelled correctly...".

The table is there and spelled correctly.

To be clear- the switchboard is working fine- so Access is finding the
table when it is opening the switchboard... I just can't edit it.
Any ideas as to what may be causing this error message?
 
They can be tricky and that is why many folks roll their own using form,
command buttons, and macros or events.

You must always make a backup or two before messing with the switchboard a
it can totally crash a database.

Can you edit the table instead of using the manager?
 
KARL said:
They can be tricky and that is why many folks roll their own using form,
command buttons, and macros or events.

You must always make a backup or two before messing with the switchboard a
it can totally crash a database.

Can you edit the table instead of using the manager?
Click to expand...
the problem is that the Switchboard manager (or microsoft jet database
engine) is saying it doesn't exist- when it does. So it seems as if the
Switchboard is fine and the Switchboard manager is not. Thats what it
feels like anyway.

and yes I can edit the table - but I'm almost afraid to do that. I guess
I can make a copy of the table first and then see how the edits work
out. But I would still like to figure this puppy out.
 
Advance said:
Access 97 sr2

Trying to edit my switchboard (which is working fine when application is
running). When I run the Switchboard manager I get the following error "
The Microsoft Jet Database engine cannot find the input table or query
"Switchboard Items". Make sure it exists and is spelled correctly...".

The table is there and spelled correctly.

To be clear- the switchboard is working fine- so Access is finding the
table when it is opening the switchboard... I just can't edit it.
Any ideas as to what may be causing this error message?
Click to expand...


It's amazing- go to sleep thinking about it and wake up with the answer,
like an epiphany.

It's a linked table. There is nothing wrong with the switchboard
manager. I had broken my app up into front end and back end. If I open
the BE only- the switchboard manager can find the table and edit the
switchboard.
 
Advance Scout said:
It's amazing- go to sleep thinking about it and wake up with the answer,
like an epiphany.

It's a linked table. There is nothing wrong with the switchboard manager.
I had broken my app up into front end and back end. If I open the BE
only- the switchboard manager can find the table and edit the switchboard.
Click to expand...

I keep the switchboard table in the front-end to avoid this issue. Any
updates appropriately belong to the FE since it's really part of the
application and not the user data.
 
Back
Top