access table link to oracle table

[sahh1419]

Good Day
i am using oracle 10g Database with form 6i. now i want to connect ZTK 628 finger print device with oracle. The device using the access database. now i want to link when a access table update it will also update oracle table automatically. how i can use this. i have also used ODBC connection but oracle table cannot update.
please advise me the details

 

[CJ_London]

you say the oracle table cannot update - do you mean with what you are trying to do or it just can't be updated at any time?

If the latter, you need to overcome this issue first. To update via ODBC, one requirement is that you have identified the primary key when creating the ODBC link - have you done this?

It is a while since I've linked to oracle and cannot remember the specifics, but if you look to an oracle website you should be able to find the relevant information