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!