Compacting an Access 97 Db

[Anthony Viscomi]

I've created a DB in XP and coverted it down to 97; XP allows for the option
to compact on close and 97 doesn't. Does anyone know how to achieve this via
code or any other method? My DB "fires off" a lot of queries, thus leaving
it fragmented. I can't have my users manually compacting it.

Thanks,
Anthony

 

[M.L. Sco Scofield]

Take a look at http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Douglas J. Steele]

In addition to Sco's advice to look at Michka's TSI SOON utility, when you
say it fires off a lot of queries, do you mean you're creating temporary
tables? If so, take a look at what Tony Toews has about using temporary MDBs
with your application at http://www.granite.ab.ca/access/temptables.htm