Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Connecting Oracle to Access 2000 and making it editable
Not sure what MS Query is, but as for Access 2000 (and xp/2002) yes,
absolutely it's possible. If you mean that you are getting a "Must use
updateable query..." error, then that means you have to relink the
tables (recreate the MS indices that guarantee the tables' uniqueness)
before you can update/delete/insert.
What do you mean "it's very hard to update records to a linked Oracle database..."? There is nothing difficult about it. Open the linked table in Access and apply the update, or do so programatically through a form etc.
If you would like more detailed answers, or these are not what you are looking for, specify your version of Oracle and more detail to your questions.
hth
Bricklen
Dick Stone wrote:
>
> Hi.
>
> I can use MS Query just fine to connect to my Oracle database with an ODBC
> connection; and I can edit the tables.
>
> I cannot do this w/ Access 2000! is it possible?
>
> Also, it's very hard to update records to a linked Oracle database from
> Access 2000 . Any suggestions?
>
> Thank you.
>
> Richard Stone
> dstone_at_world.std.com
Received on Mon Nov 04 2002 - 19:55:58 CST