By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,115 Members | 919 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,115 IT Pros & Developers. It's quick & easy.

Update oracle via Access forms?

P: n/a
Hi,

Is it possible to update oracle via Access forms?
I am thinking maybe I could make a link table connnected with oracle
database. And the form could be based on the link table. Does this
sound feasible?
Any better ways?

Thank you.
Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
A reliable approach for your task is to use ADO. If you can make an
ODBC connection to the Oracle database then you can make an ADO
connection. You can get the connection string of the ODBC linked table
by setting a tableDef object (VBA) and do a

Debug.Print tdf.Connection

Then set an ADO command object to this connection. The catch is that
what you are trying to accomplish using a Form for RELIABLY updating an
Oracle table will require a little bit of programming. So before I
throw out a bunch of meaningless code you might evaluate your goal and
decide if you want to go the VBA solution. If you do - just let me know
(here).

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Jun 27 '08 #2

P: n/a
On 24 Jun, 20:26, Luting <houlut...@gmail.comwrote:
Hi,

Is it possible to update oracle via Access forms?
I am thinking maybe I could make a link table connnected with oracle
database. And the form could be based on the link table. Does this
sound feasible?
Any better ways?

Thank you.
It is extremely easy to make an ODBC connection to an Oracle back end,
Microsoft provide a very good and (free) ODBC driver for Oracle! Just
go to File, Get External Data, Link Tables, in the drop down go to the
last entry ODBC and follow the instructions, you may have to install
an appropriate driver (using hte Microsoft provided MDAC).Then base
your form on that linked table. In an enterprise situation (Oracle
back end) it is normal for any constraints and privileges to be
implemented at the Oracle end where they belong. There is no real need
to involve VBA unless you wish to provide complex data entry or
updating facilities for the user.

We run entire enterprise wide, highly complex data manipulation,
entry, retrieval and reporting systems utilising MS Access forms
linked to complex Oracle tables. We find them to be very flexible,
quick to build and operate, efficient and robust.

Once a link has been made to an Oracle table Access sees that table
just the same as a native Access table, you can write queries, create
forms and manipulate your data as if it is a local table as long as
you have the requisite privileges to do those operations granted to
you by your Oracle DBA.
Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.