Database is getting out of proportions !

[web@rt]

Hi,

I have the following going up :

When I did several actions on a database using (an) ADO-connection(s) my database grows from - 500Kb to almost 12Mb !

I don't add anything, just some reading or selecting and editing.

I upgraded my db to Access 2000, from Access 97, so I could use all ADO-functions.
I DAO there was a function to compress databases which is also available in Access 2000, and that's how I now compress my db.

Is there a way in VB6 to immediately compress db's ? Is yes, HOW !

Thanx in adv.

[Clunietp]

Add a reference to the "Microsoft Jet and replication objects 2.1 library".

You can compress your Access 2000 database using ADO and JetEngine.CompactDatabase method. Also, this file is installed with the MDAC, so the file should already be on your clients' machine

HTH

Tom