Hi, I have an Access DB that was created in MS Access 2003. It has several tables in it. Then the DB was opened in MS Access 2002 and 3 tables were added to it. When I run my CF code on my local machine (MX 7, Access Driver version 4.0) I have no problem running my queries. When I run my CF code on my host's machine, SOMETIMES I get the below error, NOT ALWAYS, but only when querying one of the 3 tables that were added in MS Access 2002. The host is also running MX 7 and Access Driver version 4.0.
Does anyone know what's going on? Here is the error: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. The SQL is just plain SELECT statement, nothing fancy. Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247073 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
