Database Discussion - Help needed For Database

Print Page | Close Window

Help needed For Database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8417
Printed Date: 30 March 2026 at 1:57pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Help needed For Database

Posted By: dreamstrader
Subject: Help needed For Database
Date Posted: 30 December 2003 at 1:55am

can i use MS access .mdb file as my database for a huse amount of data(more than 100000 users)? please help

Replies:

Posted By: zaboss
Date Posted: 30 December 2003 at 7:35am

Nope...

Depending on your code, Access could safely handle maximum 200 simultaneous connection. But above 100 connection usually means trouble. You have to consider either MySQL or SQL Server db.

-------------
Cristian Banu
http://www.soft4web.ro - Soft 4 web

Posted By: Mart
Date Posted: 30 December 2003 at 7:41am

Hes not talking about the number of connections, hes talking about the number of records. Access might be able to hld 100000 records (but im not sure). even if it does it will be reeeeealy sloooooooow so your better off using SQL server.

Posted By: michael
Date Posted: 30 December 2003 at 11:29pm

Access is fine for a personal db with that many records. Not necessarily many users recommended but if you don't share the db you can easily store a couple million records.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker