KiltedCelt
Programmer
I've been to several forums, and so far no one has been able to give me an answer to this. I have written an application that uses a dataenvironment and a few datareports to print data. Also in the program I have a compact database subroutine. The sub works fine, it compacts my database normally and everything runs fine unless I call one of the datareports. As soon as I call one of the datareport to print or anything, it locks the database and won't let go of it. I then get the old "Database is opened exclusively on <computer name> by <user name>, please wait until the database is available" error. I have tried everything. I have closed the rs and connections related to the dataenvironment, I have set everything I can think of to nothing and it still gives me that error. I have to shut down the program and start it again for it to release the db. Any suggestions? I am at your mercy. Thanks in advance.
