Re: Updates to an Access Database

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kenny Young (Kenny_at_68gt.sytes.net)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 14:24:22 -0500

OK I have added the following and it still wont save data changes to the
database.

Private Sub cmdSave_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles cmdSave.Click

OleDbDataAdapter1.Update(DsDataSet1, "Variables")

DsDataSet1.Variables.AcceptChanges()

End Sub

"ajk pc.nu>" <gandalf<at> wrote in message
news:o1ma01l8k2bvokki3uschf8157h6rrji96@4ax.com...
> On Sat, 5 Feb 2005 09:10:58 -0500, "Kenny Young"
> <Kenny@68gt.sytes.net> wrote:
>
>> I am working on a program that access data from a MS Access database.
>> I have the Connector (OleDbConnection1), the Dataadapter
>> (OleDbDataAdapter1) and the DataSet (DsDataSet1) all in place. All the
>> text boxes DataBindings have been done. I use the following code to
>> populate the form:
>> Private Sub bFill_Click(ByVal sender As System.Object, ByVal e As
>> System.EventArgs) Handles bFill.Click
>> Me.DsDataSet1.Clear()
>> Me.OleDbDataAdapter1.Fill(Me.DsDataSet1)
>> End Sub
>> Now the problem. Changes to the data aren't being saved to the
>> database and no error is generated. I am using the following code:
>>
>> Private Sub cmdSave_Click(ByVal sender As System.Object, ByVal e As
>> System.EventArgs) Handles cmdSave.Click
>> OleDbDataAdapter1.Update(DsDataSet1)
>> End Sub
>>I have also tried the following to no avail:
>>OleDbDataAdapter1.Update(DsDataSet1, "Variables")
>>
>>Any help is greatly appreciated.
>>
>>Thanks
>>
>>Kenny Young
>
> have you done commit?
> --
> "Those are my principles. If you don't like them I have others."
> Groucho Marx.

Relevant Pages

  • Re: What is the name of the Language we are using & recommend book
    ... Can I have 2 sub forms in a form that are not sub forms of the other sub ... As for my process I am trying to create my Access Database in shells like ... QSL or Microsoft SQL Server Data Engine or what. ... language of queries, and the query design grid is just a tool to construct ...
    (microsoft.public.access.formscoding)
  • Re: Custom Login Screen
    ... Private Sub cmdLogin_Click ... On Error GoTo ErrorHandler ... You will need to enter your full path to the database file and MDW file in the appropriate places. ... Now make an MDE file from this MDB. ...
    (microsoft.public.access.security)
  • Re: Jeff C
    ... properly secure an Access database. ... Private Sub Form_Open ... Resume ExitPoint ... Dim db As DAO.Database ...
    (microsoft.public.access.formscoding)
  • Re: How to use a logon screen to log into a secured Database?
    ... > that appears with a secured database. ... >>On Error GoTo ErrorHandler ... >> Exit Sub ... Now make an MDE file ...
    (microsoft.public.access.security)
  • Re: linking databases
    ... Doug Steele, Microsoft Access MVP ... Sub chrCountry_AfterUpdatestring highlighted in yellow.The code as I ... I using the text box's [Event Procedure] After Update property on the ... The name of the column in the table in the 2nd database I want to ...
    (microsoft.public.access.externaldata)