Can I restore to an older version of a file in Office 2003 Access.

[Guest]

I am using Office 2003 Access and deleted some records. I thought they would
just be deleted from the active query, but they were deleted from the
database altogether. Is there any way that I can retrieve the deleted
records? Unfortunately, I had not backed up my database previous to this so
that is not an option. I also tried system restore, but that to was not of
any help. Please advise. Thank you!

 

[Guest]

Sorry - you just lost them.
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?

 

[Douglas J. Steele]

Unfortunately, they're probably gone.

Take a look at what Tony Toews has at
http://www.granite.ab.ca/access/deletedata.htm

 

[Roger Carlson]

The thing you MUST remember is that a query is just a dynamic window into
your table(s). It does not create a separate copy of your data. If you
delete data from a query you are deleting them from your table. I'd say
you've lost them for good.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

I'm really doubtful that your deleted data can be recovered, but IF you
haven't compacted the database, it's just barely POSSIBLE that a third-party
vendor might be able to retrieve the deleted data for a fee.

Microsoft lists a few vendors on their Knowledge Base article:
"Description of troubleshooting corruption in an Office Access 2003 database"
http://support.microsoft.com/default.aspx?scid=kb;en-us;824271

Check under the heading of "Data Recovery". These vendors generally deal
with corrupt databases, but it's possible that they might be able to help in
your situation.

Hope that helps!

David