dtrumbower
Programmer
When using the RDC and trying to change the table location for the
report I get table not found errors. The database is a mdb.
If I create the report using the msDAO method it works fine, but I
would like to use OLEDB Jet 4 dll. Is this possible using the same
type of code that works for the msdao method.
Code that works for a msdao report.
Set crReport = crApp.OpenReport(App.Path & "\" & crfileName, 1)
For Each crDatabaseTable In crReport.Database.Tables
crDatabaseTable.Location = App.Path & "\" & crdbName
Next crDatabaseTable
crReport.Database.Verify
Dwight
report I get table not found errors. The database is a mdb.
If I create the report using the msDAO method it works fine, but I
would like to use OLEDB Jet 4 dll. Is this possible using the same
type of code that works for the msdao method.
Code that works for a msdao report.
Set crReport = crApp.OpenReport(App.Path & "\" & crfileName, 1)
For Each crDatabaseTable In crReport.Database.Tables
crDatabaseTable.Location = App.Path & "\" & crdbName
Next crDatabaseTable
crReport.Database.Verify
Dwight