I desparately need to find a solution to the mysterious bloating of databases. I reviewed the article in Access VB Advisor Feb 98, but I feel my program is too complicated to invoke that solution. Does any one know of a white paper or way to automate the process of compressing the database, or a means to prevent the bloating?
I'm using many querydefs to display data combined with Temporay tables. The database is doubling in size every 3-4 days. My client is at a remote location many miles away It's simply imposible to drive 50 miles every 4 days to run the compression utility.