this record is not updatable

M

maryj

Access 03/WinXP - Client is trying to run a select query with 3 fields. One
table is in Access and the other is linked to an external database. Both
tables will open and display the records. This query has worked before - not
aware of any changes. Now when trying to run the query, the message "This
record is not updatable" in the status bar. Access will then lock up and need
to end task. The database is only 216 mb. She has already done a compact and
repair. Any ideas/suggestions?
 
J

Jerry Whittle

External database or Excel file? MS had to disable some of the functionality
of linking to Excel due to a patent lawsuit. If a server pack or release was
recently installed, that could be the problem.

Other than that there are many things that will make a recordset not
updateable. I suggest that you open up Access Help, go to the Find tab, type
in "updatable" (lower case u) or "About updating data", and then scroll down
to "When can I update data from a query?" or "Why can't I edit data in my
form?". There you will find a lot of, possibly too much, information on the
subject. In a nutshell, if the query is based on one table or tables with a
one-to-one relationship, you will be able to edit or delete records. If it is
based on two or more tables with a one-to-many relationship, you 'should' be
able to edit or delete records. If you have three or more tables based on
many-to-one-to-many relationships, you will not be able to edit or delete
records. This is just the highlights. Help has much more information.
 
Top