table size limitations in access

[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,

 

[Douglas J. Steele]

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

 

[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,

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.

 

[Tony Toews]

A2000 and later can accommodate 2 GByte of data in any single mdb file
or ADP project.

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

 

[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?

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.

 

[AMC]

Thanks all

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.

 

[hjg]

Thanks all