Multiple login to ms access database

Question

1.00/5 (1 vote)

See more:

Hi All,

I have made a portal using .net, C# and ms access database.
The point of the portal is to collect user review and submit it in a database.
So when a single user logs in and does his business, all go well.

But when multiple users are using the portal at the same time, that is to say trying to submit data at same time, there is error.

Any idea what can I do to the database so that it accepts the inputs of users properly or do not accept anything at all if there's a problem? May be something to read that throws light on this subject?

I am using ms access database for user interaction for first time. I have little idea how can access database handle multiple user stress.

Thank you.!!

What I have tried:

I can ask users to access portal at different times. But that is not possible.

Posted 12-Jun-17 0:08am

planetz

Updated 12-Jun-17 0:16am

Add a Solution

Comments

F-ES Sitecore 12-Jun-17 6:16am

Error messages usually give you a hint as to what the problem is but as you don't think the error message itself is relevant it's unlikely anyone can help you.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-06-12T00:16:00

Don't try to use Access in multiuser - you can get away with it for really small jobs, but it's a single user DB that really isn't designed for multiuser access and which always gives huge amounts of grief when you use as such.

Instead, consider SQL Server or MySQL - they are both multiuser, and if your code is well written, it should be just a case of changing your classes from OleDbConnection and OleDbCommand objects to SqlConnection and SqlCommand, or MySqlConnection and MySqlCommand objects instead.
You then install the appropriate software on a central server for the users, add your DB, and connect from your app to that server.