I need an expert - link not displaying correct data

[mcarter]

This one stumped our IT engineers.
I use Microsoft Access to link to ODBC areas. I have used Access for over 5
years now and this has never happened before. Our systems engineers think
the problem is in Access and cannot find a problem on our systems. This
problem is only happening for one particular table that we have, not all
tables.

I usually work remotely thru a web interface called Citrix.
I linked to a ODBC table when I was connected directly to our systems while
in the office and the data in the table was displayed correctly. When I
linked to the same table thru Citrix, the data was not the same, and was
incorrect. It was a new link, and the data was incorrect, but when I
refreshed the link, the data changed to be the correct data. I have never
had to immediately refresh a new link in order to get correct data.

Even more interesting, I also can connect to our systems thru VPN, instead
of Citrix. I tried the same thing while connected by VPN. I established a
new link to the table, and the data was incorrect data. When I refreshed the
link, the table did not change to be the correct data as it did for the
connection thru Citrix.

Is this a Microsoft Access problem where it is looking at a cached file
somewhere?
We have absolutely no idea why , when I link to a certain table, that
incorrect data is displayed. This doesn't happen to all tables, just this
one.

Any and all suggestions will be appreciated! I'm stuck!!!!!!

 

[Chris O'C via AccessMonster.com]

Please don't multipost. You asked this same question in the
export/import/linking group, where it's been answered. Can you see that
answer in this group? No. Neither can anyone else, so the experts may
answer it here too, then find out later they wasted their time by giving the
same answer. That time could have been spent helping someone who hadn't been
helped yet.

It's ok to crosspost, where you select more than one group to post a question
to. Everyone will see everyone else's replies, regardless of which group
they replied to.

Chris
Microsoft MVP

 

[mcarter]

O Hail The KING...sorry that I'm new to this and didn't realize how the
servants must serve.

 

[Chris O'C via AccessMonster.com]

No one is treating you like a servant. All the experts who answer questions
here are unpaid volunteers doing it in their own free time. There aren't
enough experts or free time to answer everyone's questions twice or more. By
letting people know how to avoid wasting the experts' time, more people can
have their questions answered.

Chris
Microsoft MVP