
Reports Can't Find Database
I have a VB6 application that includes several CR8 reports and uses an
Access 97 database. When the application is installed on a computer other
than the one used to create it, the reports will not print. If the
Report.RecordSelectionFormula is used, a run-time error is generated
(-2147192191, Physical database not found). Otherwise, the printer lights
flash a couple of times as though it were going to print, but nothing
happens. Any ideas on what I need to do?
Additional information:
The database location was set to 'same as report' at design time. This
resulted in a reference such as tblName!dbName.
I am using a DSN-less MS Jet 4.0 connection. The computers have Mdac 2.5
installed.
The reports work fine when the app is installed in any folder of the
computer used to create the app.
Simple Printer.Print statements work and the app has no data access
problems.