Linked SQL Server View not updating

  • Thread starter Thread starter calvinX
  • Start date Start date
C

calvinX

Hi All,

I have a view in a SQL Server 2000 DB that will not update the design in my
msaccess database (.mdb). I recently increased the size of one of the
fields from 5 characters to 10. This change has rippled through everywhere
else except this one linked view. In the SQL server EM it shows up as the
correct length and the data shows properly. In msaccess it truncates the
data to 5 characters, even after I have refreshed the table. In the design
view it shows as 5 characters.

I am figuring that somewhere there is a recent datatable cache in access or
something that allows it to retain the design data for the views.

Any help would be much appreciated.

Calvin
 
Calvin

I'm not totally clear from your description whether your Access db is linked
to the SQL-Server view. If it is, and if you have not refreshed (or deleted
and re-linked), the definition Access knows is still the old one.

Good luck

Jeff Boyce
<Access MVP>
 
I have exactly the same problem. Updating any design features in a sql
server table is reflected in any associated views within sql server.
However within an MS access application with linked tables and views,
the tables are updated on a refresh but the view is not. I can delete
the linked view and recreate it but it still remembers the 'old'
metadata design.



Did you resolve it?
 
I can't replicate your experience ... if I delete a link to a SQL-Server
view and re-link to it, the new version shows (of course, I need to ensure
that the new SQL-Server-based view has proper permissions).

Does this happen if you start with a completely empty, new .mdb file, too?

Jeff Boyce
<Access MVP>
 
Back
Top