Home » SQL & PL/SQL » SQL & PL/SQL » MDB File Trigger
MDB File Trigger [message #414482] Wed, 22 July 2009 05:58 Go to next message
Messages: 44
Registered: April 2006
Hi All,

I have created a link of *.mdb (Microsoft Access File) with oracle 9i database with the help of ODBC connectivity.

Problem is i can not track any changes made in *.mdb file table.

Is their any option to track any changes like insertion, updation or deletion made in *.mdb file table.

Best Regards,

Khurram Kazmi
Re: MDB File Trigger [message #414500 is a reply to message #414482] Wed, 22 July 2009 06:31 Go to previous messageGo to next message
Michel Cadot
Messages: 63941
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Re: MDB File Trigger [message #492857 is a reply to message #414482] Thu, 03 February 2011 01:46 Go to previous messageGo to next message
Messages: 2
Registered: February 2011
Location: Dubai
Junior Member

I have seen your message, you have mentioned, you are able to connect MS-Access database from Oracle.

I am currently using Oracle version, in a single PC (test server) and MS-Access in it. I was trying to use the logic of HS ODBC, but when i try to select the table from the MS-Access i am getting the following error.
"ORA-12154: TNS:could not resolve the connect identifier specified".

Could you please provide me the steps what you have followed from beginning related to the connectivity between the Oracle & MS-ACCESS. so it will be very much helpful for me.


Thanks & Regards,
Re: MDB File Trigger [message #492860 is a reply to message #492857] Thu, 03 February 2011 01:52 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check this discussion, especially Maaher's message.
Previous Topic: Select NULL using REGEXP_SUBSTR
Next Topic: Group By Count and Date Time Range
Goto Forum:

Current Time: Fri Oct 28 01:52:36 CDT 2016

Total time taken to generate the page: 0.24459 seconds