Access 2007 Specifications

[Rick Brandt]

Huh? While I agree with you that it would be worthwhile to be able
to query those external tables and also be able to have more than
255 fields in a query, I don't see that any of this is an argument
for changing the design of Jet itself to allow more than 255 fields.
It is, after all, a relational database.

Again, I was only saying that it would be nice if Access could "work with"
external data sources that don't necessarily follow the rules that Jet imposes
upon its own tables.

 

[David W. Fenton]

Again, I was only saying that it would be nice if Access could
"work with" external data sources that don't necessarily follow
the rules that Jet imposes upon its own tables.

But the context was someone demanding that Jet be altered to allow
more fields in its tables. I don't support that at all, and I doubt
you do, either.

But decoupling the querying engine from that limitation when
querying non-Jet dbs would be an obvious good -- as you say, there's
no reason to limit external data to Jet's internal limitations.

 

[Kerry]

Hi Ananda,

Yes, this helps. Thanks. I can use a SQL Passthrough query to get
data from columns after the 255th column.