access table link to oracle table (1 Viewer)

sahh1419

Registered User.
Local time
Today, 12:10
Joined
Dec 27, 2012
Messages
29
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

Super Moderator
Staff member
Local time
Today, 09:10
Joined
Feb 19, 2013
Messages
16,604
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
 

Users who are viewing this thread

Top Bottom