M
Mike
i would like to easily find the record limit for each of
the versions of access
the versions of access
K
Kevin3NF
Easy...there isn't one.
A97 has a file size limit of 1GB
A2000/2002/2003 limit is increased to 2GB
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
A97 has a file size limit of 1GB
A2000/2002/2003 limit is increased to 2GB
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
A
Albert D. Kallal
There is not real record limit (it is in the millions of records anyway).
The limit is based on the file size. With smaller records, you can fit more
into this fixed limit. So, larger records = less records into the fixed
allowed space
a97 1 gig
a2000 2 gig
So, if you take an average address for a mailing lable, you will find they
take out about 150 characters.
With 1 million of those address names, you would get a file size of about
150 megs.
The limit is based on the file size. With smaller records, you can fit more
into this fixed limit. So, larger records = less records into the fixed
allowed space
a97 1 gig
a2000 2 gig
So, if you take an average address for a mailing lable, you will find they
take out about 150 characters.
With 1 million of those address names, you would get a file size of about
150 megs.
J
Juan Paulo
And If you work with Access Data Proyects
(Access-SQL Server) *.adp instead *.mdb
Your limit is your Hardware (Unlimited).
(Access-SQL Server) *.adp instead *.mdb
Your limit is your Hardware (Unlimited).