T
trein.walsh
I have ODBC connections established to a Production Oracle
9.2 database and a Test Oracle 9.2 Database - using
Microsoft Access 2000 to view and edit the database
tables. Test is a database import of a Production database
export. I use the same user to access both environments.
Using the ODBC channel to Prod in Microsoft Access 2000, I
have no problem getting write access to the tables. Using
an ODBC channel (set up exactly as the Prod one) and the
same userid (set up exactly wih the same rights as in
Prod) I have no write rights using Microsoft Access to the
same tables. I also checked that the "Security" options
under "Tools" are set up the same for the 2 Microsoft
Access "views/databases". What is preventing my write
access to the tables in the Test environment?
9.2 database and a Test Oracle 9.2 Database - using
Microsoft Access 2000 to view and edit the database
tables. Test is a database import of a Production database
export. I use the same user to access both environments.
Using the ODBC channel to Prod in Microsoft Access 2000, I
have no problem getting write access to the tables. Using
an ODBC channel (set up exactly as the Prod one) and the
same userid (set up exactly wih the same rights as in
Prod) I have no write rights using Microsoft Access to the
same tables. I also checked that the "Security" options
under "Tools" are set up the same for the 2 Microsoft
Access "views/databases". What is preventing my write
access to the tables in the Test environment?