SQL-Server Vs. MS-ACCESS

Hi All!
I am currently in design part of a client-server application. I am confused for the database part. If I use Sql-server then the user would have to install sql-server on his Server... That's not a problem., The big problem is He would require an admin for Sql-Server.

The solution that comes to my mind is Ms-Access . But I don't know how robust Ms-Access is in a client-server environment ., and how many simultaneous connections does it support in such a case . I am looking for as many as 100 users at a time.

Please Help

Thanks in Advance
-Ankur

[Leandro Avelar]

Hi,

You´re crazy to use access with 100 connections, it will put your network down!
You must have to use a SQL-Server in you Database Server, but the clients don´t need to have a SQL-Client, when you program with VB you have all the necessary commands to access the SQL-Database using ODBC, it comes with VB and can be generated setup disks with all necessary files to install in the clients.

You will need a Person prepared to work with SQL-Server , he will give the password, manage the database, include triggers to don´t allow some kinds of access and much more.

If you need i´m always atempt to answer any question.

Leandro de Avelar
System Engineer
National Institut of Telecommunications

MS Access only supports up to 15 concurrent connections. Anymore than that and you're in trouble. Go with SQL server

MSDE is the way to go.
It is free and you can distribute your solution pretty much like you do with MS Access. You'll have to write little routine, which will attach your files to MSDE database. Ask me how I can help. Thanks.

I looked into the same thing I am having problems with SQL server ODBC connections with VBscipt. Does anyone know how much slower it would run if i used an Access database as a passthrough for the SQL server. I know that it doesn't make much sense, but I have had trouble opening a ODBC connection through VBscript