×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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.

Students Click Here

Binding access data controls to Oracle back end

Binding access data controls to Oracle back end

Binding access data controls to Oracle back end

(OP)
I have an existing application that uses VBA and the connected access db but would like to change over to an Oracle 8i db.  I can use linked tables (to Oracle views) to view data, but am unable to edit/update/delete through the app forms.  I want to do as little modification of the application as possible as I have not worked a great deal with VBA (though I do know VB5).  If anyone has any experience with this sort of problem I would appreciate any help you can give me.
Thanks,
     Scott

RE: Binding access data controls to Oracle back end

We had the same problem with an Access/SQL Server 7 application. I would suggest NOT using linked tables (although from the sounds of it, you can't anyway). We modified the code in our Access front end (ADO) to connect to SQL Server (the same thing can be done with Oracle), and the performance was like night and day.

If tables are linked to an ODBC database other than Access, the performance is not what it could be by coding it.

I would suggest either learning the code yourself, or hiring someone to modify the application. It will be much better performance in the long run.

Jim Lunde
compugeeks@hotmail.com
Custom Application Development

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! Already a Member? Login

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