473,320 Members | 2,020 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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 1703

Can you post the code you used?

Madhivanan

Nov 13 '05 #2

Madhivanan wrote:
Can you post the code you used?

Madhivanan


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?

Madhivanan


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
will
be a problem.

KC

Nov 13 '05 #4

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

Similar topics

7
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 updateable". And indeed, I can't change the content...
3
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 information (mainly numbers) into 1 large table...
3
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 updateable. As best I know, this has never been a...
1
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 thus: SELECT dbo_tblDistributionDetail.*,...
2
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 though the code is VBA I will be translating to VBS...
13
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 of the companies in the database (found using the...
2
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 don't want to update values from this recordset...
2
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 criteria. I also need these records to be editable....
7
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 query was used, the changes to the subform values...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.