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 11:08 AM by activa

comments

TBPrince wrote Sep 22, 2007 at 11:36 PM

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 11:00 AM

wrote Feb 23, 2008 at 11:08 AM

wrote Feb 13, 2013 at 5:44 PM

wrote May 15, 2013 at 11:27 PM