alan8311 Posted June 13, 2005 Share Posted June 13, 2005 (edited) hi everyone, im creating my school project(bookstore system) using vb6 and MS access... i entered the data using add member form. After saved, the new created data can be display but after exit the program and login again, the data will automatically disappear..... then i ask my friend.. they said need to close the database...so can anyone tell me how and where to add the close database command??? please... Edited June 13, 2005 by alan8311 Link to comment Share on other sites More sharing options...
jdoe Posted June 16, 2005 Share Posted June 16, 2005 Are you using DAO recordset ?If so, after adding data, you need to update the recordset and then close it.If you don't update, the new data will be lost.The end of Access table edits should look like this...rst.Updaterst.Closeset rst = Nothing Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now