Simple Update Query

[thetuckers_jersey@hotmail.com]

I have the following query :


UPDATE SH_Tourcodes LEFT JOIN Tour ON (SH_Tourcodes.R ECEIPT =
Tour.RECEIPT) AND (SH_Tourcodes.T ILL = Tour.TILL) AND
(SH_Tourcodes.T IME = Tour.TIME) AND (SH_Tourcodes.D ATE = Tour.DATE) SET

Tour.TOURCODE = [SH_Tourcodes]![TOURCODE];


SH_Tourcodes is a query to filter out some records, Tour is a
straightforward table.


When I try and run this I get the message "Operation must use an
updateable query".


I am tearing my hair out - grateful for any assistance.

[shumaker@cs.fsu.edu]

Re: Simple Update Query

Do any other update queries work for this data?
[color=blue]
>From a search for your error message it appears that you need to make[/color]
sure you have full permissions for the database file/folder.

[thetuckers_jersey@hotmail.com]

Re: Simple Update Query

Yes. It is a table created locally within an access db from a SQL
table. I cannot fathom it out. It may be that my version of Access is a
little iffy. I have managed to solve it by running the query at SQL
Level.

Thanks for your time.

Regards