The record set is not updatable

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

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?
 
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
 
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?
Click to expand...

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.
 
Nope. It worked on Friday but not today!!

hcj said:
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
Click to expand...
 
mike said:
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?
Click to expand...

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
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Tony Toews said:
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.
Click to expand...

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?
 
Tony Toews said:
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
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Click to expand...


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