BR><BR>I haven't really looked at Access lately, and haven't ever really used Oracle much. The last time I used Access I remember that dates needed to have '#' put around them to parse, while SQL ...

This was possible because the databases use the same names for tables and columns and there is a coherent type transformation between the data types of the columns in Oracle, SQL Server and Postgres.