compact MC Access Database with labview

[Ron Larson]

Hello,

How do I compact an MS Access programatically from labview to reduce its ballooning size? I have the database connectivity toolkit.

Thanks,

Ron

[Dennis_Knutson]

I don't think you can with the toolkit. You'll probably need to use ActiveX. See the post here. If your database is highly normalized and don't do any record removal, you shouldn't need to compact it (at least not very often).

[mikeporter]

What datatypes are you storing? Using the wrong datatype can cause all kinds of size problems--as in the datafile expanding at a rate several times the size of the data you're putting in it...

Mike...

PS: If you are running Windows you have everything that you need. Access is not actually a database package. It's an application development package for creating programs using Jet. Jet is the DBMS that Access uses, and Jet is installed by default with Windows.

[Ron Larson]

Hello,

Thanks for the input.

THe tables in the mdb will contain a string plus up to 100 singles, or a string plus 4 doubles plus upto 48 longs. There may be up to 100 tables or more in the one mdb.

I want to compact the file from the labview exe without having Access installed on the computer. I would prefer as well not to need to run visual basic or other language then labview to do it.

Thanks

Ron Larson