Switchboard

  • Thread starter Thread starter Mark Mesarch
  • Start date Start date
M

Mark Mesarch

I had a previous message about this. After accidently
deleting my Switchboard form, I tried to creat a new
one...I delete the Switchboard Items inthe tables. Going
back to the switchboard utilitites I was prompted to
create a new switch board. But when I try to open the
switchboard I get an error message of "The expression ON
Open you entered as the event property setting Produced
the following error: Error accessing the file, Network
connection might have been lost."
 
Hi Mark,

Private Sub YouGotBigProblemsNowMark()

I think you've been stung by a particularly nasty bug in
Access 2000. Sure sign is that dreaded "Network Connection
may have been lost.." messsage. Details about it can be
found here:

http://support.microsoft.com/?id=304548

The corruption in your database may not be recoverable.
You might try importing everything into another database.
I believe this bug is fixed with Service Pack 3, but it
will not *fix* corruption already present. To avoid this
bug you absolutely, positively, have to compile your
database EVERY time you import something.

Also, (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..


I hope this helps! If you have additional questions on
this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access
End Sub

Good luck,
Jeff Conrad
Bend, Oregon
 
Back
Top