ACC07: Can't delete module object

  • Thread starter Thread starter John
  • Start date Start date
J

John

I probably have some kind of corruption on my accdb file---I've tried
disable autoName feature, compacting and repairing, importing into new
db. Nothing works.

When I try to delete the Module1 object in the navigation bar, it
deletes but then immediately reappears. I'm also getting "name
conflicts with existing module" error. How can I get rid of the
Module1 object? What about deleting from the MSysObjects table (if
that's even possible)?

Thank you...
 
After deleting it, try a compact/repair:
Office Button | Manage

If that doesn't work, the next step would be to create a new (blank) ACCDB,
and then import all the other objects (except the spurious Module1.)

For general suggestions on recovering a problem database, see:
Recovery sequence
at:
http://allenbrowne.com/recover.html
 
John said:
I probably have some kind of corruption on my accdb file---I've tried
disable autoName feature, compacting and repairing, importing into new
db. Nothing works.

When I try to delete the Module1 object in the navigation bar, it
deletes but then immediately reappears. I'm also getting "name
conflicts with existing module" error. How can I get rid of the
Module1 object? What about deleting from the MSysObjects table (if
that's even possible)?

Thank you...
Click to expand...
 
Back
Top