Not able to edit fields in an editable datasheet form

  • Thread starter Thread starter Andi
  • Start date Start date
A

Andi

I have a form that is a datasheet. The attributes for
form allows for edits, additions, deletions and data
entry. I was able to edit the data before, but now I'm
not able to. Nothing has changed in the form. I'm able
to use a similar Access database using a similar form
using the same tables (which are links to an Oracle
database) and I'm able to edit the data. Any ideas on why
I cannot edit the data anymore?

Thanks much,
-Andi
 
Any ideas on why
I cannot edit the data anymore?
Click to expand...

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
 
Back
Top