Multi Users and Access DB - Newbie Question

  • Thread starter Thread starter MadCrazyNewbie
  • Start date Start date
M

MadCrazyNewbie

Hey Group,

I`ve build a VB.Net App which has a Access Database. This will be used by 4
people. Do i need to worry about putting Locks and things on it? If so
anybody suggest what i need to do, any links?

Ta
MCN
 
always worry about concurrency issues when using databases. Figureing out if
you need optimistic or pesimistic locking is best determined by looking at
the data and compareing that to who would be using it at the same time...
 
Hi MCN,

And in addition to Brian, see what procedures you create to overcome the
problems when you get conncurrency problems.

And as advice, search this newsgroup for William. Bill. Vaughn he is in in
my opinion in this newsgroup always telling the most true things about that.

Cor
 
¤ Hey Group,
¤
¤ I`ve build a VB.Net App which has a Access Database. This will be used by 4
¤ people. Do i need to worry about putting Locks and things on it? If so
¤ anybody suggest what i need to do, any links?
¤

If you're using Microsoft Access you will need to create your own concurrency mechanism. Although
Access supports two types of locking mechanisms ADO.NET only supports the optimistic (locking at the
time of update) mechanism.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top