Increment of Records

[Katende Timothy]

Hi,
I have developed an access database but how do i
increase the number of records above its maximum value
which is about 33000 records for Access Professional. Or
alternatively is there any other version of Access with a
larger Records value than that of 33000.
Thanks
Timothy.

 

[Van T. Dinh]

33000 Records in a Table is tiny and there is no limit on the number of
Records in a Table. There is a size limit on the mdb file (1 GB for A97 and
2 GB for A2K and AXP).

Where did you get the impression that an Access Table is limited to 33K
Records?

 

[Jeff Pietsch]

Do you have a field in the table that you are using as a
record counter? If yes and it is defined as an integer
then the largest number it can be is 32767. If this is
the case, then change the field to a Long Integer.

JP