Theres a loop which updates records in the databasde based on values from another database.
Set dbHQ = DBEngine.OpenDatabase(CurrentDb.Name)
Set rsHQ = dbHQ.OpenRecordset("<the table to be updated>", dbOpenDynaset)
rsHQ.fields(blahblahblah).value = "the new value"
The problem is;
when I step through the code it all works OK. The new value is put into the HQ database, but when I close the database and open it again the new values are not there. Its like a commit is not being performed. Is there such a thing in DAO? How do I 'commit' those records? Do I need to set the recordset or db to nothing and/or close the db /recordset?