Mark,
You can set SQL7 up so that it resizes the database automatically. This is
one of the database options. As for access, there is a DAO command to
compress the database (not sure about ADO) - though be careful with this as
it can sometimes wipe out data - ie. back up first!
Regards,
Dennis.
> -----Original Message-----
> Hiya, how does one pragmatically compress/compact a sql7 and access
> database? Or should I leave that for someone to do themselves?
>
> For SQL7 I could see leaving it up to the DBA/Admin, but for Access I
> think I'd like my app to automatically once a month or so do
> a compress, I
> just noticed my db was 8mb, hit the compress button in access
> and its back
> to 800k.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
