Can't Determine Origin of DB Recordset Error

[Quehay]

I'm trying to create an appointment book type form that saves its entries to a db (this is a class project--otherwise I'd use the existing wheel and do it with Outlook!).<br><br>I have created a form (or rather had the Vis Data tools create it) that is Wizard-linked to an Access-type db.&nbsp;&nbsp;There is only one table in the db--it's the &quot;Day Appointments&quot; table.&nbsp;&nbsp;Within this table are fields for each of the half hour segments for which appt. entries are to be made/allowed.&nbsp;&nbsp;There are also fields for month / day / year.&nbsp;&nbsp;The primary key is specific date, derived from the form entries.&nbsp;&nbsp;When I enter some appts and try to save the record I get &quot;Error 3426: Another object cancelled the operation.&quot;&nbsp;&nbsp;There isn't much descriptive suggestion for causes (actually none at all) in the help, and I don't see what could be wrong--the wizard created the form based on the table and the Dataconnection tests &quot;OK.&quot;&nbsp;&nbsp;Could the problem be the empty strings in all of the fields for which there is no appt. entry?&nbsp;&nbsp;(These fields are set to allow zero length strings.)<br><br>Any insight into the problem or the most expeditious debugging course to take would be much appreciated.

 

[Guest_imported]

If you are using a DataControl (ie the old data control) that is the problem.&nbsp;&nbsp;I don't remember the &quot;technical&quot; reason for the error but the cause of it is the data control.&nbsp;&nbsp;I recommend coding the database using ADO.&nbsp;&nbsp;If you have questions, feel free to e-mail me at <A HREF="mailtoeteS@Bradfordsys.com">PeteS@Bradfordsys.com</A>