By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 1,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Problem in attacched a table with more than 255 field

P: n/a
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

Sep 17 '07 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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

Sep 17 '07 #2

P: n/a
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" <massimo.belgr...@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- Nascondi testo tra virgolette -

- Mostra testo tra virgolette -
In access 97 was possibile
Thanks for reply

Sep 18 '07 #3

P: n/a
On Sep 18, 5:38 pm, Massimo Belgrano <massimo.belgr...@gmail.com>
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

Sep 18 '07 #4

P: n/a
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


Sep 18 '07 #5

P: n/a
On Sep 17, 1:56 pm, Massimo Belgrano <massimo.belgr...@gmail.com>
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.

Sep 18 '07 #6

P: n/a
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" <massimo.belgr...@gmail.comwrote 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
Sep 18 '07 #7

P: n/a
On 18 Set, 15:35, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Tue, 18 Sep 2007 00:38:29 -0700, Massimo Belgrano

<massimo.belgr...@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.
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
Sep 18 '07 #8

This discussion thread is closed

Replies have been disabled for this discussion.