ODBC Connection To Oracle

  • Thread starter Thread starter Bill Mills
  • Start date Start date
B

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.
 
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.
 
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".
 
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.
 
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.
 
Back
Top