Working with Access DataBase
I am using access as DB for my application, I know Access has the issue when more then 1 user try to update or insert the record into the DB at same point.
Just wanted to know, in this scenario how should I go. I have no other choice then using Access DB. Can I check if the DB is locked wait for some time and then try attempting like things.If yes pls l开发者_开发百科et me know how to do that.
I am using ASP.net c#
I am afraid your information is incorrect. There is no problem with multiple users when the database is properly set-up. You may wish to consider something other than Jet/ACE if you have more than 30 users regularly updating data.
Access or more correctly JET does not have an issue with more than 1 user editing a DB, it would not be much of a database product if it did! You do however have to be careful not to lock things longer than you should or put too much strain on it however for many smaller applications it is an excellent choice. I have personally had JET backed applications handle a user base of about 30 active users with no problems
精彩评论