I am new to MS Access and wanted help. I am developing a windows based application in C#.net with Ms Access 2003 as a backend. The Ms Access Database will stored on a network path in a server. Can multiple user access Database on the same time. Can any one suggest me to achieve the multi user part?
- Login or Signup Now to post comments
Access Data base can only provide access 255 users at the same time.
But the reality of working with an access database is performance goes down when 20-30 users make requests, that means Access database is suitable for small application, there is more efficient database software available like SQL or MySQL.
Hey Ljones!
Basically it all depends on three things:
These three things will better decide that you can serve how many actual No. of users. Here i would like to inform you that if the numbers of actual users is less than 20, then it is totally no normal. There will be no problem occurrence if your number of users is less than 20.
Secondly, the achievement of multi-part user also depends on further requirements. The major requirement is User Management on which the achievement of multi-part user can be depend.
I hope you understand it.
Thanks