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

Maximum Rows of Record???

Status
Not open for further replies.
RookieDBO

RookieDBO

Technical User
Sep 20, 2001
83
CA
What's the maximum rows of records a table can hold in Access '97??? Also, how many megabytes your Access database can be??? In a Win98 platform.

Thanks,
RookieDBO
 
Sort by date Sort by votes
The limit is 2GB per Access MDB. There is'nt really a record limit except the 2Gb size. I've tested this and imported 7 million records into an Access table. Ashley L Rickards
SQL DBA
 
Upvote 0 Downvote
The maximum mdb size for Access 2000 is 2GB, however for A97 it's 1GB (according to Access 2000 Developer's Handbook; Getz, Litwin & Gilbert). I'm also not aware of any limitations on numbers of records and have also dealt with db's with records in the millions. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"
 
Upvote 0 Downvote
Thanks Ashley. Good to know.

Thanks
RookieDBO
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
580
JimStrand
JimStrand
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
884
serino
serino
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
293
Andrzejek
Andrzejek
supportsvc
  • Locked
  • Question
How to limit the number of records based on the quantity in a field? 1
Replies
8
Views
355
supportsvc
supportsvc
MattGreer
  • Locked
  • Question
Select the first maximum value from a set of data 1
Replies
10
Views
546
MattGreer
MattGreer

Part and Inventory Search

Sponsor

Back
Top