I am by far no expert at this but I did a simple google discussion group
search and got a lot of interesting posts on this, so I'd suggest you do the
same.

However, 1 post did catch my attention.  take a look at:

http://groups.google.ca/group/microsoft.public.access/browse_thread/thread/b9f63
c55dc555255/871840505f39cf74

Daniel

Yes. You can use make table queries - one for each table. However, you will
need to consider the following:

1. Is the database entirely static? That is, do you want just a snapshot of
the database one time, or do you need to capture it periodically? If you
export the data to Access and then move it to a different computer, that
other computer will not receive newly-input or changed data until you do it
again.
2. Do you need to update records and return them to the Oracle DB?
3. If there are logical relationships amongst the table, you will need to
establish these after the make table queries are run.

When I need to capture data periodically, I run a make-table query one time
to establish the structure of the tables. I then set up the logical
relationships amongst the newly-created tables. Then, I set up a full set of
delete and append queries to flush the contents of those new tables and
append from the ODBC data source to the new tables. From a form, I can then
renew the data by simply calling both sets of queries to empty the Access
tables and repopulate them with current data. This way, I do not have to
recreate the tables and relationships every time I want to refresh the data.