P
Peter S.
Okay I know this has been discussed ad naseum before, regarding
the limit of Access not being able to contain greater than 255 columns
in a linked table. I have this issue as well.
However the table I am dealing with(via an ODBC) connection is a CACHE
database that interfaces with some company software. I have no control
*whatsoever* to manipulate its size. I would like to inspect the 255+ columns
and write some queries against it but this 255 field limit is a MAJOR hassle.
Some workarounds I am hoping are as follows. After/during when I link to
the table can I control what fields that Access contains in the linked table
in
my database? (Unfortunately Access is not showing a good chunk of the fields
I would like to inspect). Can I manipulate my query (I gave this a try in SQL
View) to pull fields that are not currently in my linked table. Access
doesn't seem to like
this but perhaps there are other ways around this????
Last, is it confirmed that Access 2007 won't allow over 255 fields? If not I
would
certainly love to try that as a workaround....
-Peter
the limit of Access not being able to contain greater than 255 columns
in a linked table. I have this issue as well.
However the table I am dealing with(via an ODBC) connection is a CACHE
database that interfaces with some company software. I have no control
*whatsoever* to manipulate its size. I would like to inspect the 255+ columns
and write some queries against it but this 255 field limit is a MAJOR hassle.
Some workarounds I am hoping are as follows. After/during when I link to
the table can I control what fields that Access contains in the linked table
in
my database? (Unfortunately Access is not showing a good chunk of the fields
I would like to inspect). Can I manipulate my query (I gave this a try in SQL
View) to pull fields that are not currently in my linked table. Access
doesn't seem to like
this but perhaps there are other ways around this????
Last, is it confirmed that Access 2007 won't allow over 255 fields? If not I
would
certainly love to try that as a workaround....
-Peter