Is there a particular limit to how much info can be stored in an MS Access database or table?<BR><BR>Is there a reason why some ASP programmers use mySQL or SQL over MS Access?<BR><BR>Thanks!<BR><BR>
Check the HELP in your copy of Access.<BR><BR>Look for "Access Specifications".<BR><BR>Performance with multiple users--especially multiple writers--is the biggest bottleneck with Access. Though nowadays 2GB limit might be another reason.<BR><BR>
I've heard about the 2G limit as well. Somewhere along the way, I heard that Access only allows 35 concurrent sessions. Can't quote the source, though.