access quiz

[Guest]

how many records can microsoft access hold in total?

 

[Dirk Goldgar]

how many records can microsoft access hold in total?

http://groups.google.com/groups?as_q=how+many+records+can+microsoft+access+hold

 

[david epsom dot com dot au]

How big is your hard disk, plus all attached network storage, plus all
available offline storage?

'Access' can hold about 50 million records per gigabyte, when using the Jet
storage engine.

(david)

 

[Joseph Meehan]

how many records can microsoft access hold in total?

No limit to the number. The total size of the file must be smaller than
one or two Gig depending on the version.

 

[John Vinson]

how many records can microsoft access hold in total?

THat's an Access FAQ - gets asked once or twice a week here.

There is no explicit limit. A single .mdb file cannot exceed 2 GByte,
and you could have a backend database with just one table in it if you
wished.

In practice, the biggest Access table in production use of which I am
aware is over 20,000,000 rows.

John W. Vinson[MVP]

 

[John Vinson]

http://groups.google.com/groups?as_q=how+many+records+can+microsoft+access+hold

<click>

<boggle>

Results 1 - 10 of 18,300

Yep. That's a *frequently* asked question all right!

John W. Vinson[MVP]