The record set is not updatable (MS Access)

The record set is not updatable
message from mike on 18 May 2004
Can anybody help with this one? I have a number of queries that I run on a regular basis which I then use to update certain data. This has worked fine previously until today. Now when I try to update through any of the queries I get "The record set is not updatable". The queries are fine and the records they produce have always been updatable in the past. Anybody have any ideas?

mike replied to mike on 21 May 2004

Contacted a very useful person at MS Support and the problem is now
solved. Don't ask how but what I did was as suggested to make the
linked table a local table - that worked then reverted to a linked table
and that worked again. Magic if you ask me!

Tony Toews replied to mike on 19 May 2004

To add to John's posting there is a security bulletin out which may
have updated the Jet version on you without you realizing.

msjet40.dll
Jet 4.0 SP 6 - 4.0.6218.0
Jet 4.0 SP 7 - 4.0.7328.0
Jet 4.0 SP 8 - 4.0.8015.0
Microsoft Security Bulletin MS04-014 - 4.0.8618.0

Look in the \Windows\System or \WinNT\System32 or similar directory
for the above files. Then right click on the file >> Properties >>
Version.

Tony

mike replied to mike on 20 May 2004

Tony - you were right. I have msjet35 (August 2002) and msjet40 (14
April 2004). I haven't used access since the beginning of April so......
Can I revert? or what do I need to do - any clues anyone?

mike replied to mike on 19 May 2004

Nope. It worked on Friday but not today!!

mike

John Vinson replied to mike on 18 May 2004

Try compacting the database, and if that doesn't help try recreating
the query: open it in SQL view; copy and paste the SQL text to
Notepad; delete the query; create a new query and paste the SQL back
in.

Have you changed Access (or JET) versions? I know some queries which
were updateable in A97 are not in XP.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

hcj replied to mike on 18 May 2004

This happens when the field you are trying to change comes
from a table without a key field joined to another table
in the query. If everything was fine until now, review
any table design changes you might have made (change key
fields?, remove key fields? replaced table with one from
another db? etc.) Your problem may not be this, but I've
been burned on this point plenty!
Hope this helps. hcj

queries that I run on
This has worked
any of the
fine and the
past.

Archived message: The record set is not updatable (MS Access Forms)