Problem in attacched a table with more than 255 field

[Massimo Belgrano]

I have a problem attacching via odbc a table with more than 255 fields

ms access 2003 & 2007 don't read fields over the 255 field pos
Can anyone help me?

Thanks in advance

[Tom van Stiphout]

That is an Access limitation. It just cannot handle that.
Sometimes you can create a view (with fewer columns) in the backend
database, and attach to it rather than the table.

-Tom.

"Massimo Belgrano" <ma**************@gmail.comwrote in message
news:11**********************@n39g2000hsh.googlegr oups.com...

>I have a problem attacching via odbc a table with more than 255 fields

ms access 2003 & 2007 don't read fields over the 255 field pos
Can anyone help me?

Thanks in advance

[Massimo Belgrano]

On 18 Set, 00:34, "Tom van Stiphout" <tvanstiphout.no.s...@kinetik-
it.comwrote:

That is an Access limitation. It just cannot handle that.
Sometimes you can create a view (with fewer columns) in the backend
database, and attach to it rather than the table.

-Tom.

"Massimo Belgrano" <[e-mail] in message

news:11**********************@n39g2000hsh.googlegr oups.com...

I have a problem attacching via odbc a table with more than 255 fields

ms access 2003 & 2007 don't read fields over the 255 field pos

Can anyone help me?

Thanks in advance- Nascondi testo tra virgolette -

- Mostra testo tra virgolette -

In access 97 was possibile
Thanks for reply

[AnandaSim]

On Sep 18, 5:38 pm, Massimo Belgrano <[e-mail]>
wrote:

In access 97 was possibile
Thanks for reply

Use Pass Through Query and pick only the fields you need in the query.

HTH
Ananda

[Rick Brandt]

Massimo Belgrano wrote:

In access 97 was possibile
Thanks for reply

No, it had the same limitation.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[lyle]

On Sep 17, 1:56 pm, Massimo Belgrano <[e-mail]>
wrote:

I have a problem attacching via odbc a table with more than 255 fields

ms access 2003 & 2007 don't read fields over the 255 field pos

Once in the olden days I had a table with ten fields.

But now I pretty much have just two and three field tables:

ID Data

or

ID Link1ID Link2ID.

Beyond 255 is beyond my imagination ... way (about 230) beyond.

[Tom van Stiphout]

On Tue, 18 Sep 2007 00:38:29 -0700, Massimo Belgrano
<ma**************@gmail.comwrote:

No it wasn't. Access cannot handle tables with more than 255 columns.
But perhaps you can look at your A97 database and give us more details
as to what you were doing.

-Tom.

>On 18 Set, 00:34, "Tom van Stiphout" <tvanstiphout.no.s...@kinetik-
it.comwrote:

>That is an Access limitation. It just cannot handle that.
Sometimes you can create a view (with fewer columns) in the backend
database, and attach to it rather than the table.

-Tom.

"Massimo Belgrano" <[e-mail] in message

news:11**********************@n39g2000hsh.googleg roups.com...

>I have a problem attacching via odbc a table with more than 255 fields

ms access 2003 & 2007 don't read fields over the 255 field pos

Can anyone help me?

Thanks in advance- Nascondi testo tra virgolette -

- Mostra testo tra virgolette -

In access 97 was possibile
Thanks for reply

[Massimo Belgrano]

On 18 Set, 15:35, Tom van Stiphout <[e-mail]:

On Tue, 18 Sep 2007 00:38:29 -0700, Massimo Belgrano

<[e-mail]:

No it wasn't. Access cannot handle tables with more than 255 columns.
But perhaps you can look at your A97 database and give us more details
as to what you were doing.

-Tom.

The original table is a dbf manage by advantagedatabase.com
with 500 field named fi001 to fi500
I am using it from access 97 with isam dbf and work
if i am using from access 2000 to 2007 i must use the odbc driver of
www.advantagedatabase.com
i can attach table without error but if i want made a query like
select fi300 from dbtest; i receive imput value of parameter
dbtest.fi300

select fi200 from dbtest; works file