Column Limit in Access 2003

[dan0771]

Is the table column limit in Access 2003 still 255 as it is in Access 2000?

 

[Allen Browne]

Yes. Since that's about 4 times what you will ever need in a normalized
database, there is no need to change it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Is the table column limit in Access 2003 still 255 as it is in Access

2000?

 

[dan0771]

I agree it should be plenty...the problem is I'm working with a legacy system built in Paradox where 2 table have close to 400 columns. As luck would have it, the 30 columns I need are past the 255 limit in Access. Is there any way to link to a table using an SQL script where it would just link the 30 columns I need (Link not Import)? Can Access link to a view?

 

[Brendan Reynolds]

You can link to a SQL Server view - it appears as a table to Access. Don't
know about Paradox, though. If you haven't tried it already, create your
view and try to link it in the same way that you would link a table. If the
feature is supported with Paradox as it is with SQL Server, you should see
the view listed along with the tables.

--
Brendan Reynolds (MVP)

I agree it should be plenty...the problem is I'm working with a legacy

system built in Paradox where 2 table have close to 400 columns. As luck
would have it, the 30 columns I need are past the 255 limit in Access. Is
there any way to link to a table using an SQL script where it would just
link the 30 columns I need (Link not Import)? Can Access link to a view?