• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 365
  • Last Modified:

ODBC linked records say #deleted

I have an access database which has linked tables to an Oracle database using ODBC drivers Oracle 73 ver 2.5 and Microsoft ODBC for Oracle. When I link to one particular table, half the records say #deleted, even though this is not the case and all of the other tables in the same database work fine. Does anyone have any ideas what is causing this.
0
jacy_m
Asked:
jacy_m
  • 2
1 Solution
 
RRRCommented:
Hi, jacy_m.
I had this too but with SQL database.
I have changed ODBC deriver(just put the new one) and it is work.
You should check the driver and update it to new one.
And do refresh link tables by using 'Linked Tables Manager' in access tools.

There are some search Microsoft knolagedase articles about this problem:
Q166298
Q128809
Q172339

Good Luck
RRR.
0
 
jacy_mAuthor Commented:
Thanks, I updated the driver and everything is working fine.
0
 
RRRCommented:
Jacy_m.
I am pasting my comments as answer.

Good Luck
RRR.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now