Access 2k - ODBC SQL 2k data refresh problem

V

Vonlar

My corporate environment is Access 2000. I have established ODBC links to
SQL Server 2000 views in Access. Occasionally my users are having issues
with updated data not refreshing in Microsoft Access, yet the data is correct
in SQL 2000.

A refresh of the link will usually solve the issue. We have the latest SQL
Server patches as well as Server 2000 patches.

I don't want to create a vba link refresher in the hundreds of Access
databases out there, is there another fix? A setting that we're missing?
 
Top