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!!