Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
The disappearing table act?
- Thread starter strucker
- Start date
Oooh. Yeah. Well...hmmm...do you have a backup? No?
RUN!!!!
Ok, first check the Tools|Options and check the 'show hidden' checkbox, they might have been flagged as hidden, and someone changed that option.
While you're in tools|options, check Show System Objects, and then open a table called MsysObjects. Look in the Name field and try to find the table name there.
If they are not there, then they are definitely gone for good. There is a way if the .mdb was never closed after the deletion that the tables can be restored. But it sounds like this isn't the case.
Often, if someone uses code that does:
Docmd.SetWarnings False
and doesn't turn it back to True, then if you accidentally lean on the delete key, you could totally silently delete every table in the database, or every query, or whatever current tab in the db window is selected. This is a possibility here.
--jsteph
RUN!!!!
Ok, first check the Tools|Options and check the 'show hidden' checkbox, they might have been flagged as hidden, and someone changed that option.
While you're in tools|options, check Show System Objects, and then open a table called MsysObjects. Look in the Name field and try to find the table name there.
If they are not there, then they are definitely gone for good. There is a way if the .mdb was never closed after the deletion that the tables can be restored. But it sounds like this isn't the case.
Often, if someone uses code that does:
Docmd.SetWarnings False
and doesn't turn it back to True, then if you accidentally lean on the delete key, you could totally silently delete every table in the database, or every query, or whatever current tab in the db window is selected. This is a possibility here.
--jsteph
- Thread starter
- #3
Thanks for the reply!
I'm just a kid working on databases for my company and it amazes me the kind of stuff that gets screwed up on a database.
Just to think that at one time I thought you could create a database, use it, and thats it, funny!
I'm just a kid working on databases for my company and it amazes me the kind of stuff that gets screwed up on a database.
Just to think that at one time I thought you could create a database, use it, and thats it, funny!
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question
