Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How many records can a table hold?

Status
Not open for further replies.
shauns1

shauns1

Programmer
Oct 21, 2005
53
AU
Hi, does anyone know the limit to the number of records an Access table can hold? And at what point efficiency goes out the window?

I'm currently logging page views in a table and wondering if this is wise / the best way to do it??

Cheers

Shaun
 
Sort by date Sort by votes
hit F1, type in limitations, hit search, select access specifications...

--------------------
Procrastinate Now!
 
Upvote 0 Downvote
Yeah I did this but it doesn't tell me answers to the above questions.

Does this mean its 'unlimited'?!
 
Upvote 0 Downvote
The main limitation is the size of the .mdb (2Gb)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
822
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
515
Andrzejek
Andrzejek
C
  • Locked
  • Question
Query expression negative to a 0
Replies
6
Views
486
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
976
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top