Execute Compact/Repair on Access database from Perl?

[gkwok]

Hi everybody...

I'm writing a database-driven web site, and I have a Perl script that runs as an NT service every couple minutes that takes care of some housecleaning chores for the database (eg, send reminder e-mails, delete tmp files, etc.). One thing I would like it to do is perform a Compact/Repair on the Access database, say once a week. The scheduling is already there, but it is there a way to connect to the database in Perl and do the compact/repair operation?

Thanks!

 

[Inosuke]

Database stuff is funfunfun.

I'm not so good with the SQL language, but you need DBI to connect. Then you can do whatever you want. Search the net for the DBI module and descriptions. It's a bit tricky, but there is a good book by Oreily on Win32 Perl and DBI.

It worked great for me.

Also these can be helpful.

http://dbi.symbolstone.org/index.html

http://wdvl.com/Authoring/Languages/Perl/PerlfortheWeb/index6.html

http://www.perl-ntadmins.com/

Inosuke