Home » Other » General » oracle with access
oracle with access [message #117765] Fri, 29 April 2005 08:56 Go to next message
Messages: 1
Registered: April 2005
Location: Delhi
Junior Member
I have a database in the msaccess. I want to bridge this with oracle9i. Though i have already made the link the problem is that the access table automatically update after half hourbut when i want to update the oracle table then every time i have to make the sql command. is there any procedure which will automtically update the oracle table from the data of access table.

Re: oracle with access [message #117891 is a reply to message #117765] Sat, 30 April 2005 16:40 Go to previous message
Messages: 7064
Registered: December 2001
Senior Member
As Oracle is accessible from Access through an ODBC driver, I'd say you can automate the process. But IMO it's better to ask this at a MS Access forum. It's in fact the Access database that has to perform the update ( on another ODBC datasource, i.e. Oracle).

Just a thought, I've never done this myself...

Previous Topic: accesing to a DMZ
Next Topic: varchar and varchar2
Goto Forum:

Current Time: Sun May 28 15:36:48 CDT 2023