Manipulating MS Access files

jarthda has asked for the wisdom of the Perl Monks concerning the following question:

Does anyone know of a Perl script which will compact MS Access files. This is a function within Access application which Access developers have to manually run because Access files get bloated when data is processed. I am not looking for something to update data within MS Access tables. Thanks Gurus! J

Comment on Manipulating MS Access files

Replies are listed 'Best First'.
Re: Manipulating MS Access files by NetWallah (Canon) on Apr 28, 2009 at 05:19 UTC
ASPN has the code you are looking for : code to repair and compact a databse via OLE . ..to maintain is to slowly feel your soul, sanity and sentience ebb away as you become one with the Evil.	[reply]
Re: Manipulating MS Access files by Bloodnok (Vicar) on Apr 27, 2009 at 22:11 UTC
Why not try automating the process that the Access developers go thro' ... by using Win32::OLE ?? A user level that continues to overstate my experience :-))	[reply]
Re^2: Manipulating MS Access files by jarthda (Acolyte) on Apr 27, 2009 at 22:35 UTC
So a broad question about Win32::OLE, it's been some time since I perl scripted. Will I be looking for a method in this module that does exactly the compacting or does the OLE module allow me to emulate any windows application behavior?	[reply]
Re^3: Manipulating MS Access files by Bloodnok (Vicar) on Apr 28, 2009 at 10:32 UTC
Essentially, it's the latter ... well nearly, since any windows application behavior s/b read as most behaviours for most windows applications. IIRC, the object model/navigator is all well and good, but the only sure way to tell if the library can emulate the specific application behaviour (especially non-standard behaviour) is by good old experimentation. A user level that continues to overstate my experience :-))	[reply]