HOW MANY USERS ACCEP ACCESS 2003

[Guest]

I want to make an application in Access 2003 with will be accesed by 20-30
users.
I created an application data.mdb that contains tables, on a server with
Win 2000 server
I created an aplication named client.mdb and i copy this on 20-30 computers
with win xp
Client.mdb use for acces data.mdb:
c.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;.... and
c.execute " insert into or c.execute "update.. or c.execute"select...
How many users, through client.mdb, can use simultanous:
c.open or
c.execute"insert.. or c.execute"update... or c.execute"select

 

[Albert D.Kallal]

You should likey distroet a mde front end to eahc user....

c.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;.... and

There is a built in connection oboect you can use...no need to build your
own...

currentproject.Connection.Execute "update tblCustomers set ...bla bal
bal....

How many users, through client.mdb, can use simultanous:
c.open or
c.execute"insert.. or c.execute"update... or c.execute"select

In theory, the max number is 255 users. In practice, your 30 users is
ceranly a high number.....

 

[Larry Linson]

You should likey distroet a mde front end to eahc user....

I thought he indicated that he did distribute the front end to each user. It
doesn't _have_ to be an mde.

In theory, the max number is 255 users. In practice,
your 30 users is ceranly a high number.....

Unless something has changed, drasticall, for the worse in Access 2003, 30
is a pretty run of the mill number of users for a multiuser database, not
"high", in my experience.

Larry Linson
Microsoft Access MVP

 

[Albert D.Kallal]

Unless something has changed, drasticall, for the worse in Access 2003, 30

is a pretty run of the mill number of users for a multiuser database, not
"high", in my experience.

Larry Linson
Microsoft Access MVP

Ok!!!. I always considered 30 users a good number. I would say that 30
users is not really too high..but at least a "medium" to high number.

I will say that from a performance point of view, 30 users is well within
ms-access ability as a file share. However, when those numbers of users
appear, I usually conceded it is time for a server based system. This is due
to other issues then that of just performance. Perhaps I was not clear on
the above. I still do think that 30 users in a file share for ms-access is a
high number...but certainly do-able. In fact, Microsoft's own white paper
rated JET for 50 users!! (before they started selling sql server!! )

In way, it is rather impressive that you don't consider 30 users a high
number.

I suppose in way this shows that your aptitude for access is certainly first
rate.....