I?m using CFMX 6.1 on a Windows Server 2003. I have an Access DB with some
tables linked to a SQL Server 2000 DB running on another machine. When I try to
query any of the linked tables I get an error: Cannot connect to
sql_server_dsn_name. When I log into the CF server, opened the access db and
opened the tables I get no error.

CF pages can query all the "local" tables but none of the linked tables. I
used the Access with unicode driver to define the Access datasource.

Any ideas??