Link to home
Start Free TrialLog in
Avatar of Taras
TarasFlag for Canada

asked on

vb.net copy always and Do not Copy

I am learning vb.net basic steps and working now on optimistic concurrency with MS access database and datagridview.
I want to see changes- updates of record in my database and I want to arrange situation that will give me concurrent violation. I want to be sure for testing this issue do I need to set up my MS Access database as: Do not copy? If somebody can elaborate this a little a bit.
Avatar of Taras
Taras
Flag of Canada image

ASKER

I do not know what is happening here in VB.net area after New Year. Before in MS Access and VBA area I had always prompt response to my question with several options.
Here in VB.Net it is completely different response not sure what is changed. I am subscribed  user to e.e. over 15 years  and I am not willing to pay for simple issues during learning process. I thing that I am awarding enough points for those questions.
 If Experts exchanges site going in that direction it is wrong approach.
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Taras

ASKER

Pat, I am creating application in vb.net  I agreed with your comments regarding this question not connected with  MS Access and VBA.
I made mistake not stressing that out first and putting MS Access behind vb.Net as area  to which this question is related to.
 I am only using ms access as local database file that is only connection with MS Access everything  else here is pure Vb.Net programming .
I was misled with my experience in posting question in MS Access VBA area. And how fast and good answers I was getting before  there , I was expecting that that will happened again in vb.net.
Even I mentioned MS Access in question, this is Vb.Net question and I am surprised that no  answer is posted or tried for this question  from vb.net developers or persons that are experts in vb.net area.  I agree with you, I should remove MS access from question and leave only vb.net area.
Pat I am learning vb.net and creating this simple vb.net application with one form, one datagridview and one  MS Access database file with one table  as local database. I am trying to test optimistic concurrency with update of database table record.
There is not another user or another application that accessing database table at the same time I am the only user.
The point is that developers who use Jet/ACE rarely even know what the word "concurrency" means let alone how to test it.  You would have better success if you were using SQL Server Express (free).  

Concurrency implies multiple users/operations.  How are you thinking to test this without having two active users?
Avatar of Taras

ASKER

Hi Pat, similar how you test and induce "write error" in ms access.
But that is not question here. I already edited question and moved it in vb.net area. I am still expecting somebody to respond on question.