Multiple User Access Database in MS Access

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Tunacao_Caaron1
Answered By 10 points N/A #92820

Multiple User Access Database in MS Access

qa-featured

Access Database 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. 

Best Answer
Best Answer
Answered By 20 points N/A #92821

Multiple User Access Database in MS Access

qa-featured

Hey Ljones!

Basically it all depends on three things:

  1. Your Network
  2. File Servers
  3. Workload

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

Related Questions