How many records can you have in Access database

[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)

[Sandra Daigle]

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.

[david epsom dot com dot au]

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

Yes :)

(david)

"Sandra Daigle" <Inv...@KeepYourSpam.org> wrote in message
news:OSUqIq9w...@TK2MSFTNGP11.phx.gbl...

[Richard Krupa]

Whats a tootsie pop? ;)

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:uiAZyuBx...@tk2msftngp13.phx.gbl...

[Larry Linson]

"Richard Krupa" wrote

> Whats a tootsie pop? ;)

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

[Jeffri Cox (Newsgroups)]

Here are some links that might help.

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/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%20Access%20Limitations.pdf

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

"Sandra Daigle" <Inv...@KeepYourSpam.org> wrote in message
news:OSUqIq9w...@TK2MSFTNGP11.phx.gbl...