Skip to main content

Acucobol runtime not clearing Access ldb file when displaying Crystal Report

  • February 11, 2011
  • 1 reply
  • 0 views
D

[Migrated content. Thread originally posted on 10 February 2011]

Hi,

We are using (and were the ones who developed) the technique listed on the old forum to dynamically set the database location, user, and password when displaying a Crystal Report from within Acucobol. Click here to view the old forum thread

We have now changed it to allow our users to have their Crystal Reports use both MSSQL and Access databases. We had to do this because when you are mixing database types withing the report, you have to set the database name, password, and user for each table.

This all works fine, except for one thing - The Access ldb (lock database file) is not removed after viewing the report. For example, when you view the report that uses the Access Database "Test.mdb", it creates a "Test.ldb" file in the same folder as the database. After closing the report viewing window, the "Test.ldb" is still there. If you try to delete it from the folder, it says it's in use. After we do a stop run on the runtime, the file is still there, but you can now delete it.

The runtime does have permissions to the folder. I've tried it with the database on my C: drive and a network drive. I've tried destroying all the handles I'm using, but I would think doing a STOP RUN should free up any resources.

If you open the report in Crystal Reports, it also creates the ldb file, but when you exit from Crystal Reports, the ldb file is removed.

Any help or ideas would be appreciated.

Thanks,

Paul DuBois
EDC Technology

    1 reply

    D

    [Migrated content. Thread originally posted on 10 February 2011]

    Hi,

    We are using (and were the ones who developed) the technique listed on the old forum to dynamically set the database location, user, and password when displaying a Crystal Report from within Acucobol. Click here to view the old forum thread

    We have now changed it to allow our users to have their Crystal Reports use both MSSQL and Access databases. We had to do this because when you are mixing database types withing the report, you have to set the database name, password, and user for each table.

    This all works fine, except for one thing - The Access ldb (lock database file) is not removed after viewing the report. For example, when you view the report that uses the Access Database "Test.mdb", it creates a "Test.ldb" file in the same folder as the database. After closing the report viewing window, the "Test.ldb" is still there. If you try to delete it from the folder, it says it's in use. After we do a stop run on the runtime, the file is still there, but you can now delete it.

    The runtime does have permissions to the folder. I've tried it with the database on my C: drive and a network drive. I've tried destroying all the handles I'm using, but I would think doing a STOP RUN should free up any resources.

    If you open the report in Crystal Reports, it also creates the ldb file, but when you exit from Crystal Reports, the ldb file is removed.

    Any help or ideas would be appreciated.

    Thanks,

    Paul DuBois
    EDC Technology
    My initial thought was that perhaps the connection / dataset was not properly closed, or there may be a handle that has not been destroyed.

    I presume the test.mdb and related code you refer to is minimum code, in which case I believe my suggestions above should be easy to control. If not, I suggest you try a minimum code and see if this also leave the lock file behind.

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement