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

I Should know this.....

Status
Not open for further replies.
Lorimare

Lorimare

MIS
Dec 9, 2003
24
0
0
US
Easy question, what is the row limit for a table in access? Say I was running a make table query, what is the maximum number of rows a table in access supports.
 
Sort by date Sort by votes
No specific row limit. There is, however, a size limit for an entire database:
Access 97: 1GB
Access 2000+: 2GB


So as long as you're under those limits, you'll be fine. Performance does degrade a lot if you start 'scraping the ceiling' around the size limits.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Trob70
  • Locked
  • Question
There is no object in this control 1
Replies
9
Views
180
Trob70
Trob70
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
191
TheresAlwaysAWay
TheresAlwaysAWay
pankajunk
  • Locked
  • Question
I want to set up a simple meeting b
Replies
2
Views
75
lameid
lameid
MikeRei
  • Locked
  • Question
Help taking horizontal data and displaying it vertically (continuously)
2
Replies
27
Views
339
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
157
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top