I have an Access 2003 application that references linked tables that reside on a SQL Server database. When I run it from my desktop, it works fine. When I try to run it under Citrix, the ODBC connection to SQL Server fails. Any ideas?
=============================
UPDATE:
I may have found the problem: I was linking the tables using an ODBC File DSN that resides on a network share. I created a copy on the server's local drive and things have started working, not perfectly mind you...
- Follow via:
- RSS
- Email Alert
Question
0
Votes
Access front-end can't see SQL Server via Citrix
Updated - 25th May 2007
Answers (2)
0
Votes
silly question
but is the ODBC connection defined on the Citrix server. Preferably under the System DSN's
24th May 2007
Replies
...but I'm going to re-visit that issue today anyway.
bschaettle@...
25th May 2007
0
Votes
Hi, what do you mean when you said you created a copy on the server
did you create a copy of the database on the citrix server? I appreciated your input; I am having the same issue:
when I try to use access 97 front-end to SQl via citrix server.
Many thanks,
when I try to use access 97 front-end to SQl via citrix server.
Many thanks,
12th Sep 2007
