stopher2475
asked on
Access linked table not showing Oracle data.
I have an access database linked to 2 tables in oracle.
In one of the tables I am not seeing any records. I now they are there. I can see them in SQL developer. If I add a record it inserts into the oracle table. The new records are also in oracle. I just can see any records created within Oracle.
Is there some refresh setting I'm missing? How can I get access to see the records I know are there?
In one of the tables I am not seeing any records. I now they are there. I can see them in SQL developer. If I add a record it inserts into the oracle table. The new records are also in oracle. I just can see any records created within Oracle.
Is there some refresh setting I'm missing? How can I get access to see the records I know are there?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i seem to recall that Access need a primary key on the oracle table, to work properly, do you have one?
ASKER
I think you win the prize. I'm used to SQL server and I'm still climbing the Oracle learning curve.
Glad to help.
Welcome to the Oracle world! Its not that bad (once you get used to a few things).
Welcome to the Oracle world! Its not that bad (once you get used to a few things).