Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle and Microsoft access
I don't want to buy any other technologies and or drivers because that requires me to get the files to the clients. (NO THANKS). I was really thinking about a trigger in Oracle on the V$Session table, but I tried that and it said I couldn't create a trigger on a view. Essentially, I was hoping that when someone creates an oracle session with MSACCESS.EXE has the program name I would capture that somehow.
Thanks for a reply-
On Mon, 03 Apr 2000 01:11:07 GMT, dyork_at_houston.rr.com wrote:
>Yes this is quite easy and I have a corporate application that does
>just this.
>
>First, you link a table through access to oracle (get external data ->
>linked table -> pick ODBC as file type and select an ORACLE dsn).
>
>The table should appear in your access database. If you double click
>on it you will have to login to oracle and the you can see the data.
>
>Finally, open a connection to jet using the correct oracle ids and you
>can do selects and updates just like straight to oracle.
>
>
>On Fri, 17 Mar 2000 12:30:54 -0500, Pierre Pavlenyi
><pavlenyi_at_ca.ibm.com> wrote:
>
>>Let me rephrase my question:
>>
>>I want to know if I can update the contents of a table in an Oracle database with
>>the contents of a MS Access database using ODBC. i.e. MSAccess writes to Oracle.
>>The table in Oracle already exists, and I _do not_ want to recreate it. I only want
>>to repopulate it with the data from the MS Access table.
>>
>
>
>
Received on Sat Apr 15 2000 - 00:00:00 CDT