I have the latest Jet 4.0 engine files installed and this MS Access
application that contains linked tables was working fine until I did the
following:
On the SQL Server back-end, I renamed an existing table and created a new
table with exactly the same attributes and (old)name as the old re-named
table. Some users of the Access application did not have a problem
'seeing'
the new table while others get ''ODBC--call failed" when they try to run
some
existing queries that refer to the new table. Stored procedures on the SQL
back-end have not had any problems utilising the table.
What could be 'upsetting' the MS access queries?
