davewhiting
Programmer
Hi,
First off, apologies if this should go in a different forum, the Tables forum seemed the best place to me. I am a rookie to Database development and have had to teach myself the majority of what I know so would appreciate tips if I have missed anything that seems obvious to a pro.
Here's my situation: I have a Database developed in MS Access 2000, which is split between a front end with forms and VBA coding and such like, and a back end with just tables and a handful of queries. The front end has security settings created using the security wizard from the Tools menu.
Most of the users (about 8 including me) are using Access 2000 and one is using Access 2007 (Having performed the steps detailed below, I believe this may be what is causing the issue, but I'm not quite sure how).
Today, the Database started throwing up an error stating records had been deleted. What seemed quite strange at the time was that the forms still held the data and the users could navigate between records fine, but lookup queries were not recognising it until they closed the form, then the connection seemed to be lost. The same error occurred upon attempting to open the table from the front end.
I opened the back end and was confronted with a blank screen where the list of tables should have been. I went to check the properties but found I could not open the form. My first clue - the only time I've experienced this before was when a user with Access 2007 had made some changes and I'd subsequently tried to check properties using Access 2000. I opened the properties from Windows Explorer and caught a glimmer of hope as this apparently empty database was actually 26Mb in size!
I made a copy and attempted a Compact and Repair to no avail. Again, this was something I recalled from a previous encounter with changes having been made using Access 2007 - so I called on another colleague with 2007 to do the Compact and Repair and - lo and behold - it worked! Not only did it do the repair but my tables and queries were back... except the main one...
I have got our system support team to provide a backup of the file as of last night - the missing data isn't so much an issue as *What actually caused this and how do I stop it happening again*?
My first thought is to make sure everyone is using the same version of Access, however, I am not sure my company has Access 2000 available any more, so rather than having Access 2000 installed on one PC they will be faced with installing 2007 on 8. Given the cost of doing so, I fear I may be told come up with a solution that doesn't require doing so.
Sorry for the long post, but I hope this covers everything. I've encountered minor corruption which could be sorted by decompiling and Compacting and Repairing before, but never seen anything like this. If anyone can help me figure out what could cause this I would be most grateful.
First off, apologies if this should go in a different forum, the Tables forum seemed the best place to me. I am a rookie to Database development and have had to teach myself the majority of what I know so would appreciate tips if I have missed anything that seems obvious to a pro.
Here's my situation: I have a Database developed in MS Access 2000, which is split between a front end with forms and VBA coding and such like, and a back end with just tables and a handful of queries. The front end has security settings created using the security wizard from the Tools menu.
Most of the users (about 8 including me) are using Access 2000 and one is using Access 2007 (Having performed the steps detailed below, I believe this may be what is causing the issue, but I'm not quite sure how).
Today, the Database started throwing up an error stating records had been deleted. What seemed quite strange at the time was that the forms still held the data and the users could navigate between records fine, but lookup queries were not recognising it until they closed the form, then the connection seemed to be lost. The same error occurred upon attempting to open the table from the front end.
I opened the back end and was confronted with a blank screen where the list of tables should have been. I went to check the properties but found I could not open the form. My first clue - the only time I've experienced this before was when a user with Access 2007 had made some changes and I'd subsequently tried to check properties using Access 2000. I opened the properties from Windows Explorer and caught a glimmer of hope as this apparently empty database was actually 26Mb in size!
I made a copy and attempted a Compact and Repair to no avail. Again, this was something I recalled from a previous encounter with changes having been made using Access 2007 - so I called on another colleague with 2007 to do the Compact and Repair and - lo and behold - it worked! Not only did it do the repair but my tables and queries were back... except the main one...
I have got our system support team to provide a backup of the file as of last night - the missing data isn't so much an issue as *What actually caused this and how do I stop it happening again*?
My first thought is to make sure everyone is using the same version of Access, however, I am not sure my company has Access 2000 available any more, so rather than having Access 2000 installed on one PC they will be faced with installing 2007 on 8. Given the cost of doing so, I fear I may be told come up with a solution that doesn't require doing so.
Sorry for the long post, but I hope this covers everything. I've encountered minor corruption which could be sorted by decompiling and Compacting and Repairing before, but never seen anything like this. If anyone can help me figure out what could cause this I would be most grateful.