多次登录到ms访问数据库 [英] Multiple login to ms access database

问题描述

大家好，



我使用.net，C＃和ms访问数据库创建了一个门户网站。

门户网站的要点是收集用户评论并在数据库中提交。

因此，当一个用户登录并开展业务时，一切顺利。



但是当多个用户同时使用门户网站时，也就是说尝试同时提交数据时，就会出现错误。



任何想法什么我可以对数据库做什么，以便它正确地接受用户的输入，或者如果有问题则根本不接受任何东西？可能有些东西需要阅读这个主题吗？



我第一次使用ms access数据库进行用户交互。我不知道如何访问数据库来处理多个用户压力。



谢谢。!!



我尝试了什么：



我可以要求用户在不同时间访问门户网站。但这是不可能的。

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.

推荐答案

不要尝试在多用户中使用Access - 你可以为很小的工作而逃脱它，但它只是一个用户数据库这真的不是为多用户访问而设计的，并且当你这样使用时总会给你带来巨大的悲伤。



相反，考虑SQL Server或MySQL - 它们都是多用户，如果您的代码写得很好，那么应该只是将您的类从OleDbConnection和OleDbCommand对象更改为SqlConnection和SqlCommand，或者更改为MySqlConnection和MySqlCommand对象。

然后安装相应的用户的中央服务器上的软件，添加数据库，并从您的应用程序连接到该服务器。

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.

这篇关于多次登录到ms访问数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！