In addition I believe there may be a migration assistant to Oracle 7.3
there's one for 8. I agree with the RDO statement. From my experience
with VB and Delphi you with have less problems with Delphi.
--
Patrick Lanphier
email: P-Lanphier_at_psu.edu Applied Research Laboratory
phone: (814) 861-6723 Pennsylvania State University
exe wrote:
>
> > I am trying to insert into an Oracle database from Microsoft Access 97. I
> > am using an ODBC connection to an Oracle 7.3 database. When ever I try to
> > do multiple Execute sql statement it hangs. If I comment out either of the
> > two Execute sql commands it runs fine. I will eventually be attempting to
> > do basically a thousand of so inserts. Is there a better way to do this?
>
> There are two better ways,
>
> 1. If you stay with Access97 or go to Visual Basic use RDO
> 2. Drop those cheap Microsoft tools that are designed to not work well with
> any
> product not made by Microsoft and get something robust like:
>
> Designer/2000
> Developer/2000
> PowerBuilder
> Delphi 3
> Crystal Reports
> Paradox for Windows 8
> or anyone of a large number of better quality tools.
>
> And remember that ODBC access to any database is no longer secure as the new
> ODBC manager allows anyone to capture user ids and passwords.
>
> Regards,
>
> Daniel A. Morgan
Received on Thu Oct 23 1997 - 00:00:00 CDT
