Re: Not able to edit fields in an editable datasheet form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 09/23/04


Date: Wed, 22 Sep 2004 23:12:42 -0600

On Wed, 22 Sep 2004 09:13:44 -0700, "Andi"
<anonymous@discussions.microsoft.com> wrote:

>Any ideas on why
>I cannot edit the data anymore?

Probably because the underlying query, or the table under *that*, is
not updateable. A linked Oracle table will only be updateable if it
has a primary key and Access is aware of the fact (you can set the
field containing the unique index in the ODBC connection).

                  John W. Vinson[MVP]
             Join the online Access Chats
        Tuesday 11am EDT - Thursday 3:30pm EDT
      http://community.compuserve.com/msdevapps