Strange ODBC connection errors connecting to SQL Server

[Dannasoft]

Hi all, hopefully someone can provide some advice.

I have an access application that uses SQL Server 2005 to serve data
via a DSN and linked tables. The front end runs on a Citrix server.

I created the DSN and it tested correctly. If I open the database on
the Citrix server I can open the tables and view/edit/insert data just
fine.

However, intermittantly I get a server doesn't exist or access denied
when opening simple recordsets in VBA. So I debug my SQL string in
the code and copy it to a new query and it works fine. But I get
either the Server does not exist or access is denied when attempting
to open the recordset or occaisionally I get the PreHandshake error or
General Network Issue error.

The application is over 10 years old and in use with a variety of
clients and works fine. I'm wondering if it's the Citrix platform
they are running it on. Authentication problems from Citrix perhaps?

If anyone has experience running Access apps on Citrix I'd love some
advice.