5 of my linked tables open up to the correct records from the master table list view, but when I select 2 of my 7 linked tables I get this error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. 
/CRM/db/tblCurrentResources_list.asp, line 858 
I can not work out why? I have not done anything different with these tables... 
Can anyone help me work this out?
Thanks.