Access won't allow table to be deleted

M

MT_dma

I have a table in an Access database that when I try to delete it nothing
happens (I also cannot open it or view it in design view). Then when I try to
go to another form, table, query etc. I get the following error message: This
action will reset the current code in break mode. Do you want to stop running
the code? If I click yes the the error message does not go away. It will only
go away when I click no. Then I get the same error message when I try to
close any open item. I then have to Ctrl+Alt+Delete to close the database. I
have tried to export the table to another DB and the same thing happens. Any
clues to why this would happen and how I can delete the table? Any help is
much appriciated.
 
D

Dirk Goldgar

MT_dma said:
I have a table in an Access database that when I try to delete it
nothing happens (I also cannot open it or view it in design view).
Then when I try to go to another form, table, query etc. I get the
following error message: This action will reset the current code in
break mode. Do you want to stop running the code? If I click yes the
the error message does not go away. It will only go away when I click
no. Then I get the same error message when I try to close any open
item. I then have to Ctrl+Alt+Delete to close the database. I have
tried to export the table to another DB and the same thing happens.
Any clues to why this would happen and how I can delete the table?
Any help is much appriciated.
Click to expand...

I don't know, but it sounds to me like that table may be badly
corrupted. See if this works: create a new blank database, and import
into it all objects from the old database *except* that table.
 
M

MT_dma

I already imported all the objects, except that table and the "new" database
does work fine. I was more wondering how this happened and how to avoid it in
the future... Maybe it's just one of quirky Access things that happen from
time to time??

Thanks for your help.
 
J

Jeff Conrad

in message:
I already imported all the objects, except that table and the "new" database
does work fine. I was more wondering how this happened and how to avoid it in
the future... Maybe it's just one of quirky Access things that happen from
time to time??
Click to expand...

You might want to review MVP Allen Browne's excellent
article on preventing corruption. You can find it here:

http://allenbrowne.com/ser-25.html
 
D

Dirk Goldgar

MT_dma said:
I already imported all the objects, except that table and the "new"
database does work fine. I was more wondering how this happened and
how to avoid it in the future... Maybe it's just one of quirky Access
things that happen from time to time??
Click to expand...

In addition to the link that Jeff posted, you may want to check out Tony
Toews' Corrupt MDB FAQ page:

http://www.granite.ab.ca/access/corruptmdbs.htm
 
Top