Hi,
I have tried your scenario using VB5, CR 4.6, and an Access DB. I did not have any problem of database closure... here are the steps :
1. Creation of a report using CR 4.6, this report is bound to an Access DB, to a simple table
2. Creation of a VB Project, including a CR OCX, onto a form
3. Writing of this code (into Form_Load) :
with CR
.ReportFilename = "myReport.rpt"
.Destination = 0 'window
.RetrieveDataFiles
.Printreport
end with
Then, while report is opened, I try to open the DB with Access EXCLUSIVELY. Everything works OK...
I didn't tried with a Foxpro DB since I don't have it. So I Have 2 questions :
Did you specified your data source via ODBC ? Perhaps there's a trouble with that driver.
Did you precise "record data with report" into report properties (in CR menu File). Perhaps there's a locking conflict with that option.
Hope I was helpful
JM