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
 General SQL Server Forums
 Data Corruption Issues
 MS Access database trouble

Author  Topic 

MarkusHurier
Starting Member

2 Posts

Posted - 2014-09-18 : 09:19:17
Hello,
I have an access database that has been used for many years, converted from Access 2000 to 2007 and was fine. In the last couple weeks it has been doing strange things! There is a form for 'editing' a record. When the user clicked on the button to open this form, a small white box appeared and said 'Record Deleted'. After that, the database was corrupted. I support this database and I can not even get into it in design view. When I try to open it (holdig the shift key down while opening it), it takes a while, then it displays the Access desgin page that has the 'blank database' icon and to the right it lists the frequent opened databases. So, I can't even get the to objects. The only option I had was to restore from a previous night backup. This meant the users lost all their work for the day. Today, one week later, it has happened again. All the users work was lost because I had to restore from backup. I don't know where to begin to trouble shoot this since I can not get into it in design view when it has become corrupted. Looking for any suggestions to debug this. I can use a copy of the database I had restored.
Thanks

JeremyHineman
Starting Member

1 Post

Posted - 2014-09-21 : 12:19:11
First you need to split the database into a front end and back end. Next place a copy of the Front end on the local hard drive for every user. This is critical if you want to avoid lost work. See:
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/access/155-ms-access-trouble
Note: Access 2003 a older played better with a shared database. In Access 2007 and later is is very import to NEVER allow two users to open ta database at the same time. When each users has a copy of the Front end that is NOT shared it avoids this issue. I find this a must when you use the new .accdb format. http://www.access.recoverytoolbox.com/
lso make sure that everyone with Aces 20907 has the Office 2007 SP2 or later update. If there is a Workstation that does not have at least SP2 installed it can cause issues.
Go to Top of Page
   

- Advertisement -