Access is denied.

the DSN is a system DSN, sorry.

Nope. C,D & E only. So there are two things going on here. The catalog is wrong and the DSN file Schedule64 was saved to the Z...

Changed code to the following...

/* Add the Access database to a named linked server */

EXEC sp_addlinkedserver

@server=N'AccessSchedule'

,@srvproduct=N'Access'

...

For Access I went back to my original setup.

exec sp_addlinkedserver @server=N'AccessSchedule'

,@srvproduct=N''

,@provider=N'Schedule'

,@datasrc=N'LocalServer'

exec sp_addlinkedsrvlogin AccessSchedule,False,NULL,Admin,NULL

Where Schedule is the name of a DSN file on the SQL server

Now when I run...

I think I have a configuration issue with the network.

BTW I have recreated the AccessSchedule linked server using..

exec sp_addlinkedserver @server=N'Access'

,@srvproduct=N''

...