Table Size Restriction

  • Thread starter Thread starter Rose Mary
  • Start date Start date
R

Rose Mary

Is it possible to link to and manipulate (add, append,
etc.) a SQL Server table that has more than 255 columns
in it?

Can you run a query in Access that is linked to a SQL
Server table that has more than 255 columns?
 
Is it possible to link to and manipulate (add, append,
etc.) a SQL Server table that has more than 255 columns
in it?
Click to expand...

... and in addition to Lynn's answer, nobody has any business making a SQL
server table with more than 255 columns. Buy a Rolls Royce, get driving
lessons...


Tim F
 
Is it possible to link to and manipulate (add, append,
etc.) a SQL Server table that has more than 255 columns
in it?

Can you run a query in Access that is linked to a SQL
Server table that has more than 255 columns?
Click to expand...

Not to my knowledge.

You can create a View in SQL returning 255 or fewer columns and link
to that View. You may need to use passthrough queries to update the
table (since a Passthrough query obeys its own query engine's rules,
it's not limited by Access).
 
Back
Top