how many records can microsoft access hold in total?

"denish" <(E-Mail Removed)> wrote in message
news:8A6FAF69-D921-40D0-A300-(E-Mail Removed)
> how many records can microsoft access hold in total?

http://groups.google.com/groups?as_q...ft+access+hold

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

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)

"denish" <(E-Mail Removed)> wrote in message
news:8A6FAF69-D921-40D0-A300-(E-Mail Removed)...
> how many records can microsoft access hold in total?

denish wrote:
> 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.

--
Joseph Meehan

Dia duit

On Mon, 30 Jan 2006 17:52:35 -0800, denish
<(E-Mail Removed)> wrote:

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

On Mon, 30 Jan 2006 21:11:10 -0500, "Dirk Goldgar"
<(E-Mail Removed)> wrote:

>"denish" <(E-Mail Removed)> wrote in message
>news:8A6FAF69-D921-40D0-A300-(E-Mail Removed)
>> how many records can microsoft access hold in total?
>
>http://groups.google.com/groups?as_q...ft+access+hold

<click>

<boggle>

Results 1 - 10 of 18,300

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

John W. Vinson[MVP]