0

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?

sav
  • 11
  • 4
  • Possible duplicate of http://stackoverflow.com/questions/5646793/maximum-concurrent-connections-in-ms-access – Naseer Jan 03 '17 at 14:04

1 Answers1

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.

Tim Cadenbach
  • 26
  • 1
  • I'm aware of that. Do you know any good guide/tutorial for making a queue for this purpose? – sav Jan 03 '17 at 14:59