Eeek! VB has just packed up!

[Stephen Glynn]

Access 2000, Windows XP home. VB has suddenly stopped working in one
particular database. When I try, for example, to leave a field with
some code attached to the On Exit event which was working perfectly well
earlier today, I get the message 'Error Accessing File: Network
Connection may have been lost' (I'm on a PC).

When I first OKed this, it opened the debug window at a bit of code that
used to be attached to a button on a form that no longer exists but
which I can see listed in 'Microsoft Access class objects'. I've tried
deleting the code that used to run from that command button, and after
being warned several times that the form no longer existed, I got rid of
the code. But I can still see the form listed as a class object, and
can't get rid of the damn thing. When I try to select it, Access
suggest that the invalid form name may be in a macro; well, I haven't
got any macros.

Help, please.

Steve

 

[Ken Snell \(MVP\)]

Database is corrupted, it appears. Create a new, empty database; then import
all objects/code/etc. from the corrupted database into the new one. This
usually omits corrupted objects such as the one that you cannot delete.

 

[Stephen Glynn]

Thanks a million. That's cured it. Huge sigh of relief!

Steve

 

[Ken Snell \(MVP\)]

You're welcome.

--

Ken Snell
<MS ACCESS MVP>

Thanks a million. That's cured it. Huge sigh of relief!

Steve

 

[Guest]

By the way, have you applied service pack 3? Very important to do so as soon
as possible if you have not already done so. Here's why:

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


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Thanks a million. That's cured it. Huge sigh of relief!

Steve