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, 200521 yr by alan8311

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.Update
rst.Close
set rst = Nothing