Re: Access frontal interface for Oracle database
Date: Sun, 10 Aug 2008 01:15:32 GMT
Message-ID: <Uirnk.643$xv.382@trnddc02>
"Gloops" <gloops_at_invalid.zailes.org> wrote in message
news:g7l3k5$fi8$1_at_aioe.org...
> 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 9.2.0.1.0 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