Switchboard Issues

[AmyK]

I built a dbase that upon opening displays a
switchboard. Today, for some unknown reason, the
switchboard won't open. Instead of opening, I keep
getting an error message that says "Error accessing file.
Network Connection may be lost"

I can't even compact and repair the dbase. I am unsure
of what caused the problem and consequently I don't know
how to fix the problem.

Any suggestions?

 

[Douglas J. Steele]

Unfortunately, that can be a sign of irrecoverable corruption. Hopefully you
have a backup that you can restore from.

See the following KB article
http://support.microsoft.com/?id=304548

 

[AmyK]

I have reinstalled Access, I have made copies of the
dbase, stripped out all traces of the switchboard and
completely rebuilt it and I still get the error. So I
have no idea what to try next...

 

[Van T. Dinh]

As Douglas wrote, your database might have been corrupted irretrievably.

I would suggest creating a new blank database, import all objects except the
[Switchboard Items] Table and Switchboard Form from the existing database.
Try and see if you can use these objects in the new database. If it is OK,
try re-creating the Switchboard.

If the above fails, I think it's time to find your back-up copies ...

HTH
Van T. Dinh
MVP (Access)

 

[Jeff Conrad]

Hi,

Here are some other things to try to recover the database.
From Dirk "Yoda" Goldgar one other thing you might
try first is decompiling your database -- or rather, a
copy of it. Instructions for how to do this may be found
here:

http://www.mvps.org/access/bugs/bugs0008.htm

and here:

http://www.granite.ab.ca/access/decompile.htm
This was also posted recently from someone from Microsoft:

326605 ACC2000: Issues Fixed in Access 2000 by Office 2000
Service Pack 3
http://support.microsoft.com/?id=326605

304548 ACC2000: Error Message: Error Accessing File.
Network Connection May
http://support.microsoft.com/?id=304548

After applying Office 2000 sp3 you are going to need to
salvage your database modules (Standard, Forms/Reports) by
saving them out to text files. Example:

- Open Form/Report in design view and select menu option
View > Code
- Select the menu option Edit > Select All (to select vba
code)
- Select menu option Edit > Copy
- Paste in Notepad file
- Close VBA window to return to Form/Report
- Within the properties Window of Form/Report change the
property "Has Module" from "Yes" to "No"
(this will delete the code behind the object)
- Save your Form/Report
** Repeat above steps for each Form/Report that has code

- For your Standard module just open and copy to text files

- Then import all your objects (within exception of your
Modules) to a new database file
- Copy the code from the above text files into new modules
in your new database
- For the Forms/Reports reverse the steps by opening their
VBA modules and pasting the code from the text files

*******************************
You can also try running decompile switch but the above
methods are normally your only shot..

Regards,

Eric Butts
Microsoft Access
Good luck on getting it fixed,
Jeff Conrad
Bend, Oregon