How many records can you have in Access database

  • Thread starter Thread starter david epsom dot com dot au
  • Start date Start date
D

david epsom dot com dot au

By my count,

132,406,200 records, one Boolean field.

87,486,165 records, indexed autonumber with one Boolean field.


(david)
 
Isn't this kind of like the question "How many licks to get to the center of
a tootsie pop?"

:-D
 
Isn't this kind of like the question "How many licks to get to the center

Yes :)

(david)


Sandra Daigle said:
Isn't this kind of like the question "How many licks to get to the center of
a tootsie pop?"

:-D


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

By my count,

132,406,200 records, one Boolean field.

87,486,165 records, indexed autonumber with one Boolean field.


(david)
Click to expand...
Click to expand...
 
Whats a tootsie pop? ;)

david epsom dot com dot au said:
Isn't this kind of like the question "How many licks to get to the
Click to expand...
center

Yes :)

(david)


Sandra Daigle said:
Isn't this kind of like the question "How many licks to get to the
Click to expand...
center
of
a tootsie pop?"

:-D


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

By my count,

132,406,200 records, one Boolean field.

87,486,165 records, indexed autonumber with one Boolean field.


(david)
Click to expand...
Click to expand...
Click to expand...
 
Whats a tootsie pop? ;)
Click to expand...

"Tootsie Roll" is a chocolate flavored soft candy in the US. "Tootsie Pop"
is a popsicle, hard sugary shell with the center made of Tootsie Roll.
 
Here are some links that might help.



http://support.microsoft.com/defaul...port/KB/ARTICLES/Q113/4/40.asp&NoWebContent=1



http://www.roimail.com/help/msaccess_limits.html



http://condor.ucr.edu/class/gerdes/mgt230s03/slides/MS Access Limitations.pdf



http://condor.ucr.edu/class/gerdes/mgt230s03/slides/MS Access Limitations.pdf




Sandra Daigle said:
Isn't this kind of like the question "How many licks to get to the center of
a tootsie pop?"

:-D


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

By my count,

132,406,200 records, one Boolean field.

87,486,165 records, indexed autonumber with one Boolean field.


(david)
Click to expand...
Click to expand...
 
Back
Top