473,698 Members | 2,274 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1723

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.TitleNam e, [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].MoreThanOneHor seDiscount, IIf([Sum Of Count Of Insurance
Query]>1,[Sum Of Total]/100*[MoreThanOneHors eDiscount],0) AS Discount,
IIf([HorseOverRideAm ount]<>0,[HorseOverRideAm ount],[Sum Of
Total]-[Discount]) AS TotalAfterDisco unt,
IIf([StartDate]>#6/30/1999#,5,4) AS InsurancePremiu mTax,
[TotalAfterDisco unt]/100*[InsurancePremiu mTax] AS Tax,
[TotalAfterDisco unt]+[Tax] AS TotalAfterTax, [Client Details].Payment,
[Client Details].PaymentNo, [Client Details].HorseOverRideA mount AS
Expr1, [Insurance Totals].VehicleMake, [Insurance
Totals].VehicleSumInsu red, [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.c o.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
8733
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 nor delete it. However, when opening the same .DBF tabel with Access 2000, though installed on another computer, I can change the content or delete the record. Obviously this Access has other setting(s), but which??? Can anyone help me out?
3
3889
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 that represents the final results for the year. The table into which I wish to save it has 10 records, the past 10 years results. The problem is that I select the calendar year from an unbound combo box and it runs a filter that restricts the...
3
17519
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 problem it just happened all of a sudden. - The database has been repaired and converted several times to no avail. - All the permissions are correct. - Copying and pasting the table and query in the same database does
1
2472
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.*, dbo_tblDistributionMaster.fldDocumentType, dbo_tblDistributionMaster.fldDocumentID, dbo_tblDistributionMaster.ts FROM dbo_tblDistributionMaster INNER JOIN dbo_tblDistributionDetail ON dbo_tblDistributionMaster.fldDistributionID =
2
5189
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 for a MS SQL Server DTS package. That I know how to do. I just don't know how to open the Connection and/or Recordset so I can change the SQL WHERE clause in the loop & then update the resulting recordset.
13
3469
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 query: QryICTMassDistribution3) , I then use a form and the code below to create a new record in the corrispondence table to show what corrispondence has been sent to various companies.
2
2112
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 to a table. Code: Q2 = "SELECT T_SMP_RCNR.KEY_ORDER, T_SMP_RCNR.RCNR, T_SMP_RCNR.KEY_RCNR " & _ "FROM T_SMP_RCNR LEFT JOIN Q_MaxOfSMPRCNR ON
2
1234
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. I am capable of building the query to show the records but when I include one query I need to get a limiting value from (orders greater than 1 per day, calculated value in that query) the records are no longer editable. I believe this is because...
7
5638
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 directly changed the tables under the query. I wanted the changes to be 'in-memory' so that I could check them before applying them to the tables. When I changed the subform to use the recordset, it is now 'read-only' and I can't change anything...
0
8672
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8600
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9156
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8860
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7712
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6518
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5860
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4361
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
3
1998
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.