alaskaguru
Programmer
If you are using the 8.0.05 version of the Oracle ODBC driver for Access then you should upgrade to the 8.0.058 version. It will eliminate many problems.<br>
<br>
However, I have found one bug in both drivers. My linked tables are actually linked to Oracle views built from the following query:<br>
<br>
select * from table_name where site_id = user;<br>
<br>
That way the user only sees their own site. However, the ODBC driver isn't functioning correctly and is allowing the viewing of ALL data (Site_ID like '%'). This is not good. If anyone knows anything additional about this bug please let me know.
<br>
However, I have found one bug in both drivers. My linked tables are actually linked to Oracle views built from the following query:<br>
<br>
select * from table_name where site_id = user;<br>
<br>
That way the user only sees their own site. However, the ODBC driver isn't functioning correctly and is allowing the viewing of ALL data (Site_ID like '%'). This is not good. If anyone knows anything additional about this bug please let me know.
