Am getting the message "Table '' could not be found" when trying to view a report with a subreport in the Crystal Viewer 9. The report displays correctly when opened and previewed in Crystal Reports Developer 9. The tables being viewed are the same. I have another report which displays without getting this message.

Following is some info regarding the tables involved:

TABLE NAME rptdowntime
TABLE LOCATION downtime
Buffer String DSN=Eclipse TMP Tables;;UseDSNProperties=0 this is a user DSN and points to
DLL crdb_odbc.dll in the system temp folder
Database Type 2
--------------------

sub TABLE NAME rptdowntime_hdr
sub TABLE LOCATION downtime_hdr
sub Buffer String DSN=Eclipse TMP Tables;;UseDSNProperties=0
sub DLL crdb_odbc.dll
sub Database Type 2
--------------------

Since submitting my original thread, I have determined the error is caused by the tables referenced above being open in the VFP application. What I do not understand is the report that worked also used tables that were open in the VFP application. These tables were in a different DSN which was a system DSN and were opened with optimistic buffering.