MS ACCESS97 DATA ERRORS

[ShortTexan]

I have a replicated database that has members of the replica set deployed on an intranet at two seperate locations. There are Data Errors that refer to databases that no longer exist. These are .mdb's that corrupted and had to be deleted. I have not found a way to resolve these errors. The problem is the database continues to grow due to ???. Any help would be appreciated. There is about 20 to 30 Meg of bloating that need to be deleted or about 30 percent of the present compacted size of the mdb.

 

[Dreamboat]

Have you run repair and compact on the it?
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[ShortTexan]

Thanks for the suggestion. It is a much more complicated problem. I run compact and repair daily on my data tables. Microsoft tends to softstep around this problem. The do have a procedure but it is predicated on the 2 pricipals; 1- That you have direct access to both sets of tables (I do not.) and 2- Both sets of tables are functioning .mdb, ( most of the time they are not.) If you run across something, please keep me in mind.