ODBC Connection To Oracle

[Bill Mills]

I currently have an ODBC connection to Oracle and have
linked tables to an Oracle database table. The form uses
a Select statement query to pull information from the
table but is not showing any data nor are there any text
boxes displayed on the form. Any ideas why and what am I
missing? Has anybody connected to oracle through linked
tables in Access.

 

[Lynn Trapp]

In all likelihood the query is not updatable. Run the query from the query
grid and see if it will allow you to add a new record. If not, then it is
not updatable. The most common cause of an ODBC query not being updatable is
the absence of a unique identifier.

 

[Brian Camire]

Does your SELECT statement have a WHERE clause that places any conditions on
text fields? Unlike in Access, text comparison in Oracle (even on Oracle
tables linked into Access) is case-sensitive.

For example, if your SELECT statement is something like:

SELECT
YOUR_LINKED_TABLE.*
FROM
YOUR_LINKED_TABLE
WHERE
YOUR_LINKED_TABLE.YOUR_TEXT_FIELD = "abc"

it would return records where YOUR_TEXT_FIELD equalled "abc", but not those
where it equalled "ABC".

 

[Bill Mills]

There are no conditions in WHERE. I did have some
conditions but it wasn't working so I went back to the
basics to see if I could get any data with the simple
Select from statement and couldn't get anything there
either.

 

[Bill Mills]

Thanks, that was it. I had several fields selected but
not the unique identifier. I could add fields directly
from the linked tables and not the query. That is why, I
had selected fields in the query that didn't include the
unique identifier. Thanks, you are a life saver.

 

[Lynn Trapp]

You are very welcome, Bill.
I'm glad you got it to work.

Lynn Trapp
MS Access MVP