Re: Any Solutions? Access --> Oracle

Have you attached to your tables via ODBC? Doesn't sound like it...

Read up on this in MS Access help. If you're trying to insert the nextval of rental_seq, do it in an Oracle trigger (before insert).

-John
john_at_hpe.ufl.edu

Todd Makinster wrote in message <64tn9m$os6$1_at_news.iastate.edu>...
>Hello out there,
>
>Here is what I am doing in a nutshell, making an M$Access 97 frontend
>and Oracle 8 backend through ODBC (7.2???) on M$Windows95/NT. I have
>created several subforms in M$Access and reference them through something
>like this : [forms]![RentedForm]![MovieID] to be the starting point for
>the subform query. What I want to do is INSERT INTO rental_transactions
>VALUES(rental_seq.nextval,[forms]!etc....); Is there any way to do this?
>
>Basically what I want to do (if it is not very clear) is pass Oracle
>the value in a form object(box) to write to a column in my transaction
>file.
>
>Anybody have any ideas and or working solutions?
>TIA--Mak
>
Received on Thu Nov 20 1997 - 00:00:00 CST