I have an Access database setting on one of the servers which uses a FILE
DSN to connect to a large number of SQL Server files.

Using VB and Access and VBA with XL I have no trouble creating queries or
accessing both the Access based tables or the linked SQL tables.

Now I am trying to do the same thing with ASP pages using VB Script. I
created a SYSTEM DSN connection to the Access Database and accessing the
Access tables works fine. When I try to access or link to one of the
linked tables then I get an error which refers to the FILE DSN that the
database uses and it doesn't work.

I tried creating a SYSTEM DSN for the Access Database to use to link to the
SQL data but this didn't help.