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


B

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.
 
Ad

Advertisements

D

Douglas J. Steele

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

Advertisements

S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top