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
Thanks,
Scott
RE: Binding access data controls to Oracle back end
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