Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RDC, OLEDB database location??

Status
Not open for further replies.

dtrumbower

Programmer
Feb 16, 2001
53
SE
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top