Allow many user access a single database simultaneously without locking

Question

Using ASP.NET (WebForm), how do I avoid MS Access to lock when more than one user trying to access it at same time? I know MS Access is not optimal for for that purpose but whats the way around it? I assume I've to make some sort of queue, but how?

Possible duplicate of stackoverflow.com/questions/5646793/… — Edison
– Edison, Commented Jan 3, 2017 at 14:04

Tim Cadenbach · Accepted Answer · 2017-01-03 14:11:08Z

1

MS Access is definitely not optimal for that.

Not sure what you´re trying to do exactly but MS Access is locking a file if its opened multiple times from different users. You´d need to make sure that the system user accessing the file is always the same (eg your IIS User maybe) or write a small wrapper that handles the access.

You´d still be only able to do one request at a time so yes you´d need a queue to make that work.

However i´d strongly suggest using SQL for that, maybe try SQL Express as its free and its way easier to use on top.

answered Jan 3, 2017 at 14:11

Tim Cadenbach

261 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

sav Over a year ago

I'm aware of that. Do you know any good guide/tutorial for making a queue for this purpose?

Collectives™ on Stack Overflow

Allow many user access a single database simultaneously without locking

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related