Access to Oracle

[Karen]

I have an Access 97 database that my user's are presently
using. I am in the process of developing their current
application (which was developed in Access using forms,
etc) to a PeopleSoft application with an Oracle database.
How can I link my production database (Access 97) to my
development database (Oracle) to have the same data. I
want to populate the Oracle database so that I have real
data to test with.

Thanks!

 

[Albert D. Kallal]

How can I link my production database (Access 97) to my
development database (Oracle) to have the same data. I
want to populate the Oracle database so that I have real
data to test with.

You mean you want to import the data from oracle for now...but eventually
you will connect to that data?

You first need to install the odbc drivers on your pc for oracle. Once this
is done..you can then use ms-access to edit, and work with data from the
oracle system.

You should probably get the admin of the database system to setup a DSN for
you.. You can then use the linked table manager in ms-access to link to that
database. In stated of choosing a table in your back end mdb file you
choose a odbc link (You are running a split mde/mdb file...right?)

So, for importing some test data......you can then run a series of append
queries to grab data from the oracle db.