Compact MS Access mdb?

[Jothirajalingam_SS]

Hi all,

          In what way we can compact MS access mdb using LabVIEW?. Is there any function in the DB utilities?
 

[Wiebe@CARYA]

"Jothirajalingam_SS" <x@no.email> wrote in message
news:1226554805115-808249@exchange.ni.com...
> Hi all,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In what way
we can compact MS access mdb using LabVIEW?. Is there any function in the DB
utilities?
> &nbsp;

Call this from the command line (with sys exec.vi):

http://www.codetoad.com/vb_compact_db.asp

I haven't tried it, so please let us know how it turns out.

Regards,

Wiebe.

[Jothirajalingam_SS]

Hi,

        I tried it. But it is returning some error (i.e no listeners in GPIB). Anyway thanks a lot. 

[Herok]

Please refer to this link to sort out the error.

http://digital.ni.com/public.nsf/allkb/EA1600EBA422E97286256AA20073C616?OpenDocument

There is a way to give the commands in system exec.vi

Regards,
Pavan

[Jothirajalingam_SS]

Hi pavan,
                  That works fine now. Thanks for the link provided. Is it possible to compact Access MDB without any shell commands? so that it works even if Access is not installed in the PC. Thanks once again.

[Wiebe@CARYA]

The only way to access mdbs without access is through ADO or DOA. I read
that DAO can do this for MDB's. Both are activex components, ADO is used by
the SQL tooklit and LabSQL, but DAO is intended for M$, so it is less
generic.

I haven't tried this either...

Regards,

Wiebe.