Taras
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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?
Concurrency implies multiple users/operations. How are you thinking to test this without having two active users?
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.
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.
ASKER
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.