How many records can you have in Access database

unread,

Dec 16, 2003, 6:36:45 AM12/16/03

to

By my count,

132,406,200 records, one Boolean field.

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

(david)

unread,

Dec 16, 2003, 8:47:17 AM12/16/03

to

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.

unread,

Dec 16, 2003, 4:29:35 PM12/16/03

to

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

unread,

Dec 16, 2003, 10:24:51 PM12/16/03

to

Whats a tootsie pop? ;)

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

unread,

Dec 16, 2003, 11:49:58 PM12/16/03

to

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

unread,

Dec 17, 2003, 2:50:03 PM12/17/03

to

Here are some links that might help.

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