Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Switching To Oracle
On Sat, 30 Mar 2002 02:07:08 -0500, "Anderson O'Reilly"
<andy343666432312221_at_hotmail.com> wrote:
>We are switching to Oracle (UNIX) from MS Access soon. Forms can be made
>easily with MS Access. How to make forms to be used with Oracle? Is there
>any helpful book that you could recommend? I learned how to CREATE TABLE and
>INSERT INTO. Is there any convenient way to insert records without typing
>INSERT INTO for every record? Thanks in advance.
>
Looks like the move to Oracle is ill-prepared, as you don't seem to be
aware Oracle has server and front-end products. You seem to have
bought the server product only.
*Theoretically* you can continue using the Access Forms, provided you
use ODBC to connect against the Oracle database. ODBC however usually
is a can of worms and far from stable and/or fast.
Then there is the Designer/Developer suite to design and generate
Oracle Forms. The current release is Designer 6i.
There also is JDeveloper when you want to use Java based software.
This is also a seperate product.
The server product comes with the following 3GL interface
- Oracle Objects for OLE, aka OO4O. This is a DAO-like *native*
interface which can be used in Visual Basic and Visual C++
- Oracle OLEdb
Hth
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Sat Mar 30 2002 - 06:59:37 CST