Insert a record into Oracle DB via Access's Event Procedure

From: Karen <chan_at_icr.ac.uk>
Date: 28 Nov 2002 07:25:03 -0800
Message-ID: <13a0319e.0211280725.4c804bc2@posting.google.com>

Dear All

Can anyone help the following please?

I have an Oracle Database on a unix server which link up with Access on a client PC.
Table A has a form (user interface) which developed by Access's Form for data entry. I want to insert a record into Table B if Table A's variable Z = "Yes". But I am not sure the syntax on Access's Event Procedure, I typed:

if Z = 'Yes' then

insert into B in "n:\oracle_link.mdb" values (txtStudyNo, txtStudyYear, 'N');

               ^              ^                      
               |              |
            Table B        path where the link up databse on Access

end if

Actually I tried the simple way to do this by writing a trigger on Table A, however, it didnt work since the data entry through Access. Couldn't see any error message from Access. That's why I tried to insert record via Access's Event Procedure.

Karen Received on Thu Nov 28 2002 - 09:25:03 CST