Site Search:
Sign in | Join | Help

This Blog

Syndication

Tags

No tags have been created or used yet.

Microsoft Access

Tricks and Tips for Microsoft Access

VBA ADODB Frequent Error with adDate or adDBdate parameter

using  

[code language=’vb’]

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

[/code]

 

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

Comments

No Comments

Leave a Comment

(required)  
(optional)
(required)  
Add

About Steve Gray

Steve is a seasoned (translate: old) developer in VB and ASP.NET. He spends most of his time in Dynamics GP, writing custom mods for consulting firms. Crystal reports, eConnect, VS Tools for Dynamics... anything that comes along.