1

Closed

Unable to save objects to Access database (changeset 8959)

description

I have a problem saving objects to an Access (2007, but it also happens to Access 2000) database. Save() operation fails (returns false) but no error occurrs. To be sure I wasn't doing something wrong, I tried to leave some required fields empty and I positively got an error stating such fields were required. So the Save() attempt happens, but when all fields are valid, Save() just fails.
 
Same code works for SQL Server and SQLite so I believe this is something related to Access support.
 
Hope this helps.
Closed Feb 23, 2008 at 12:08 PM by activa

comments

TBPrince wrote Sep 23, 2007 at 12:36 AM

Did some testing and found out that everything works if primary key for table is a counter (autonumber) field. Any other type of field used as primary key will make Save() fail.

Hope this helps.

wrote Feb 23, 2008 at 12:00 PM

wrote Feb 23, 2008 at 12:08 PM

wrote Feb 13, 2013 at 6:44 PM

wrote May 16, 2013 at 12:27 AM