{SOLVED} Access: Application Limitations

Hey root.
There doesn't seem to be a maximum limitation on the number of records - Dreamboat or Down will probably confirm or refute this.
I think it is entirely dependent on what your records consist of - hoew many fields and the size of those fields. I've seen people with records numbering in the millions.

This is from the table specs in the Access help files:

Table specifications

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 1,024. 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
Number of characters in a field property setting 255

HTH
Gram