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!

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?


"tbonmsn" wrote:

> 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!

Unfortunately, they're probably gone.

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"tbonmsn" <(E-Mail Removed)> wrote in message
news:855BB30E-B9CD-4C9D-90CA-(E-Mail Removed)...
>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!

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/...UBED1=ACCESS-L


"tbonmsn" <(E-Mail Removed)> wrote in message
news:855BB30E-B9CD-4C9D-90CA-(E-Mail Removed)...
> 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!

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...b;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

"tbonmsn" wrote:

> 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!