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!
-
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!
Limit to number of records in an MS Access Database
- Thread starter kishore22
- Start date
Depends. It's 1 GB worth in 97, 2GB in 2k. You can't take this literally however, due to the way that Access writes to itself. I've found that after about 25,000 decent-sized records or about 400 mb of data you start to notice a real slow-down if the program doesn't outright crash. If your looking to process anything bigger, you might consider SQL Server 2k.
- Status
Similar threads
- Question
- Locked
- Question