Binding access data controls to Oracle back end 1

[sroberts]

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

 

[jimmythegeek]

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