Multiple User Access Database in MS Access

Asked By ljones 0 points N/A Posted on - 03/25/2012

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?

• Status: Open
• Question Views: 1250
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Tunacao_Caaron1

Go To Solution

Answered By sana sabir 10 points N/A #92820

Multiple User Access Database in MS Access

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. 

About sana sabir

Questions
1

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 03/25/2012
• Question Category: MS Access

Best Answer

Best Answer

Answered By Tunacao_Caaron1 20 points N/A #92821

Multiple User Access Database in MS Access

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

About Tunacao_Caaron1

Questions
1

Answers
399

Best Answers
138

• Vote Up 0 Vote Down

• Posted on - 03/25/2012
• Question Category: MS Access