Follow up: Using Access+DBMS with >30 users

[Remco Groot Beumer]

Hello,

In regards to my previous posted mail on this topic: thanks for the
feedback. The 30% is told to me by a collegea. .NET is not my working area,
but it's something our company provides. So i'm just looking for our
options.

Besides the 30% more work issue I'm mostly interested in the possibility of
an Access versus DBMS (SQL server) and how this will work with 40 users
(front end locally on each client). Another question that comes to mind:
which DBMS to prefer. We have some experience with SQL server and iAnywhere
from Sybase. Since a short while we are looking at Oracle.

Thanks again for all your replies.

Greetings,

Remco GB

[David Schofield]

On Sat, 9 Apr 2005 18:03:50 +0200, "Remco Groot Beumer"
<no****@nospam. com> wrote:

Hello,

In regards to my previous posted mail on this topic: thanks for the
feedback. The 30% is told to me by a collegea. .NET is not my working area,
but it's something our company provides. So i'm just looking for our
options.

Besides the 30% more work issue I'm mostly interested in the possibility of
an Access versus DBMS (SQL server) and how this will work with 40 users
(front end locally on each client). Another question that comes to mind:
which DBMS to prefer. We have some experience with SQL server and iAnywhere
from Sybase. Since a short while we are looking at Oracle.

Thanks again for all your replies.

Greetings,

Remco GB

Hi
I'm not sure anyone has actually answered your original question.
I have added why I think this to the original thread.
David

[Larry Linson]

"Remco Groot Beumer" wrote

Besides the 30% more work issue
I'm mostly interested in the possibility of
an Access versus DBMS (SQL server)
and how this will work with 40 users
(front end locally on each client). Another
question that comes to mind: which DBMS
to prefer. We have some experience with
SQL server and iAnywhere from Sybase.
Since a short while we are looking at Oracle.

I have some introductory presentations on both Access in a multiuser
environment and on Access as a client to server DBs -- you will find them at
http://appdevissues.tripod.com in the downloads section.

SQL Server (the free MSDE desktop for production small user audiences with
SQL Server Developer Edition to have the very useful administrative tools as
you create the DB structure or the server version) is relatively easy to
administer.

I used Access 2.0 as a client to the older SQL Anywhere from Sybase and
found it easy -- it was not a production environment and I was not
'administering' it, but it was a snap to convert to using the actual
production database, Informix. Frankly, unless your company already has
Oracle installed, and has very helpful database administrators, I'd not
consider it for 30, or even 60 users.

Larry Linson
Microsoft Access MVP