Working with Oracle and Access

[teferi2002]

Hi all,
Is it possible to work with two different database oracle which resides on the server and Access which resides on my loacal machine at the same time and be able create a report using Crystal report. I am using CR 10.0 oarcle 9i and Acess.
Thank you for the help.

 

[synapsevampire]

Sure, LINK (not import) the Oracle tables into yoru Access database, then build out a Access query based on whatever you need.

To link, under the tables section use New->Link and point ot your Oracle database, select the tables you want, and make sure that you click Save Password.

-k

 

[teferi2002]

Thanks k. Just out of curiousity what would happen if i forgot to click save password. thanks