I am new to VB. I am using ADO to access, add and update a SQL Server DB. I am running into trouble when I attempt to update non-Key fields on a form.
All the error tells me is Runtime Error '-2147217887(80040e21)' Errors occurred. I have my lockset to 3- adLockOptimistic.
Why is it doing this?
Hello,
I am new to VB. I am using Visual Studio and ADO Data Control to access a Table(Project) on an Access database. This works fine. I am attempting to use ADO DataList to access a different Table(Client) on the same database to create a dropdown list so the user can select which Client ID...
I have set up a display of an Access record. What I want to do now is, when I have to add a new record, is to read from another Access DB all the values in a certain column (via SQL) and put those values into the listbox. I am at a loss as to (1)how to do this and (2) still display the value of...
I am using MS Visual Studio to create a form and Load an MS Access DB. I have made all the connections and am able to access the DB. I created an Add button control. My problem is with the AddNew ADO Recordset.
****** Code *******
Private Sub Add_Click()
adcEmployee.Recordset.AddNew...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.