Column Limit in Access 2003

A

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.

dan0771 said:
Is the table column limit in Access 2003 still 255 as it is in Access
Click to expand...
2000?
 
D

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?
 
B

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)

dan0771 said:
I agree it should be plenty...the problem is I'm working with a legacy
Click to expand...
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?
 
Top