Hello

I've created linked tables in Access to SQL Server using a DSN. The tables
open fine in Access & I can edit data.

However the same SQL queries scripted from a web server fail - this being a
query of the tables in Access that are actually links to the SQL Server.

Returns the error: DATABASE ERROR: S1000 [Microsoft][ODBC Microsoft Access
Driver] ODBC--connection to '<DSN name>' failed.

I don't see why the links that work in Access do not work when Access is
used as the date source.

Any help please?

Thanks

Tony.