Updating results of query

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

Hi,

I have a query that returns a set of records, some of
which I will want to change (depending on a number of
factors) - but when I try to edit I get the message "this
recordset is not updatable". Is there a way round this?
It isn't feasible to do an update query in this case.

Thanks,

Anna
 
There are several things that can make a query "not updateable". Open the query in SQL
view and copy and paste the text into a message.
 
Thanks for your reply,

Here is the SQL of the query:

SELECT a.*, b.*
FROM tblSourceA AS a INNER JOIN tblSourceB AS b ON a.
[Episode ID] = b.[Episode ID]
WHERE (((a.[Procedure Type])<>.[PP Desc]));

Any ideas?
Thanks,

Anna
-----Original Message-----
There are several things that can make a query "not
Click to expand...
updateable". Open the query in SQL
 
Access is pretty fickle about what it allows for some action queries.

What you can do in your case, is save the initial query data to another
table. Modify it. Then use it as the basis for the Update query.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Is the join field a primary key?

--
Wayne Morgan
Microsoft Access MVP


Anna said:
Thanks for your reply,

Here is the SQL of the query:

SELECT a.*, b.*
FROM tblSourceA AS a INNER JOIN tblSourceB AS b ON a.
[Episode ID] = b.[Episode ID]
WHERE (((a.[Procedure Type])<>.[PP Desc]));

Any ideas?
Thanks,

Anna
-----Original Message-----
There are several things that can make a query "not
Click to expand...
updateable". Open the query in SQL
view and copy and paste the text into a message.

--
Wayne Morgan
Microsoft Access MVP





.
Click to expand...
Click to expand...
 
Hi,

No, the join field isn't a primary key. I'm sure I have
run queries like this before and been able to
update...quite confused!

Thanks,
Anna
-----Original Message-----
Is the join field a primary key?

--
Wayne Morgan
Microsoft Access MVP


Thanks for your reply,

Here is the SQL of the query:

SELECT a.*, b.*
FROM tblSourceA AS a INNER JOIN tblSourceB AS b ON a.
[Episode ID] = b.[Episode ID]
WHERE (((a.[Procedure Type])<>.[PP Desc]));

Any ideas?
Thanks,

Anna
-----Original Message-----
There are several things that can make a query "not
Click to expand...
updateable". Open the query in SQL
view and copy and paste the text into a message.

--
Wayne Morgan
Microsoft Access MVP


Hi,

I have a query that returns a set of records, some of
which I will want to change (depending on a number of
factors) - but when I try to edit I get the message "this
recordset is not updatable". Is there a way round this?
It isn't feasible to do an update query in this case.


.
Click to expand...
Click to expand...




.
Click to expand...
 
Hi, thanks for your reply - I'm rapidly learning all about
how fickle Access can be! Thanks for your suggestion, I'll
give it a try.

Cheers,
Anna
 
If one side isn't a unique index, which a primary key would be, then there could be
duplicates on each side and there is no telling if the records from each table are "lined
up" correctly.
 
Back
Top