Using Microsoft Access 2010 linked table to edit Oracle table data

[SarahNZ]

Does anyone know of any issues or risks that may be encountered using Access 2010 linked tables to update, insert and delete records from the Oracle tables?

Does anyone know how and when the session to the Oracle database is released when using the Access 2010 linked tables?

I am testing using Microsoft Access 2010 linked table to edit Oracle table data (using an ODBC System DSN using the Microsoft ODBC for Oracle driver).
This is done using the External Data - ODBC Database button and setting up Linked tables.

(My PC is running Windows XP SP3, and the current Oracle driver version is 2.575.1132.00)
(The Oracle version is 11g).

 

[Thargy]

Sarah,

the obvious risk is that you may break data integrity if the oracle table is not thoroughly constrained to enforce it. The Access database must either be programmed to maintain integrity, or Oracle must be - preferably both.

Second, since Access is absolutely outside of the control of Oracle, you can asynchronously alter data, ad hoc, which may give undesirable results.

Third, you have to grant permissions to the Access login to be able to alter and extract data. Has this security risk been considered?


Regards

T