how to recover Access data after automatic reboot?

[pemt]

Dear all,

During a run of my Access query, an automatic update restarted my computer.
This query has been run for a few days.
Does anyone know how to recover the data from this situation?
By the way, I don't know that whether my query was done or not before the
reboot.

Thanks,

pemt

 

[Stefan Hoffmann]

hi,

During a run of my Access query, an automatic update restarted my computer.
This query has been run for a few days.
Does anyone know how to recover the data from this situation?

First of all, do not touch you database file before making a backup copy.

The problem is that there is no such indicator.

You may try a professional recovery service or run some control
(validation) queries to decide if it was finished gracefully.

Also a query running that long indicates a lack of performance, so
tuning your query may be an option.


mfG
--> stefan <--

 

[Jerry Whittle]

We need a lot more information.

This query has been run for a few days.

Does this mean that the query has been working for a few days OR that it has
actually been running for a few days?

Was it a select query or an action query? If a select query, the data should
all still be there. If an action query, such as a delete, update, or insert,
that could be a real problem.

Are you having at problems with the database which would make you think that
it's corrupt?

 

[pemt]

Thanks.

hi,

First of all, do not touch you database file before making a backup copy.

The problem is that there is no such indicator.

You may try a professional recovery service or run some control
(validation) queries to decide if it was finished gracefully.

Also a query running that long indicates a lack of performance, so
tuning your query may be an option.


mfG
--> stefan <--
.

 

[pemt]

Hi Jerry,

Thanks.
It's a Select query and has been running for a few days for simple data
range comparison of millions of data.
Actually I didn't "RUN" the query but click "Dataview". I guess I lost it
and have to re-run it.

pemt

 

[wangdong]

Hi,

I think you can try a utility called Advanced Access Repair to repair
your Access MDB file. It works rather well for my corrupt Access MDB
files. Its web address is http://www.datanumen.com/aar/

W.D

 

[Tony Toews [MVP]]

I think you can try a utility called Advanced Access Repair to repair
your Access MDB file. It works rather well for my corrupt Access MDB
files. Its web address is http://www.datanumen.com/aar/

1) You are an employee of such a company

2) You should be disclosing that fact more openly.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/