| oracle with access [message #117765] |
Fri, 29 April 2005 08:56  |
anjanoracle
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.
Anjan
|
|
|
|
| Re: oracle with access [message #117891 is a reply to message #117765] |
Sat, 30 April 2005 16:40  |
 |
Maaher
Messages: 7065
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...
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
