microsoft database training - Access Advanced

Hi Vicky,

Thanks for the post, in answer to your question I have put together a little list which might help with maximum amounts:

MAXIMUMS:

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 - Actual max is less, since access opens some by default
Table size: 1Gb (gigabyte) 2Gb for Access 2003
Number of characters in a Text field: 255
Number of characters in a Memo field: 65,535 when entering data through 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: 2048
Number of characters in a table or field description: 255
Number of characters in a record (excluding Memo and OLE Object fields): 2000
Number of characters in a field property setting: 255

Although nowhere can I find an answer to how many line items in a table, other than maximum table size being 1/2Gb, Still I hope that the above helps in some way.

Best regards, Pete