Temp Tables in a Update Query

[TJVFree]

Hi tek-tips form, I've had good luck with my questions on this form before so I though you might be able to help me with this problem

I'm trying run a update query but get a message "Operation must use an updateable query"

Instead of having to create another table with all the information I need for the criteria is there a way I can make some sort of temporary table within my query or any other advice would be helpful

Thanks for all your time and help

Corey

 

[dhookom]

Corey,
Surely you don't think you have provided enough information for us to provide answers/solutions.

You can create temporary tables.
You can use temporary tables in update queries.
You might be able to substitute a horribly slow domain aggregate function in your update query to make it work.

Do you have any SQL statements, table structures, primary and foreign key fields, specifications, and/or requirements that you could share?


Duane
Hook'D on Access
MS Access MVP

 

[TJVFree]

Thanks Duane,

The table dbo_VC_AdminServices is off of our server and I'm just using that to make the criteria and the test table is the one I'm updating to

UPDATE dbo_VC_AdminServices INNER JOIN test ON dbo_VC_AdminServices.app_num = test.app_num SET test.act_fund = Yes

 

[dhookom]

Are the App_Num fields primary keys and if so, does Access recognize this? App_Num should be unique in at least the dbo_VC_AdminServices table.

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

Have a look here:

http://support.microsoft.com/kb/148581

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886