MSAccess & Oracle
Date: 1997/02/13
Message-ID: <33035B49.4245_at_mpi-fg-koeln.mpg.de>#1/1
Hi everyone!
Please excuse the crossposting and my bad english.
We use Oracle 7.3 (Digital UNIX) and want to use
MSAccess 7.0 (Windows NT) as a frontend (via
ODBC).
Most things seem to work fine: we´ve exported
tables, that were created with Access, to Oracle.
This worked.
Now we want to use Access only as the frontend on
the PC. But there are two problems.
1. Editing the attached tables with Access works.
But after inserting data using SQLPLUS with the
"insert into"-command, i can´t see the inserted
rows from Access. Looking with the
"select"-command at the table, the rows exist. ???
2. Using the Oracle-tables as attached tables in
Access, it is not possible to work with
Access-Form-wizards. Creating the forms without
the wizard works. ???
Any help would be appreciated.
Please reply to my EMail-address, because i can´t read newsgroups for the next two weeks.
Thank you in advance,
Manuel Schueren
(ms_at_mpi-fg-koeln.mpg.de)
Received on Thu Feb 13 1997 - 00:00:00 CET