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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Quick Question....

Status
Not open for further replies.
Denz

Denz

Technical User
Oct 29, 2001
33
GB
What's the (theoretical) Maximun size of a table, whether it be in MB or records??

Cheers

Dave Denning
 
Sort by date Sort by votes
1 gig. This is the max db size for Access 97, I'm not sure about 2000.
--Jim
 
Upvote 0 Downvote

Access 2000 max size is 2GB also. The max size of the largest table will be smaller than this due to overhead, system tables, and other objects. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

teach314
  • Locked
  • Question
question re Description in Table Design 1
Replies
2
Views
131
teach314
teach314
Charliy
  • Locked
  • Question
101 Question
Replies
3
Views
111
Charliy
Charliy
teach314
  • Locked
  • Question
Question about Relationships Window 2
Replies
3
Views
112
teach314
teach314
Lhuffst
  • Locked
  • Question
have normalization questions and need help 2
Replies
9
Views
134
Andrzejek
Andrzejek
VickyC
  • Locked
  • Question
A question re importing tables 1
Replies
6
Views
124
VickyC
VickyC

Part and Inventory Search

Sponsor

Back
Top