472,330 Members | 1,281 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,330 software developers and data experts.

Please help 'recordset not updateable' error

Please help this one is driving me mad! I have searched and read all
the topics on the error message I am receiving but none seem to apply
to me!

I have quite a complex query linking all parts of my database together
doing final calculations etc. This query when run (through the form)
comes up with 'this recordset is not updateable' error. I can run the
query on its own but it wont accept new records (and indeed doesnt have
a blank bottom line to accept new records).

In turn this query has another quite complex query feeding into it.
This one seems fine and I can add new records and have them calculated
on the subsiduary query no problem. Just the last final query. It all
used to work and I have compared it to old copies (and indeed cut and
apsted old copies into the new version of the database for the same
thing to happen!).

Any one have any ideas?

Many thanks in advance for your help

Nov 13 '05 #1
3 1654

Can you post the code you used?


Nov 13 '05 #2

Madhivanan wrote:
Can you post the code you used?


OK here goes. It seems to be this one creating the problem (insurance
totals seems to work and update OK). Many thanks

SELECT [Client Details].[Client ID], [Client Details].PolicyNo, [Client
Details].TitleID, Titles.TitleName, [Client Details].Conditions,
[Client Details].FirstName, [Client Details].LastName, [Client
Details].Address, [Client Details].City, [Client Details].Region,
[Client Details].PostalCode, [Client Details].Country, [Client
Details].StartDate, [Client Details].RenewalDate, [Insurance
Totals].S8AmountTotal, [Insurance Totals].HorseID, [Insurance
Totals].HorseName, [Insurance Totals].HorseAge, [Insurance
Totals].ColourID, [Horse Colours].ColourName, [Insurance Totals].[Horse
Sex], [Insurance Totals].VetsFees, [Insurance Totals].ClassOfUse,
[Insurance Totals].SumInsured, [Insurance Totals].S1, [Insurance
Totals].S2, [Insurance Totals].S3, [Insurance Totals].S4, [Insurance
Totals].S5, [Insurance Totals].S6a, [Insurance Totals].S6, [Insurance
Totals].NewForOld, [Insurance Totals].NewForOldTotal, [Insurance
Totals].S8, [Insurance Totals].S9, [Insurance Totals].S10, [Insurance
Totals].S11, [Insurance Totals].AltTher, [Insurance Totals].SubTotal,
[Insurance Totals].[FBrand%], [Insurance Totals].Total, [Insurance
Totals Query].[Sum Of Total], [Number of Horses Insured Query
Count].[Sum Of Count Of Insurance Query], [RateTable
Query].MoreThanOneHorseDiscount, IIf([Sum Of Count Of Insurance
Query]>1,[Sum Of Total]/100*[MoreThanOneHorseDiscount],0) AS Discount,
IIf([HorseOverRideAmount]<>0,[HorseOverRideAmount],[Sum Of
Total]-[Discount]) AS TotalAfterDiscount,
IIf([StartDate]>#6/30/1999#,5,4) AS InsurancePremiumTax,
[TotalAfterDiscount]/100*[InsurancePremiumTax] AS Tax,
[TotalAfterDiscount]+[Tax] AS TotalAfterTax, [Client Details].Payment,
[Client Details].PaymentNo, [Client Details].HorseOverRideAmount AS
Expr1, [Insurance Totals].VehicleMake, [Insurance
Totals].VehicleSumInsured, [Insurance Totals].S14
FROM [RateTable Query], (([Horse Colours] INNER JOIN [Insurance Totals]
ON [Horse Colours].ColourID = [Insurance Totals].ColourID) INNER JOIN
(([Client Details] INNER JOIN Titles ON [Client Details].TitleID =
Titles.TitleID) INNER JOIN [Number of Horses Insured Query Count] ON
[Client Details].[Client ID] = [Number of Horses Insured Query
Count].[Client ID]) ON [Insurance Totals].[Client ID] = [Client
Details].[Client ID]) INNER JOIN [Insurance Totals Query] ON [Client
Details].[Client ID] = [Insurance Totals Query].[Client ID];

Nov 13 '05 #3

dd*****@yahoo.co.uk wrote:
Madhivanan wrote:
Can you post the code you used?


OK here goes. It seems to be this one creating the problem (insurance
totals seems to work and update OK). Many thanks

[query deleted]

Are you by chance trying to update an aggregate field? If so, this
be a problem.


Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: ren | last post by:
Hello, When I open with Access 2000 a .DBF table and try to modify the content of a (random) record, I get the message 'This recordset is not...
by: dixie | last post by:
I have a form full of subforms which bring summary information onto the form from about 12 different tables. I am trying to get all of that summary...
by: jm | last post by:
I have a simple query. It has two tables. If I open the tables separately, I can add records. If I open them up together, the recordset is not...
by: Edward | last post by:
I've recently migrated the back end of one of my client's applications from Access to SQL Server. One of the forms is based on an Access query...
by: MGFoster | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I want the recordset (rs) in the following function to be updateable. How do I do it? Even...
by: Jan | last post by:
Hi I have a database that I use to keep track of the sales promotions that we send to companies. I normally send a mailing based on a subset...
by: Kamil | last post by:
Hi. Is it possible to add new record to my recordset which is based on a query? I want to use this recordset only for temp starage of data, and I...
by: jghouse | last post by:
Everyone, Hopefully you can help me with a little problem I am having. I have a need to limit the records shown in a form by a few different...
by: tnjarrett | last post by:
Hello, I have a MS Access continuous subform that was using a query as the recordsource. I changed it to use a recordset instead because when the...
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.