Re: HELP : MSAccess + Oracle

On Tue, 13 Feb 1996 18:36:07, Tony Bravo <TBravo_at_gnn.com> wrote:
>MSAccess can indeed access Oracle tables for read/write. You need ODBC
>drivers and SQL*Net from Oracle (or some 3rd pary solution). You can attach
>Oracle tables and access them just like MSAccess tables. In some cases data
>access to the server backend can be much faster than native Access tables.
>E-mail me if you want more info.
>
>Tony Bravo
>
>-----------------------------------------------------------------------------------------------------
>Tony Bravo 71001.1253_at_compuserve.com
>

There are a couple of "gotchas", though. One is that there must be a unique or primary key constraint on the Oracle table. Also, if you attach the table via an Oracle synonym, it looks like there is no unique key even though there is. If you must attach a table with no unique index or via a synonym, you can define an index in Access via a SQL-Specific Data Definition query (see Access' help). Hope this helps.

Deborah Luik, Lead DBA        
ADP Claims Solutions Group                 Phone: (800) 366-4237 x2150
2010 Crow Canyon Place                     FAX  : (510) 866-4839
San Ramon, CA  94583 (USA)                 Email: dluik_at_sr.csg.com