Disconnecting a Crystal 8.5 report while report is open in VB6

5 pts.
Tags:
Crystal Reports 8.5
Microsoft Access
Visual Basic 6
Hi I am developing an application which is written in VB6 and uses Crystal Reports 8.5 and has MSAccess as its database. The Users connect to the database via ODBC and the reports also use ODBC to connect to the data source. I have simply added the Crystal Report object to the forms which require reports and call them using the .retrieveDatafiles method followed by the .Action = 1 The problem i face is that when a user opens the reports for viewing Access applies a lock (ldb) on the database and then other users who are adding data or running queries on the data are unable to complete their tasks. My question is how can i close the data connection of the Crystal reports object so the the lock is removed before the user finishes viewing the report. There is no .close method exposed in the crystal object?? Also i notice during testing that once a user has opened a report the lock remains even after they have closed the report itself right up until they close the application? Thanks for your help!! Shannon

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following