ORACLE table to Access

[sdg8481]

Hi,

I have an MS Access database that is fed off about 30 linked ODBC ORACLE
tables, however the machine that this is stored on is just a stand-alone PC,
that can not be networked.

What i ned to do is somehow copy the data into standard Access tables that
can then be placed on the network, is there any quick and easy method this
can be done???

Might initial thoughts was to create a maketable query for each linked table
and then transfer these across on a Cd or flashdrive, but was just wondering
if theres any quicker, safer and more effiecient method

Thanks in advance

 

[Daniel]

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/micro...read/thread/b9f63c55dc555255/871840505f39cf74

Daniel

 

[Brian]

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.