how to recover Access data after automatic reboot?

  • Thread starter Thread starter pemt
  • Start date Start date
P

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
 
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?
Click to expand...
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 <--
 
We need a lot more information.
This query has been run for a few days.
Click to expand...
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?
 
Thanks.

Stefan Hoffmann said:
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 <--
.
Click to expand...
 
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 said:
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/
Click to expand...

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/
 
Back
Top