Just in case this might help someone else .....
The error (at least in this case) was caused by a column name in the Access Table. The column name was an Access reserved word. Once the name was changed the code worked fine.
Thanks to Stephen Wolfe in the profox mailing list for the heads up on this error.
Hope this helps someone!
Tom Gahagan
Alliance
Computer Solutions
"Music, like sex, is much too important to be left to professionals."
Robert Shaw