HELP - Database corrupt???

[maca9]

Hi

Have any of you experianced problems with buttons suddenly not working anymore.

This happens to me on my database. You click the button and nothing will happen. Not just one buton but most.

I then have to import every table/macro/form/query into a new DB and it usually is away again. Well so far.

I have no idea why this happens. It is a replicated set, but the it is used daily for months at a time with no problems.

All users compact and repair twice before syncing.


Anyone seen anything like this?

Thanks

 

[ordendelfai]

Two thoughts.

1. Are your users using a front end on their C: (or local harddrive) that is linked to another file on a network drive? If not, it is highly recommended that you adopt this deployment instead of all users accessing the same mdb file on a network. I had a ton of problems that all vanished once I did this on an old project of mine.

2. You could be losing your references. Check them and if anything says "Missing" then you need to uncheck and recheck that reference (press ctrl + G, then go to Tools -> References).

~Joel