OraFAQ Forum: Reports & Discoverer » Access connected to Oracle

Home » Developer & Programmer » Reports & Discoverer » Access connected to Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Access connected to Oracle [message #266179]

Mon, 10 September 2007 01:56

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?

Report message to a moderator

Re: Access connected to Oracle [message #266304 is a reply to message #266179]

Mon, 10 September 2007 07:47

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

Report message to a moderator

Re: Access connected to Oracle [message #266493 is a reply to message #266304]

Tue, 11 September 2007 00:41

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..

Report message to a moderator

Re: Access connected to Oracle [message #266772 is a reply to message #266493]

Tue, 11 September 2007 10:52

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

Report message to a moderator

Re: Access connected to Oracle [message #268563 is a reply to message #266772]

Wed, 19 September 2007 01:56

aslme
Messages: 26
Registered: May 2006
Location: Pakistan

Junior Member

See the Link for further

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

Thanks
Cheers

Report message to a moderator

Previous Topic:	Order by in a Group Matrix Report
Next Topic:	Reporting Tool Options

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 06:23:22 CDT 2024