Re: Access frontal interface for Oracle database
Date: Sun, 10 Aug 2008 01:15:32 GMT
"Gloops" <gloops_at_invalid.zailes.org> wrote in message
> 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 18.104.22.168.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
> 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