Home » Developer & Programmer » Reports & Discoverer » Access connected to Oracle
icon7.gif  Access connected to Oracle [message #266179] Mon, 10 September 2007 01:56 Go to next message
graceqt
Messages: 2
Registered: September 2007
Junior Member

hi guys,

i'm new here i just want to know whom of you knows how to create access reports?

I already have tables but those tables are in Oracle as stored procedure.. but my boss wants me to create access reports.. how can I get all the tables that i need in access from oracle database?
Re: Access connected to Oracle [message #266304 is a reply to message #266179] Mon, 10 September 2007 07:47 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

Create the Link Tables in Access using ODBC Connection.
After that you can treat them as access tables.

Cheers
Soumen
Re: Access connected to Oracle [message #266493 is a reply to message #266304] Tue, 11 September 2007 00:41 Go to previous messageGo to next message
graceqt
Messages: 2
Registered: September 2007
Junior Member

you mean I still need to create tables in access even if I already have an existing one in oracle?

by the way are you also familiar with Fpspr70.ocx fpspru70.ocx ?

I need Fpspr70.ocx fpspru70.ocx to connect my access to vb.net but i already tried to run Fpspr70.ocx fpspru70.ocx to C:\WINDOWS\SYSTEM32 but it has error..


thank you for the reply .. i'll try to do the linking..
Re: Access connected to Oracle [message #266772 is a reply to message #266493] Tue, 11 September 2007 10:52 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

I am not telling you to create a table but to create a link table which will link with the original oracle table...Just a prototype of view in oracle which not store data in Access but you can do the operations(insert/update/delete) using access.

No I am not familiar with Fpspr70.ocx fpspru70.ocx as I didnot work on VB or VB.net yet.

Cheers
Soumen
Re: Access connected to Oracle [message #268563 is a reply to message #266772] Wed, 19 September 2007 01:56 Go to previous message
aslme
Messages: 25
Registered: May 2006
Location: Pakistan
Junior Member

See the Link for further

http://www.databasejournal.com/features/oracle/article.php/3358411


Thanks
Cheers
Previous Topic: Order by in a Group Matrix Report
Next Topic: Reporting Tool Options
Goto Forum:
  


Current Time: Sun Dec 11 02:04:58 CST 2016

Total time taken to generate the page: 0.10729 seconds