Linked table field limit problem

E

Eric C.

Access 2003 SP3 linking to an Oracle table with 360 fields via ODBC. Need
data from field 265, can't reach because table field limit is 255. Is there
a workaround? Access 2007 has same limit so upgrade sounds like it wouldn't
help.

Best,

Eric
 
J

Jeff Boyce

Eric

The Oracle table is apparently not well-normalized (<tongue-in-cheek
understatement>).

If the data you need is in a column you can't see in the original table, how
about have the Oracle DBA create a "view" that contains only those columns
you need to see? Then you would link to the view...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
C

Chris O'C via AccessMonster.com

That table isn't a table, it's a spreadsheet. Normalize the spreadsheet in
Oracle and link to the resulting tables from Access.

Chris
Microsoft MVP
 
J

Jeff Boyce

I dunno, those Oracle folks get mighty testy about folks messin' with their
data designs...<g>

Jeff B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

oracle fields exceed 255 3
Table Security in Access 2013 1
What is the limit on fields I can import into a table? 2
Linking to selected fields in an external table 4
Invalid Argument Error when importing .csv to Linked Table 1
Linking Access to selected fields in a large external table 1
Linked table column type changes from text to memo 1
Defining Text field sizes in destination Make-Table Query 3

Top