sql server odbc: Hi All,


I asked this question over in m.p.access.tablesdbdesign but thought I may
also get a response here. Here goes:

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,

did you try to remove the linked view completely from
the Access DB and re-link it again?

Rainer

"calvinX" <robot_spamrelief_drone_nospam@hotgrail.com> schrieb im
Newsbeitrag news:e59NbSlnDHA.2808@TK2MSFTNGP10.phx.gbl...
[quoted text, click to view]