Linked SQL Server table with 261 Columns

J

JimP

Only 255 columns are visible to MS-Access based on the current limitations.

Just looking for confirmation that the SQL Server table will need to be
split into multiple tables. i.e there is no code or other work around to
retrieve the remaining columns.
 
B

Ben

Jim,

Why don't you ask your IT to create a view of the table with only the
columns/fields you need and then you can link to the view. That will
solve your problem.

Ben
 
S

Stefan Hoffmann

hi Jim,
Just looking for confirmation that the SQL Server table will need to be
split into multiple tables.
Click to expand...
In almost every case a table consisting of more then 20 or 30 fields is
not properly normalized.
i.e there is no code or other work around to retrieve the remaining columns.
Click to expand...
Use views with fewer fields as linked table source.


mfG
--> stefan <--
 
S

Sylvain Lafontaine

See also http://support.microsoft.com/kb/q209123/ if you want to have an
updatable linked view.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
 
Top