I am able to read from access database with no issue, but while writing to it, it never writes anything to the file. Following is the code i have been trying. I am using ucanaccess driver to connect to the access database.
databaseConnection = “DBaccess_1”
system.db.runPrepUpdate(“UPDATE tblSTs SET TargetBin=? where ID=?”,[value,id],databaseConnection)
After running this code and then using database query browser, it shows the respective change, but when i open the mdb file, there is no change at all and after opening mdb file from ms access and then querying it from database query browser it will show no change.