Maximum # of records allowed in a database?

[dchendrickson]

I am using Access2002/XP.

I was told that Access allowed a maximum of 32,768
records in a database. And I came across that information
somewhere in help. After reading some other information I
now see in help under Access Specifications that a
database is limited to 32,768 OBJECTS, not records. Is a
record considered an object?

It seams from re-reading the info that the number of
records would be limited by the 2GB file size limit.

The database I am working on is tracking the circuit
paths for a flight simulator. With the complexity of the
machine, I will surpass the 32,768 record count easily. I
can break the tables in to multiple files and link, but
it would be cleaner not to have to do that.

Thanks,

-dc

 

[Kevin3NF]

Nope....a table is an object (and queries, reports, etc.). A record is not
an object...there are Access tables wordwide with 1,000,000+ records

 

[dchendrickson]

Kevin,

Thanks yet again.

-dc

-----Original Message-----
Nope....a table is an object (and queries, reports, etc.). A record is not
an object...there are Access tables wordwide with 1,000,000+ records

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm






.