B
Bill Beshlian
I am getting the following error when I try make my Database Results Region
retrieve query (view) results from a query which queires multiple tables.
Server error: Unable to retrieve schema information from the record source
'v_OHARA_WAR_select' in a database using the connection string:
'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/initial_report.mdb'.
The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)
I knw the Database Connection works because the DRW has no trouble when I
query a single table or a view (query) where the results are come from one
table. I have checked field properties and this does not appear to be an
issue. Can the DRW retrieve results from a veiw (query) when the original
query gathers its data from multiple tables? TIA
Bill Beshlian
retrieve query (view) results from a query which queires multiple tables.
Server error: Unable to retrieve schema information from the record source
'v_OHARA_WAR_select' in a database using the connection string:
'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/initial_report.mdb'.
The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)
I knw the Database Connection works because the DRW has no trouble when I
query a single table or a view (query) where the results are come from one
table. I have checked field properties and this does not appear to be an
issue. Can the DRW retrieve results from a veiw (query) when the original
query gathers its data from multiple tables? TIA
Bill Beshlian