belovedcej
Programmer
I don't know if this is an Access question or an SQL question. But hopefully someone has encountered this before!
We have an Access database (2003) used just for reporting that links to views on an SQLServer (2000) database. A year into implementation it was determined that a column needed to be 50 characters instead of 35. Once the change was made on the server, I updated the links in Access. The text field still showed 35 as the limit. So I deleted the table and relinked it. It STILL showed 35 characters.
The only way we made it work was to go into the view on the server and do an explicity CAST to a varchar(50). Then when I refreshed the links it worked.
Now, a year later, it's happening again. Before we go change several views with explicit casts, I thought I'd ask - has anyone encountered this before and do you know how to fix it?
Thanks!
We have an Access database (2003) used just for reporting that links to views on an SQLServer (2000) database. A year into implementation it was determined that a column needed to be 50 characters instead of 35. Once the change was made on the server, I updated the links in Access. The text field still showed 35 as the limit. So I deleted the table and relinked it. It STILL showed 35 characters.
The only way we made it work was to go into the view on the server and do an explicity CAST to a varchar(50). Then when I refreshed the links it worked.
Now, a year later, it's happening again. Before we go change several views with explicit casts, I thought I'd ask - has anyone encountered this before and do you know how to fix it?
Thanks!
