VBA Class Object error, cannot remove

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

I was creating and copying forms in an Access 200 DB,
trying to copy a form as _GoalEntrySubform. Something got
fouled up, and now I have a corrupted database. None of
my VB code will run (Error Accessing File, Network
connection may have been lost) although I CAN see the code
in the VB Editor.

I DON'T have a _GoalsEntrySubform created, because it
failed, and I can't create one, because it gives me
conflict errors. This got me looking, and I found an
empty "Microsoft Access Class Object" in the VBA editor
that gives me all sorts of errors. Errors when I click on
it, etc. It's linked to the form I tried to create
(Form__GoalEntrySubform) I'm hoping I can fix the problem
by deleting this object, but I CAN'T MAKE THE DARN THING
GO AWAY!

There is no Delete, no Remove, No Cut... all I can do is
select the module, and read the error message (The Form
name is misspelled or referrs to a form that doesn't
exist). HOW do I save my database?

-Pete
 
Trying to fix a corrupted database by deleting objects from it, is rather
unwise, in my opinion. Surly likely to cause more probems!

Create a new database & try to import all your objects to it.

As a matter of general practice, if I even susp[ect that the current
database has become corrupted, I instantly close it, take a copy of it, then
work on or from the copy. Then, if your repairing efforts make the whole
thing fall in a total heap, you are no worse off than you were to begin
with. With your approach, you could easily get to the point where the whole
thing fell in a total heap, & you could not get >anything< back out of it!

HTH,
TC
 
Back
Top