Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

.CompactDatabase error

Status
Not open for further replies.

KiltedCelt

Programmer
Joined
May 29, 2001
Messages
2
Location
US
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 &quot;Database is opened exclusively on <computer name> by <user name>, please wait until the database is available&quot; 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.
 
I have the same problem, anyboy found the answer yet?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top