rableach
10-13-2000, 10:26 PM
I am writing a small App that uses an Access 2000 database.
I use the Database Object with a Data Control to link the form's fields to the recordset. This works great for simple browsing of the database. When I tried to get clever and add in some functionality to Add new records, Delete records and Change existing records, I used Native SQL and the Database.Execute function. These work well too. However, occasionally I get errors saying that the record is locked. I close the base recordset before every Add/Change/Delete on the Database and reload it after the operation. I could not find any mention of a Commit in MS SQL or the Database object. Any suggestions ?
I use the Database Object with a Data Control to link the form's fields to the recordset. This works great for simple browsing of the database. When I tried to get clever and add in some functionality to Add new records, Delete records and Change existing records, I used Native SQL and the Database.Execute function. These work well too. However, occasionally I get errors saying that the record is locked. I close the base recordset before every Add/Change/Delete on the Database and reload it after the operation. I could not find any mention of a Commit in MS SQL or the Database object. Any suggestions ?