Is there a limit to records in an 2003 access table or applicatio.

[btallent]

I am trying to decide if I should use seperate tables or create a new data
base for 4 applications. The quantity of records will be approx 65000
records per year.

 

[Douglas J. Steele]

65000 records isn't very much for Access. One table should be all you need.

 

[StCyrM]

Good morning

If you use a Counter(AutoNumber) as the primary key, a table
can contain up to four billion records. The maximum number of records
in the table is also limited by the maximum size of a database.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.