CODEWITHSUNDEEP
ms-accessms-access-2007
mrwienerdog
mrwienerdog

Reputation: 825

Access DB corruption issue, can't find info on similar issue anywhere

I am currently working at a large company on a school placement. The group I am working in supports a fairly complex Access DB which houses a myriad of data, and has 40+ forms. We have been running into a problem that no one (not even the vets) can figure out. I've been asked to search the internet for any info, but can't even find anyone that has even had a similar issue.

Here is the problem:

A bit ago (read: before I got here), the company did an upgrade from Access 03 to 07. Everything was fine. My first task when I arrived was to insert a snippet of code to record which user was making modifications to different DBs (because of the removal of the mdw). This went fine, and we threw the whole thing into production. A few days later, we received our first phone call, "Help! I keep getting an error, and can't access the db!" The error was 'The VBA modules in this db appear to have been saved with errors, etc, etc'. We obviously had corruption issues. Funny thing is, when we went into the code for the forms, it was all gone, save for "Option compare DB" at the top of every form. So we had 40+ forms that all said that, and nothing else. We promply re-upped a backup, no big deal. Two days later, same thing. Re-up the backup. This happend a few more times. Not just the same user on the same machine. However, didn't happen to me, or to my mentor. Then we thought maybe the issue was the way we imported the forms with the new code, so we installed the backup, and copied the forms over one by one. Next day, same issue. By this point, we thought that it must be the five lines of code we had added (who knows why), so we just ran with the old backup, no changes. It's been about two weeks now, no issues. Until this morning. One particular user had this happen four times yesterday (not to any one else).

Anyone ever heard of such a thing? What could possibly be the problem? I'm sure there are a wide variety of possibilities, and I am sure I haven't given enough info to narrow it down much, but I don't know what else to write (never worked with a large Access app before).

I'm obviously stumped, but so are all the clever vets I work with.

EDIT** For clarity: All of the forms are perfectly fine in terms of their view. I can open them, and they look absolutely normal, just no back end code....

Upvotes: 0

Views: 715

Answers (1)

Fionnuala
Fionnuala

Reputation: 91306

Each user should have their own front end, vanishing code is a corruption issue and you are losing all the advantages of a split database if the users do not each have their own front end. you can get additional protection from compiling the front-end into an accde or mde file.

The usual argument against each individual having their own copy is that it is difficult for developers to keep the various copies in synch, but there are several solutions for automatically rolling out updates to users, for example, this one by Tony Toews: http://autofeupdater.com/

Upvotes: 2

Related Questions