i am using ADO.

I am linking direct to the SQL server.

you can not link to the tables that are linked to by Access, they do not appear through the data environment.

i think that i am part way there, now I need to find out how to pass variables to the SQL statements, since the syntax in slightly different then in access