Click to See Complete Forum and Search --> : access database & multi-users


ppl1
January 14th, 2006, 06:35 AM
i need to choose a database for an application which is going to be used for some users and im wondering is access is good for somthing like 30 users simultaneously?
thanks in advanced.

hspc
January 14th, 2006, 07:08 AM
No
docimentation says that MS Access can accept about 250 simultaneous connections
but actually 5-10 users are very enough for it.
you can check other free alternatives like MySQL,MSDE 2000(desktop database from microsoft based on SQL Server),or MS SQL Server 2005 Express edition.

ppl1
January 14th, 2006, 12:03 PM
SQL SERVER is free?

hspc
January 14th, 2006, 12:39 PM
No.
Only MSDE and its replacement Express edition (http://www.microsoft.com/sql/editions/express/default.mspx) are free.

ppl1
January 14th, 2006, 12:55 PM
ok thanks