How do i link sources with more than 255 fields?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an old school database that I need to link to. All the odbc
connectivity exists. I am able to run Crystal Reports on the database and
extrapolate data at will...I'm trying to replace some of those Crystal
Reports (which are time consuming to keep up to date) with an Access
form/report. The problem I have is that the original database (which has
widespread distribution and therefore not an option to be replaced by my soon
to be great database) has more than 255 fields and therefore I am unable to
pull all the data from the original database. Yes of course I do happen to
need field 256 but I'm unable to distinguish which fields I want when I odbc
link to it from Access. If anyone has any ideas or suggestions on how I can
pull that 256'th (and higher) field to use in my database I would appreciate
it.

Thanks

Raúl
 
Well, unfortunately, there is no way. The 255 maximum is written in stone.
However, do you really need ALL those fields? Try writing a pass through
query that pulls only the fields you need.
 
hi,
if i understand you correctly, it sounds like you may have
an old file based db. you might try to import 255 fields
and have access analyze it. it might wish to bust up the
giant table into several smaller tables. i don't know this
but it might be worth a try.
good luck.
 
Back
Top