Access 2000 Ctirix odbc problem

[m23]

Hi,
I have an access application that has been working fine for the past
few years.Access 2000 is used for the user interface and Oracle the
database.

Recently the application was moved to a citrix environment. On this
citrix environment is one copy of the mde and the oracle odbc driver to
connect to the database. When a user logs into Citrix and runs the
application they get their own copy of the mde copied to a directory
and it is run from there.

My problem is that at random times/places within the application a
random error will be displayed and a form/report etc will have no data
when it should have. This will happen to someone around once a day. The
user is then unable to do anything till they close the application and
restart where the problem will go away.

The citrix administrator is blaming the problem on multiple users all
connecting through the one odbc connection. Usually there would be
about 10 users using the app at the same time.

Does this sound like it could be the cause?

The citrix administrator is also saying there is no solution to this.

Does any one know of a way to fix this if it is caused by everyone
sharing the ODBC connection or what else might be causing it?

[david epsom dot com dot au]

If your odbc driver can't support multiple connections correctly,
can you try a different driver?

I would be very disappointed with any ODBC driver that couldn't
reliably support multiple connections with different login id's.

(david)

"m23" <mn*****@gmail.com> wrote in message
news:11*********************@i39g2000cwa.googlegro ups.com...

Hi,
I have an access application that has been working fine for the past
few years.Access 2000 is used for the user interface and Oracle the
database.

Recently the application was moved to a citrix environment. On this
citrix environment is one copy of the mde and the oracle odbc driver to
connect to the database. When a user logs into Citrix and runs the
application they get their own copy of the mde copied to a directory
and it is run from there.

My problem is that at random times/places within the application a
random error will be displayed and a form/report etc will have no data
when it should have. This will happen to someone around once a day. The
user is then unable to do anything till they close the application and
restart where the problem will go away.

The citrix administrator is blaming the problem on multiple users all
connecting through the one odbc connection. Usually there would be
about 10 users using the app at the same time.

Does this sound like it could be the cause?

The citrix administrator is also saying there is no solution to this.

Does any one know of a way to fix this if it is caused by everyone
sharing the ODBC connection or what else might be causing it?