By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,034 Members | 1,367 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,034 IT Pros & Developers. It's quick & easy.

Link Table in Access 2000

P: n/a
Is there a limit on the number of columns that a table can have when
you link to the table using Access 2000?

Attempting to set up a link to an Oracle table that has 300+ columns -
(reason for this denormalized table is for a web application). When we
link to this table we are only seeing the first 255 columns in Access

We have successfully linked several other Oracle tables getting all
the columns but the number of columns on these tables that where
successfully linked are no where near 300.

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Yes, 255 is the limit. You'll need to ask the Oracle DBA to make 2 updatable
views, and you can link to those instead.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.