multiuser - shared datbase

[Guest]

hi there..


i am trying a databae/ form to be opened by 40 users simultaneusly


but it is not working for more then 10 can some tell me y is that and what
is th e solutions.

every thing is by default no default setting haes beeen changed

 

[Allen Browne]

40 users is a heavy load for Access - if they are all modifying/adding
data - but it should work.

Did you split the database, so each user has their own copy of the front
end?
http://members.iinet.net.au/~allenbrowne/ser-01.html
That's crucial.

Did you check out the performance issues listed at:
http://www.granite.ab.ca/access/performancefaq.htm

 

[Guest]

brother, thanks for ur reply but i discovered that , windows XP sahred folder
cannot work on more than 10 users.. so it is useless to work on it, wat do u
say...pls tell me if u 've ne other idea

 

[Larry Linson]

I think you are talking about a Win XP peer-to-peer network. Earlier Windows
peer-to-peer networks were also limited. In both cases, the answer is to not
use peer-to-peer, but set up a client server network. With Win XP Pro on the
clients, and Win 2000 Server or Win 2003 Server, the users will log into a
domain on the Server, and you can have many more than 10 users for a shared
folder.

Larry Linson
Microsoft Access MVP

 

[Jorge Luis Savoini]

Hi. Im trying to solve a problem that is relationed but not the same with
the argument of this message. The cuestion is that I work with Access to
develop third tie in small works, but working with transactions from VB and
ADO, the concurrecy of more than 2 users in the same operation (new
registry, for example) not allow me to continue.
Exists some way to solve this?
Thanks

Jorge Luis Savoini
Argentina

 

[John]

Hi. Im trying to solve a problem that is relationed but not the same with
the argument of this message. The cuestion is that I work with Access to
develop third tie in small works, but working with transactions from VB and
ADO, the concurrecy of more than 2 users in the same operation (new
registry, for example) not allow me to continue.
Exists some way to solve this?
Thanks

Jorge Luis Savoini
Argentina


wat