Re: Access frontal interface for Oracle database

From: gym dot scuba dot kennedy at gmail <>
Date: Sun, 10 Aug 2008 01:15:32 GMT
Message-ID: <Uirnk.643$xv.382@trnddc02>

"Gloops" <> wrote in message news:g7l3k5$fi8$
> Hello everybody,
> Is anyone able to give me some indications about how to develop an Access
> interface for an Oracle database ?
> I dispose of Access 2003 (11.6566.8107) SP2, Oracle 9i and ODBC
> 3.525.1117.0, on Windows XP Pro 5.1.2600 SP2 Nu 2600.
> I failed executing an Oracle stored procedure from Access, and a trigger
> to store data to a temporary table was active from SQL*Plus, but not from
> Access.
> So, my access base can connect one user, not a hundred as requested.
> Anybody ?

Don't use temporary tables. Oracle!=MS Sql Server You would probably have to use a pass through query to do a stored proc. Received on Sat Aug 09 2008 - 20:15:32 CDT

Original text of this message