ODBC link to table in Oracle
When I view a table the correct number of rows are returned but in each field the word #Deleted appears. Take this same ms access mdb to a different user in a different department in our company and all works fine. They are on a different network domain. Any ideas?
Also if I change the type of query from dynaset to snapshot the data appears fine.
The problem is the Primary Key. I did some research on Microsoft.com when I was getting this problem with SQL Server. What I found out is the Primary Key's data type is probably not supported by Access. In my situation I set up the Primary Key was a BigInt thinking it was the same as a Long, but it is much larger than a Long and Access could not handle it. Therefore, when it went to retrieve the data it was only getting some of the Primary Key field. As a result I was getting #Deleted in all fields of the table.
Actually I do not believe that is the issue. The tables in Oracle that I am linking to are part of our Financial/HR package (Lawson). On my old PC it works, on the new PC I received it does not work. I swapped PC's to fix an issue, but since I had the same issue on the new PC I went back to using the old where the linking to the Oracle tables work. Thanks for the link.