Updateable passthrough query

[eric.goforth]

Hello,

I have a bit of a Catch 22. I have a table in SQL server that has too
many columns for Access to display in a linked table. It appears that
Access will only display 255 or so columns in a linked table. If I use
a passthrough query I can view all my columns, but I can't update them.


I'm trying to write a little Access user interface to do some updates
in the table. The table is part of a vendor application, so changing
the table structure is not an option, although with that many columns
in one table I'd imagine that there's probably more room for more data
normalization.

-Eric

 

[Rick Brandt]

Hello,

I have a bit of a Catch 22. I have a table in SQL server that has too
many columns for Access to display in a linked table. It appears that
Access will only display 255 or so columns in a linked table. If I
use a passthrough query I can view all my columns, but I can't update
them.


I'm trying to write a little Access user interface to do some updates
in the table. The table is part of a vendor application, so changing
the table structure is not an option, although with that many columns
in one table I'd imagine that there's probably more room for more data
normalization.

-Eric

Can you create a view on the server with a subset of the fields that will be
editable?

 

[eric.goforth]

Rick,

I could try that, but I'd rather not if I can get around it. Putting a
new view on the SQL Server would require getting the DBA's to approve
it.

-Eric

 

[Van T. Dinh]

It doesn't look like you have any choice but to go to the DBA for a View or
to re-structure the Table(s).

 

[Rick Brandt]

It doesn't look like you have any choice but to go to the DBA for a
View or to re-structure the Table(s).

Another option is to go with an unbound approach. Use a Pass-through query to
populate controls on an unbound form and then use additional Pass-Throughs to
perform updates and insertions based on the changes the user enters.

A bit more work, but eliminates the need to involve the DBA.