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...
> 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
>
>