Add new Rcords

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gsurfdude - 14 May 2008 12:13 GMT

Hello,

I have a continuous form that is a subform who's record source is a query
based on 3 Oracle linked tables.
I have the record set type as Dynaset inconsistant updates. It will not
allow me to insert or
add new records. I have allow additions = yes, allow edits = yes.

How do I allow a user to add new records to this?

Thanks!

Reply to this Message

Douglas J. Steele - 14 May 2008 13:02 GMT

Do you have a primary key (or at least a unique index) defined for each of
the Oracle tables? ODBC won't let you update unless you do.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hello,
>
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message

Gsurfdude - 14 May 2008 14:21 GMT

Yes, there are two PK's for all 3 tables.

> Do you have a primary key (or at least a unique index) defined for each of
> the Oracle tables? ODBC won't let you update unless you do.
[quoted text clipped - 10 lines]
> >
> > Thanks!

Reply to this Message

Douglas J. Steele - 14 May 2008 21:47 GMT

What error message do you get?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Yes, there are two PK's for all 3 tables.
>
[quoted text clipped - 14 lines]
>> >
>> > Thanks!

Reply to this Message