auto said:
i accidently deleted records from my query, table, forms
How can if retrieve them.
I did make a copy of the database before updating it.
How do i locate the copy
have i deleted the records in the copy also
If you copied the whole MDB file to a backup, then unless these are
linked tables, your backup copy should be fine, and will probably be the
only way you can get those records back. Were there any changes in the
database other than the records you deleted, since you made that backup
copy? If not, you can probably just rename or move the current version
of the database, then copy the backup into its place. (If your backup
was on a CDROM, you probably also have to reset set its read-only flag
after copying it back to your hard disk).
If you made other changes to the database since you created your backup,
you'll probably want to take another approach: link from the current
database to the table (or tables) in the backup, and run append queries
to copy records from the backup tables back into your regular tables.
Or I suppose you could do it manually, by copying and pasting records in
the table datasheets.
I'm afraid I can't tell you how to locate your backup copy, if you don't
know where you stored it.
