Access 2000 Ctirix odbc problem



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?

.



Relevant Pages

  • ODBC setup
    ... I'm trying to setup linked tables through ODBC connection to an Oracle ... I checked my tnsnames entry and used the correct server name, ... tnsnames entry for that particular database, but it is in the format: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Microsoft Query
    ... alone and that Oracle is aware of the issue. ... > deleting data in the database. ... >> I can't speak directly to your problem with MS Query, ... >>> from a Unix based database, via an ODBC connection. ...
    (microsoft.public.excel.programming)
  • access 97 running in 2k3 server
    ... I am trying to move an access 97 database to a Windows 2003 server. ... Ultimately this database will be published through citrix, ... front end connected with an ODBC connection. ...
    (microsoft.public.windows.server.scripting)
  • move an access 97 database to a Windows 2003 server
    ... I am trying to move an access 97 database to a Windows 2003 server. ... Ultimately this database will be published through citrix, ... front end connected with an ODBC connection. ...
    (microsoft.public.access.conversion)
  • Re: Suggestion for DB Connection
    ... Joe wrote: ... > I am using Visual Basic 6.0 and Oracle 8 as database for my project. ... > connect to the database using Visual basic 6.0 is it ODBC connection ...
    (microsoft.public.vb.general.discussion)