Access error on citrix environment only.

[Parthiban s]

Recently I migrated a MS Access app from mdb data tables to oracle db.
It all works fine when connected locally to server but errors out in
citrix for only two screens with below error.
unable to insert into link table.
ORA- 1745 - invalid host or bind variable name.

when i digged into the issue, found possible keyword column issue. Both
the tables have a keyword column(Comment as column name which works fine
when used by noncitrix environment). I had renamed Comment to comments
in the table and forms,queries to avoid possible errors. waiting for the
citrix team to deploy it to the test environment. I am guessing of other
possiblities since its blocking many users daily activities and looking
for your expertise help. Do you knw of any other causes for the error
above with citrix environment alone. Thanks in advance.

*** Sent via Developersdex http://www.developersdex.com ***

[paii, Ron]

Check that your Citrix team is providing a copy of the front-end mdb for
each user, same as with stand-alone workstations. This may not be cause of
your current problem, but will prevent others.

"Parthiban s" <pa*************@gmail.comwrote in message
news:47*********************@news.qwest.net...

>
Recently I migrated a MS Access app from mdb data tables to oracle db.
It all works fine when connected locally to server but errors out in
citrix for only two screens with below error.
unable to insert into link table.
ORA- 1745 - invalid host or bind variable name.

when i digged into the issue, found possible keyword column issue. Both
the tables have a keyword column(Comment as column name which works fine
when used by noncitrix environment). I had renamed Comment to comments
in the table and forms,queries to avoid possible errors. waiting for the
citrix team to deploy it to the test environment. I am guessing of other
possiblities since its blocking many users daily activities and looking
for your expertise help. Do you knw of any other causes for the error
above with citrix environment alone. Thanks in advance.

*** Sent via Developersdex http://www.developersdex.com?wp_ml=0 ***

[Tony Toews [MVP]]

Parthiban s <pa*************@gmail.comwrote:

>
Recently I migrated a MS Access app from mdb data tables to oracle db.
It all works fine when connected locally to server but errors out in
citrix for only two screens with below error.
unable to insert into link table.
ORA- 1745 - invalid host or bind variable name.

Possibly the Citrix server has a different version of the Oracle driver software or
Access than you do? Just guessing.

>when i digged into the issue, found possible keyword column issue. Both
the tables have a keyword column(Comment as column name which works fine
when used by noncitrix environment). I had renamed Comment to comments
in the table and forms,queries to avoid possible errors. waiting for the
citrix team to deploy it to the test environment. I am guessing of other
possiblities since its blocking many users daily activities and looking
for your expertise help.

Googling on the message shows a similar error using the keyword desc (likely for
descending) so you're likely on the right track.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Tony Toews [MVP]]

"paii, Ron" <no**@no.comwrote:

>Check that your Citrix team is providing a copy of the front-end mdb for
each user, same as with stand-alone workstations. This may not be cause of
your current problem, but will prevent others.

Just to make life easier I specifically created the Auto FE Updater utility so that I
could make changes to the FE MDE as often as I wanted and be quite confident that the
next time someone went to run the app that it would pull in the latest version. For
more info on the errors or the Auto FE Updater utility see the free Auto FE Updater
utility at http://www.granite.ab.ca/access/autofe.htm at my website to keep the FE on
each PC up to date.

In a Terminal Server or Citrix environment the Auto FE Updater now supports creating
a directory named after the user on a server. Given a choice put the FE on the
Citrix server to reduce network traffic and to avoid having to load objects over the
network which can be somewhat sluggish.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/