in reply to Inserting records in MS Access
I may be wrong, but I recall that there's some difference in the string quoting between Oracle and Access. IIRC, Oracle uses single quotes, as in your code snippet, but Access uses double quotes.