Cannot update MS Access database

[Musab]

Hi all,

Can anyone please help me with this problem,

I am practicing on a students database, I can insert values and update while the Form is running, but when I close it and re-debug it or re-run it, the values do not appear and the db is unchanged !!

First I thought that its something with my code, I used the datagridview controller thinking it will provide me with what I'm missing but it acted the same.

Any help how to save my changes to the database after exiting.

Thank u !

 

[JohnH]

That sounds like what cjard is talking about in FAQ: "My database isnt saving changes" or "Changes are gone when I restart the app"

 

[Musab]

That sounds like what cjard is talking about in FAQ: "My database isnt saving changes" or "Changes are gone when I restart the app"

Oops... I'm sorry for repeating the question I didn't see this article !

Should I continue with my questions in this thread ? if so,

I used the old way of writing the code (Dim cn as Oledbconnection..etc) manually to update and it got updated it, but not right away. That means its doing the opposite now, updates but after closing and reopening.

Any idea to update it on the fly while the form is open?

thanks.

 

[JohnH]

That sounds as a problem with the manual binding. You may give some more information/code and somebody may help you, creating a new thread about this topic is appropriate as it doesn't relate to the building process you had problem with first.