INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Corrupted Access Database Hiding Tables

Corrupted Access Database Hiding Tables

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close