Disapearing queries and reports

[Bhaughbb]

I've got several access databases located on our file server. Numerous users throughout the office have access to open and view them as has been the case for several years. Since the beginning of the year we have started seeing a brand new issue occur every couple of months in a few of our databases. One day everything will work fine, come in the next day and all of the macros, tables and most of the queries are gone. I have noticed when this happens the queries vanish in ascending alphabetical order, the first 2-10 or so may still be there but everything after that and in reports and macros are gone. Recently we've also had another access mdb start doing this problem and only one user other than the system administrator has access to that file, it is also located on the server and in a secured folder.

The only fix I've found is to restore from a tape backup from a few days before to confirm it's a good copy but this gets annoying.

Any thoughts as to the cause or solution?

All databases effected are located on a central server, get a nightly backup, have a list of tables almost completely made up of linked tables from multiple ms sql server 2000 databases. The files are Access2000 format.

Thank you in advance for your expertise, I'll add any furhter details you may want/need.

 

[boblarson]

1. Do these all have a Frontend / Backend configuration?

2. If they do have a Frontend / Backend configuration, does each user have a copy of the Frontend on their machine?


I suspect that you are suffering from corruption that can occur, either as a normal effect of use over time, or due to the answers to the questions above being NO.

Access, in a network situation, really needs to have the answers to the two questions above be YES to eliminate the most common corruption issues. Not only that, but it will also help the users a lot more as well.

You might want to try taking one that you are having troubles with and import all of its objects into a new, blank database and then split it and give the front end to each user and see how that works for you. I would think you would see improvement.

If you don't want to touch all workstations with a front end file everytime it gets modified for design changes, you can check out my tool for enabling Auto Updating for the front ends. It is located here:
http://www.access-programmers.co.uk/forums/showthread.php?t=111132