Access and SQL Server problems running on Citrix

[Dale Thompson, DRY-T Consulting]

I have been using Access with SQL Server and ODBC linked tables for the past
10 years or so with few problems, even with 100+ users, each with a PC
containing their own copy of the front-end mdb.

I am doing some work now in which the above works fine, but when the mdbs
(one for data entry, one for reporting) are transported into the Citrix
environment, there is no end of problems with timeouts, ODBC-call failures,
disk or network error messages etc. Of course the users are very frustrated.

The data entry application is code-intensive, with unbound forms and data
access classes for validation and update to SQL Server, so the load on a
Citrix server should be very light. The database has about 25 tables, non of
them large in terms of either columns or rows. The data entry application is
about 6MB, with 40+ forms.

I have no prior experience with Citrix. What key questions do I need to ask
the Corporate Citrix administrators to get on the right track?

 

[Albert D.Kallal]

ok...it clear you been round the block.

The thing to remember with Terminal services (or ctirix...which is
essentially the same), is that you still must deploy your mde file to EACH
person.

That means that each user who logs on to the server gets their own
directory, and their OWN copy of the mde file....

The fact that you run for years and years shows me you know what you are
doing, and have had great success.

Do the same in ctirx...and do NOT allow multiple users into the SAME front
end....

Do the above...you likely will have another 10 years of trouble free
operations....