INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Using Microsoft Access 2010 linked table to edit Oracle table data

Using Microsoft Access 2010 linked table to edit Oracle table data

Using Microsoft Access 2010 linked table to edit Oracle table data

(OP)
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).

RE: Using Microsoft Access 2010 linked table to edit Oracle table data

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close