add, save, and delete buttons do not work well with an sql databse

[miscluce]

I have a form that is bound to an sql database but when I use the add, save, and delete buttons with the macros that the wizard programs for you.

For some reason it doesn't update my sql server, it only updates my form controls on the front end app. e

even when I hit refresh or close and reopen the database it doesn't do anything to the sql database.

does anybody know why this is? I am using access 2007?

 

[PHV]

Are you sure the tables are properly linked to the sql database ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[miscluce]

I used the wizard access has and I filled in the control source for each txtbox plus the form's record source is linked to the table.
I dont know?

I am working on a small program right now and I am writing VB code for this to see if I can take a new approach to this.

 

[JoeAtWork]

So if you make a change on the form, close the form, and reopen it, do you see your change? If so, it must mean it got saved to some database, not necessarily the one you think.

And how are you checking on the SQL side? Are you re-running the query after you changed the data through Access?