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

 

[david epsom dot com dot au]

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

Yes

(david)

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)

 

[Richard Krupa]

Whats a tootsie pop?

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

center

Yes

(david)

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)

 

[Larry Linson]

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

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)