table size limitations in access

A

AMC

Hi,

I have a website with an access database. Users enter their name and email
address on the web page and it writes this to the database. My question is
how many of these records can access store in a table before the amount of
data gets too large for access to handle efficiently?

Thanks,
 
D

Douglas J. Steele

Access 2000 and newer can hold 2 GB/MDB file. Access 2, 95 and 97 can hold 1
GB/MDB file.
 
J

John Vinson

Hi,

I have a website with an access database. Users enter their name and email
address on the web page and it writes this to the database. My question is
how many of these records can access store in a table before the amount of
data gets too large for access to handle efficiently?

Thanks,
Click to expand...

A2000 and later can accommodate 2 GByte of data in any single mdb file
or ADP project. Note that you can have multiple backends to get around
this limit, with some complications.

In practice, if you have over 10,000,000 records in your largest table
you should start looking seriously at SQL/Server or another true
client/server database.
 
T

Tony Toews

John Vinson said:
A2000 and later can accommodate 2 GByte of data in any single mdb file
or ADP project.
Click to expand...

Eh? Wouldn't the 2 GB limit for an ADP depend on whether the ADP is
pointing to MSDE or SQL Server? Which would be the same for an MDB
anyhow?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
J

John Vinson

Eh? Wouldn't the 2 GB limit for an ADP depend on whether the ADP is
pointing to MSDE or SQL Server? Which would be the same for an MDB
anyhow?
Click to expand...

YOu're right, of course, Tony; an ADP with a SQL Server backend would
be limited only by the (mindbogglingly huge) limits of SQL. I was
thinking of the limitation on a MSDE database.
 
A

AMC

Thanks all
John Vinson said:
YOu're right, of course, Tony; an ADP with a SQL Server backend would
be limited only by the (mindbogglingly huge) limits of SQL. I was
thinking of the limitation on a MSDE database.
Click to expand...
 
Top