Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Compacting a MS-Access database from perl

by jsprat (Curate)
on Jun 05, 2003 at 19:54 UTC ( #263481=note: print w/ replies, xml ) Need Help??


in reply to Compacting a MS-Access database from perl

I'm stuck with Access 97 too.

You can use OLE to compact a database. Here's a fish:

use Win32::OLE; # check your registry for which version DBEngine to use my $dao = Win32::OLE->new('DAO.DBEngine.36', 'quit') or die "$!"; $dao->CompactDatabase('c:\\test.mdb', 'c:\\test2.mdb');

Check the Access helpfile for available options

HTH!


Comment on Re: Compacting a MS-Access database from perl
Download Code
Replies are listed 'Best First'.
Re: Re: Compacting a MS-Access database from perl
by Grygonos (Chaplain) on Jun 05, 2003 at 20:47 UTC
    That took care of it. Thank all you monks a ton for your input. I still had trouble finding decent doc on how OLE works and what methods/objects are available. Problem solved... Perl > all yet again :)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://263481]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (4)
As of 2015-07-30 04:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (270 votes), past polls