What are some of the possible reasons why i might recieve this error? Server error: Unable to retrieve schema information from the record source 'Date' in a database using the connection string:
'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/ScheduleTablesAllObjectsNoGrpSecurity.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] Syntax error in FROM clause.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)
I searched through some of the archives and I see that you helped people with this problem when their tables were named incorrectly, but my table is named Date and other tables and queries in the same database work fine.
Thanks again for your help.
