Re: Cannot see all the fields in an ODBC table/view

Hi,


If you start a brand new query with a simple SQL statement like:

SELECT * FROM tableName

do you get all the 181 columns?

If not, then *maybe* some of the 181 columns are not real columns but
computed columns (or otherwise) and NOT transmitted back... I am just
guessing here. Also note that each single record cannot exceed 4000
characters (excluding memo and ole fields), 2000 if Unicode compression if
off.

Also, if columnX is missing, does


SELECT columnX FROM tableName


get it? if not, maybe the datatype is somehow incompatible.

Note that I don't know anything about "Redbrick data warehouse".

Hoping it may help,
Vanderghast, Access MVP


"BAC" <BAC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D630494D-4C02-4A95-A861-A19DC2CC46ED@xxxxxxxxxxxxxxxx
Win 2000 Pro
Office 2003 Pro

I have a Redbrick data warehouse that includes a view of a table that has
181 fields in it. Using the Access Query grid, I get only 134 of these
fields.

Using MSQuery or a Pass-through query I can access all 181. One of the
fields that does not show up in the Access query grid is "LOB" that is the
60th field in the View and 72nd field in the underlying table.

I was under the impression that Access would allow me to see up to the 1st
255 fields in ODBC datasets.

I have verified that the query properties option "Output all fields" is
set
to yes. Is there any way to be able to access all 181 fields without
using
MSQuery or a passthrough query?

I now have a situation that will require users to maintain an "exclusion
list". My plan is to have them add the key value for excluded items to a
table and include an "is null" test against the table to excluded those
records. But Access will not allow me to reference local tables in
passthrough queries.

Buty if i could access that LOB field directly, I wouldn't have a problem
(i
use this technique in other places and it works flawlessly)

TIA

BAC


.