Number of Records

  • Thread starter Thread starter Guest
  • Start date Start date
No but there is a limit to file size depending on the version of Access you
are using.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Is there a limit to the number of records hat can be stored in a data Base?
Click to expand...

Nominally, no; I'm aware of Access JET databases with over 20,000,000 records
in the largest table. The limitation is on the total size in bytes of the
database file - two gigabytes (two billion bytes). This size would include all
the overhead, systems tables, forms, reports, etc.; but you can use a split
database architecture to put the biggest table in one .mdb file and everything
else in one or more additional files.

In practice if you have over a few million records, you should look to
SQL/Server or another client/server architecture; however, Access would still
be an excellent choice as a user interface to the data.

John W. Vinson [MVP]
 
NO PROBLEMS, CONTACT ME...
--
PACALA JAN [ACCESS DEVELOPER]
SEND 10$ TO...
ACCOUNT:
SK31 1100 0000 0026 1674 0428
SwiftCode: TATRSKBX
Tatra banka as,Hodzovo nam.3, 811 06 Bratislava
(e-mail address removed)
SKYPE: PACALA.BA1
 
these newsgroups are for the FREE exchange of ideas, information, and
assistance. this is absolutely NOT the place to troll for business, such
postings are not welcome, and they make such a bad impression that it can
only hurt your reputation in the Access community.

if you want to post actual advice and assistance here in the newsgroups for
all to benefit from, or post questions of your own, then your participation
will be welcomed.


NO PROBLEMS, CONTACT ME...
--
PACALA JAN [ACCESS DEVELOPER]
SEND 10$ TO...
ACCOUNT:
SK31 1100 0000 0026 1674 0428
SwiftCode: TATRSKBX
Tatra banka as,Hodzovo nam.3, 811 06 Bratislava
(e-mail address removed)
SKYPE: PACALA.BA1


Roger Bell said:
Is there a limit to the number of records hat can be stored in a data Base?

Thanks
Click to expand...
Click to expand...
 
Watch out!! Arno R (the Rat) is creating a website Who Is Tina.


tina said:
these newsgroups are for the FREE exchange of ideas, information, and
assistance. this is absolutely NOT the place to troll for business, such
postings are not welcome, and they make such a bad impression that it can
only hurt your reputation in the Access community.

if you want to post actual advice and assistance here in the newsgroups
for
all to benefit from, or post questions of your own, then your
participation
will be welcomed.


NO PROBLEMS, CONTACT ME...
--
PACALA JAN [ACCESS DEVELOPER]
SEND 10$ TO...
ACCOUNT:
SK31 1100 0000 0026 1674 0428
SwiftCode: TATRSKBX
Tatra banka as,Hodzovo nam.3, 811 06 Bratislava
(e-mail address removed)
SKYPE: PACALA.BA1


Roger Bell said:
Is there a limit to the number of records hat can be stored in a data Base?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Watch out!! Arno R (the Rat) is creating a website Who Is Tina.
Click to expand...

Actually I suspect that Arno will join Tina and others in chiding Jan Pacala
for inappropriate advertising. Check your attributions.

John W. Vinson [MVP]
 
Over 133 million records in one .MDB file! These were junk records of no
value. It was just a test of how many records COULD be crammed into an Access
..mdb file within the 2GB limit.
 
Back
Top