Feb 23, 2015

What could cause the number of records to change in Access database 2003?

I noted one interesting thing while i had been running .mdb file. Namely the number of records changes sometimes. I analyzed this issue and found out that this happens when I make any alterations in the file, sort the data or swap it. Maybe this is some kind of a corruption, but I don’t know what exactly is corrupted and how could I fix it.

Any suggestions?
Best answer
02/25/2015
What have you done to fix it? Because it is difficult a little bit to judge...well, at first try fo restore the file using Access recovery feature. It is the easiest way.

Do you have an available backup? If you have, then you can restore your file from this copy. If not, then it is a bad thing. At any rate, make a nackup of the present file, for what it's worth.

The next, create a new database and copy all data from the corrupt file into the new.

Also you can run MS Jet Compact Utility, this feature is like Access feature, but maybe more effective.

And search your problem on other forums. Try to find any useful discussion where you could find a solution. Look here: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/1435-access-database-2003-became-corrupt-after-power-outage-what-gives
or find another one ;)


02/25/2015
Ogork has a good answer for th is, but here's a link to the Office site if you want to try searching there:

https://support.office.com/en-us/?legRedir=true&CorrelationId=b839acc8-accd-4828-b1d3-c715358c6a90
Best answer
02/25/2015
What have you done to fix it? Because it is difficult a little bit to judge...well, at first try fo restore the file using Access recovery feature. It is the easiest way.

Do you have an available backup? If you have, then you can restore your file from this copy. If not, then it is a bad thing. At any rate, make a nackup of the present file, for what it's worth.

The next, create a new database and copy all data from the corrupt file into the new.

Also you can run MS Jet Compact Utility, this feature is like Access feature, but maybe more effective.

And search your problem on other forums. Try to find any useful discussion where you could find a solution. Look here: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/1435-access-database-2003-became-corrupt-after-power-outage-what-gives
or find another one ;)


Answer this