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?
LVL 2
stopher2475Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
>>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.

Are you commiting the rows?

You can insert rows and see them in the session where you inserted them.  No other session/connection can see them until you commit them.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RindbaekSenior ConsultantCommented:
i seem to recall that Access need a primary key on the oracle table, to work properly, do you have one?
0
stopher2475Author Commented:
I think you win the prize. I'm used to SQL server and I'm still climbing the Oracle learning curve.
0
slightwv (䄆 Netminder) Commented:
Glad to help.

Welcome to the Oracle world!  Its not that bad (once you get used to a few things).
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.