[mdb-dev] help needed (how to deal with ldb files)

[Mindaugas K. <Min...@ha...>]

Currently i have big problem retrieving data from access files. One
application in our organization generates access databases (new database
every week) with statistical information that I need to transfer to
mysql database for processing and reporting. That application constantly
keeps connection to the last mdb file until week changes, but I need
that data from access at least every hour. I'm using mdbtools and my own
perl application to migrate data to mysql, before that I copy that last
mdb file together with ldb one to different location, not accessible for
that application. Somehow MS made database corrupted until someone uses
it, so is it possible to drop that connection or anything...? I can
retrieve db schema from access database but not a single record,
although if I open it with MS Access - I can see all data.

Thanks in advance

Mindaugas K.