Microsoft Access

Tricks and Tips for Microsoft Access

using

cmd.Parameters.Append cmd.CreateParameter("@dtDate", adDate, adParamInput, 0, "11/13/2008")

it would return this error:

"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

Fix by using adDBTimeStamp

Published Nov 14 2008, 12:56 PM by steve gray

Thanks. This corrected a problem when migratiing an Access 2000 application to Access 2007 with a SQL 2008 Express R2 migrated database.

Cheers!

SQL field is DateTime, but adDate only read Date part.

adDate worked ok in past in Access 2000/ SQL 2000 aps, but when used on new platform time part truncated.

Changing adDate to adDBTimeStamp did the trick!

July 5, 2010 11:00 AM

Name (required)

Your URL (optional)

Comments (required)

Remember Me?

Add