It looks like you are using an ODBC DSN in your connection string. Does 
this DSN exist on the web server? Also, I didn't even realize you could 
use references like this:

[ODBC;DSN=ODBCSQL2000;UID=user;PWD=password;].[dbo.SQL2000Table]

Is that really in your query?

Jeff Montgomery
jeff.montgomery@m...

> Friends

I have the following problem :

    [Microsoft][Controlador ODBC Microsoft Access] ODBC: error al conectar
con 'ODBCSQL'.

    INSERT INTO Access2000Table SELECT SQL2000Field FROM
[ODBC;DSN=ODBCSQL2000;UID=user;PWD=password;].[dbo.SQL2000Table]