Unable to Modify a Property

[Tom]

Good Afternoon,

I'm looking for a way to update the Field Size property of a field in a
table that is linked to an SQL table (view, actually). Currently, it is set
to 50, and I need to update it. However, Access is telling me that it can't
adjust it, because it is linked.

My question is, how is the best way to update the field to a larger number?
Do I need to "unlink" the table? If so, how's the best way to do that? Is it
impossible?

 

[John Spencer]

Do you have the necessary permissions to edit the MS SQL tables?

IF so, one method would be to construct a DDL pass through query.



John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Tom]

I have permissions on the view, but the view itself does not specify the
length of the field being returned, as far as I can tell.

I can modify the view.. What type of modification should I perform?

 

[Douglas J. Steele]

You have to modify the table on which the view is based.

 

[Tom]

Thanks, all.

It turns out that I couldn't modify the table: the table was a Varchar(150)
but Access was looking ast the view of the table and reading a length of 50.
I have NO idea why.

But, I just modified the SQL of the view to return CAST (mycolumn as
VARCHAR(150)) as mycolumn and it worked like a charm.

 

[Larry Linson]

Thanks, all.

It turns out that I couldn't modify the table: the table was a
Varchar(150) but Access was looking ast the view of the table and reading
a length of 50. I have NO idea why.

But, I just modified the SQL of the view to return CAST (mycolumn as
VARCHAR(150)) as mycolumn and it worked like a charm.

Views on the Server DB appear the same to Access as Tables on the Server.
You took proper action to deal with the SQL of the View on the Server.

Larry Linson
Microsoft Office Access MVP