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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top