Problem viewing via ODBC link

[garfield1]

Hi
This is after several searches on the net without success I decided to post here. My problem is rather "odd":
I work in an Access database SQLServer 2000 (sp3). It has been several times that happens, the data displayed on the tables via Access are redundant. Let me explain: when viewing the data (without complaint, just by opening the table), if for example I must display 100 lines, those 100 lines will be absolutely identical in Access but in reality under SQLserver they are completely different. Good data are clearly those of SQLserver. I have to redo the links, but sometimes without success. Thank you for your help.

[Glenny]

Hello
I think there are several ways out there. Have you tried to delete outright, the Access table (linked) and recreate it?
The ODBC driver is this the latest version?
It seems there is a SP3a, which contains an ODBC driver:

http://www.microsoft.com/downloads/d...F-ACACE5369FA3

Tell us what happens and good luck.

[garfield1]

Hi
Thank you for your answer. I already delete the Access table, redo the links, recreated a low Access , occasionally it works but I think it's random. What scares me is that users have this bug and make some cuts in the tables because of that there is a wholesale disaster!

The ODBC driver is this the latest version?

Also I installed the SP3a. Any more suggestions on this. Any help please.

[Glenny]

Hi
Just go through this -
In "Tools" / "Options" tab "Advanced", tried to "play" with the "ODBC Refresh Interval (sec)": enter "1" for an instant update forced then modify the value if performance is too corrupted. In all cases, look, first, if your problem is solved.
Hope this helps you and your problem is solved. I repeat after every attempt please check it the problem is solved.

[garfield1]

Hey

Have you tried to delete outright, the Access table (linked) and recreate it?

All the above was done by me, but still I was with the same problem.

The ODBC driver is this the latest version?

After reinstall SP3a is not the problem resurfaced , I hope that the problem was much of the installation. Thanks for your help.

[Glenny]

Hello

After reinstall SP3a is not the problem resurfaced , I hope that the problem was much of the installation.

Mostly in such cases it is the drivers of the hardware that given the problem. I am happy that you have solved your problem very soon with wasting the time. Best of luck.