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