Cannot see change in SQL DB - HELP

[RocketMan]

I am connected to a SQL DB View via Access. One of the columns has
had its size increased from varchar 64 to varchar 128 but I don't see
the new size even after relinking.

WHAT DO I DO!?

HELP!

 

[Kevin3NF]

Something sticking in my head about need to re-create the view on the SQL
Side as well...but I can't recall the specifics...

Can you drop and re-create?

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com

 

[dbahooker]

i'd reccomend using Access Data Projects; you don't need to worry
about this type of crap if you just used ADP

 

[dbahooker]

and technically; this is the difference between REFRESH and RELINK


Linked Table Manager doesn't allow you to REFRESH; so you're forced to
do this via code


MDB sucks-- grow up to ADP!