deleted files ????????

  • Thread starter Thread starter speezack
  • Start date Start date
S

speezack

Boy have I screwed up !!!!!!!!!!!!!!!!!!!!

I was trying to start another file for 04.......... so what I did was
highlite all the records and hit the delete button then I wanted to
save this as the same file with an "04" at the end of the file
name.... which I thought would save the way it was set up............
boy did I f--- up !!!!!!!!!!!!!!!!!!!!!!

all is gone now although I did not hit the save button afterwards, I
thought I could just close and reopen and fix it but that obviously
did not work............ big mistake...........

well, is there any way to recover these files...............?

the set up on the table is still there but no records !!!!!!!!!!!!!!

thanks for whatever help is available.............. I fear all is
lost.

Bill
(e-mail address removed)
Bill
(e-mail address removed)
 
Deleted records do not go to the reycle bin, that is for deleted files
saved on the hard drive. They just go away.
If you did save on your hard drive, have you done backups? That would
be the only way to restore the missing records, to the best of my knowledge.
I save EVERYTHING I do on our network. That is backed up everyday, 52
days a week.
On my home computer, I make backup copies on Zip disks or e-mail to work
and them save to network. If my computer goes up in cloud of smoke, I
still have all my stuff.
 
Boy have I screwed up !!!!!!!!!!!!!!!!!!!!

I was trying to start another file for 04.......... so what I did was
highlite all the records and hit the delete button then I wanted to
save this as the same file with an "04" at the end of the file
name.... which I thought would save the way it was set up............
boy did I f--- up !!!!!!!!!!!!!!!!!!!!!!

all is gone now although I did not hit the save button afterwards, I
thought I could just close and reopen and fix it but that obviously
did not work............ big mistake...........

well, is there any way to recover these files...............?

the set up on the table is still there but no records !!!!!!!!!!!!!!
Click to expand...

Are you deleting *FILES* - files stored on disk in a directory? or
*RECORDS IN A TABLE*? If the latter, as it appears, your only hope
(given that you have closed and reopened the database) is either a
backup copy of your .mdb file (backups are *absolutely* essential for
this and other reasons), or Peter Miller's database salvage service at
http://www.pksolutions.com. Bring your checkbook or credit card.

Note that Access does not store "files", and that putting 04 on the
end of a table name is *very bad design*. A date is data; it should be
stored in a table, as data, not as part of a tablename or fieldname.
There is no "save button" for saving records in a table; when you
delete a table record, it's deleted. That's why you should generally
store all your records permanently (unless they are clearly wrong or
need to be deleted permanently for security reasons), and use Queries
to select subsets of records (say all the records for 2003).
 
Back
Top