LabWindows/CVI

cancel
Showing results for 
Search instead for 
Did you mean: 

How to pack a MSAccess (*.mdb) database with CVI5.5 and SQLToolkit 2.0.5?

Hi, I'm using CVI5.5 and SQLToolkit 2.0.5. My program connects with MSAccess and uses a database, but it stores lots of data and sometimes the data are deleted, but the database does not reduce its size. Is it possible to send a command to 'pack' the database? Thaks in advance.
0 Kudos
Message 1 of 3
(2,724 Views)
hello

I dont think this was exposed in the SQL toolkit. You can do this is you use ADO directly with the CompactDatabase method. You can use ADO from CVI by creating the wrappers functions for it from the Activex Controller wizard.

I hope this helps

Bilal Durrani
NI
Bilal Durrani
NI
0 Kudos
Message 2 of 3
(2,724 Views)
I have tried but not success.
Do you know where to find an example?
Do you have an example?

Thanks in advance.
0 Kudos
Message 3 of 3
(2,724 Views)