What are max values? Record size, number of fields

  • Thread starter Thread starter Laurel
  • Start date Start date
L

Laurel

I'm importing data into a db from a *.csv file. I keep bumping into
situations where the import works OK, but the resulting table seems to be
beyond some limit.

1 - I successfully imported 216 columns, but when I try to change a datatype
in the resulting Access table, I get a "record is too large" error. I get
the same error if I try to change the length of a text column. This is true
no matter what column I try to alter.

2 - I successfully imported approximatley 200 columns (leaving out large
free-form text data). I'm able to change column attributes in this table.
I made a copy of it, using Save As, deleted all the records, and in this
copy, if I try to change even one column attribute (e.g., a text length -
same change I'd made in the original table), I get "too many fields
defined."

I've tried to find information about max number of fields, max record
length, etc., in HELP, but it's no help. HELP.

TIA
Frustrated in Boston
 
I'm importing data into a db from a *.csv file. I keep bumping into
situations where the import works OK, but the resulting table seems to be
beyond some limit.

1 - I successfully imported 216 columns, but when I try to change a datatype
in the resulting Access table, I get a "record is too large" error. I get
the same error if I try to change the length of a text column. This is true
no matter what column I try to alter.

2 - I successfully imported approximatley 200 columns (leaving out large
free-form text data). I'm able to change column attributes in this table.
I made a copy of it, using Save As, deleted all the records, and in this
copy, if I try to change even one column attribute (e.g., a text length -
same change I'd made in the original table), I get "too many fields
defined."

I've tried to find information about max number of fields, max record
length, etc., in HELP, but it's no help. HELP.

TIA
Frustrated in Boston
Click to expand...

Access Help + Index
Type in the Keyword Box:
Specification
Select from the list:
Access Specifications
 
Back
Top