Problem with Access database file changing

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Problem with Access database file changing

Author

Topic

Clazanos
Starting Member

1 Post

Posted - 2015-02-24 : 10:20:41

For a long time I am running Access 2007 with Windows 7. And I experienced not so much problem in it, even if a problem had occured it almost always easily was to solve. But last two days i am frustrated, i have met a problem i unable to solve this time. I am working with a DB file and i noticed number of records changes in it occasionally. These changes depend of any changes in the file. What is going on? If anyone knows i will be thankful a lot for any tip.

Ballacaster
Starting Member

1 Post

Posted - 2015-02-28 : 06:14:40

Delete all your relationships in the corrupt table, as well as indexes. Then select the table and copy-paste, rename it and set structure only. Make a new query into the corrupted table, verify that you can see all the records. Change it to an Append query and run it. That`s all.

If this doesn`t help, then try to find another tips that could help, on other forums maybe there are such issues discrubed, e.g.: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/1435-access-database-2003-became-corrupt-after-power-outage-what-gives
or smth like this. There you can find a lot of interesting.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources