By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,129 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 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
2000.

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.

thanks
Trevor
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.