Switchboard items table won't delete

[CW]

After long deliberation I finally decided to follow the frequent advice to
split my database. (Using a copy intially, of course). The wizard failed,
with 2 error msges that I have seen many other posts about - subscript out of
range, and something else. So i decided to do the split manually. Worked OK
and the links are up and everything working. One problem though - when
deleting all the original tables from the new _fe after setting the links to
the new _be, Switchboard Items could not be deleted as it was in use. Well
yes, of course it was, I have to have my switchboard open to get into my
database!!. How does one get around that catch-22 situation?
Many thanks
CW

 

[Dirk Goldgar]

After long deliberation I finally decided to follow the frequent advice to
split my database. (Using a copy intially, of course). The wizard failed,
with 2 error msges that I have seen many other posts about - subscript out
of
range, and something else. So i decided to do the split manually. Worked
OK
and the links are up and everything working. One problem though - when
deleting all the original tables from the new _fe after setting the links
to
the new _be, Switchboard Items could not be deleted as it was in use. Well
yes, of course it was, I have to have my switchboard open to get into my
database!!. How does one get around that catch-22 situation?
Many thanks

I wouldn't move the Switchboard Items table to the back-end; I'd leave it
in the front-end, because it's really part of the application, not the data.

However, if you really want to put the Switchboard Items table in the
back-end, you can usually hold the Shift key down while opening the
database, and thereby prevent the Switchboard form from opening at all.

 

[CW]

OK Dirk thanks for the quick answer. I have no particular desire to move that
table to the back end, I just assumed in my innocence that all tables needed
to be there rather than in the front end, but if it doesn't matter then I
will simply leave it there.
Thanks again
CW

 

[De Jager]

After long deliberation I finally decided to follow the frequent advice to
split my database. (Using a copy intially, of course). The wizard failed,
with 2 error msges that I have seen many other posts about - subscript out
of
range, and something else. So i decided to do the split manually. Worked
OK
and the links are up and everything working. One problem though - when
deleting all the original tables from the new _fe after setting the links
to
the new _be, Switchboard Items could not be deleted as it was in use. Well
yes, of course it was, I have to have my switchboard open to get into my
database!!. How does one get around that catch-22 situation?
Many thanks
CW

 

[joelgeraldine]

ilmmùùù**