I just tested your theory, and I was able to recover my deleted table. This
is what I did: I copied a working Access 2K mdb file, and opened the copy.
I created a new test table, then deleted it. Then I deleted another table.
Then I created a new query, a new form and a new module. In the new module,
I copied the code from the Access 2K recovery method and pasted it into the
module, saved and compiled. Then I created another new table. All of these
activities wrote to the db file.
I ran the code and recovered not only the table I deleted, but the first test
table I created and deleted.
So you must have done something more than just write to the db in a new
module for the code to fail. Did you close the db prior to the recovery?
The code won't work if you close, then reopen the db.
You can find services on the Internet that will recover your deleted table,
but they're expensive. It's best to have recent backups.
Message posted via AccessMonster.com