FP2003 SP2 - create database error

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

After creating a survey questionnaire I clicked in Form Properties, 'send to
database', Options, 'create database' and get an immediate error:
"Couldn't append to the table - Error: too many fields defined."

Is there a limit? If so, how many? I have about 340. Or is there a limit to
the length of the name= field?

Hope you can help. Thanks.
... rick
 
Maybe this will help...

Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64

Number of fields in a table 255

Number of open tables 2048. The actual number may be less because of
tables open internally by Microsoft Access.

Table size 1 gigabyte
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through
the user interface;

1 gigabyte when entering data programmatically.
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object
fields) 2,000

HTH

John Malone
=================
| After creating a survey questionnaire I clicked in Form Properties, 'send
to
| database', Options, 'create database' and get an immediate error:
| "Couldn't append to the table - Error: too many fields defined."
|
| Is there a limit? If so, how many? I have about 340. Or is there a limit
to
| the length of the name= field?
|
| Hope you can help. Thanks.
| .. rick
|
|
 
Back
Top