SQL in Access

[Dan01]

Hello, I am very new to Access and havent tackled SQl in some years now. I am creating a database/application for my workplace with a login system and have hit a bit of a block.

I have the following code in SQL view and when i run it I get the error....Operation must be an updateable query. Please could someone point out where I am going wrong, heads kinda hurting now

All i need to do it take a few details from one table (User - this table is linked to a backend db) and place them into another table (current_user - this is in the Frontend db file) when the user logs in

Here is the code I have

UPDATE [current_user] SET [current_user].F_name = (SELECT User.F_name
FROM [User]
WHERE User.Username = (
SELECT current_user.curr_username


FROM [current_user]);
);

Thank you in advance

Dan

[Dan01]

Apologies, may have posted this in the wrong section