I have a db (approximately 70Mb) which gets corrupted. The message says something about an "inconsistent sate". If I enter Access and do a "Compact and Repair", it is fine. If this be db is at a client, is there a way for the client to do a compact and repair using vba? Can it be done from within the software or does the be db have to be closed and the Compact and repair be done from another program.
The problem, I believe, is the fact that the client's network is not well setup for example he does not have a dedicated server, but is working on this.
The problem, I believe, is the fact that the client's network is not well setup for example he does not have a dedicated server, but is working on this.