Import or link 540 field SQL table into ACCESS 2

[elallred]

Since ACCESS has a limit of 255 fields per table, I find when I find that whether I link or import the table Paf6 which resides on our SQL server, I get only the first 255 fields out of the 540 fields it contains. Is there a way in which I can get ACCESS to import or link all
540 fields?

E. Allred

 

[JoeMiller]

Nope, maybe you can split the table into two tables and link them via a one to one relationship?

Joe Miller
joe.miller@flotech.net

 

[MichaelRed]

Can you use ADO recordsets and define the specific fields?

You may also want to review the schema of the db which iincludes that many fields in a single table. I cannot imagine that such a table would not have more 'junque' (e.g. either repeated information or just plain left blank) than useful info. The only instance of this size table in my 10 year experience w/ relational dbs is a BADLY reworked legacy db. Many (most? all?) relational dbs, including Ms. Access limit the number of fields in as table. MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[tlbroadbent]

Rather than split the table on SQL Server, create three views - each with the primary-key field(s) and a unique subset of the fields in the table. Link the Views in the Access database. You can then query the linked views just as you would linked tables. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin