Link to home
Start Free TrialLog in
Avatar of Barton_Day
Barton_Day

asked on

Code Charge and MS Access

I am using a code generating tool called code charge.  I am using the builder to update a Access Database table.  

I have two labels pulling data from another table but those ID are also in the table that I am updating.  I do not want to combine the two tables because I will have to modify it later.  

UPDATE tbl_ActivityPaths
SET  tbl_ActivityPaths.path='{path}'
WHERE  tbl_ActivityPaths.id = {identify}

When I run this query I receive the following error message...

Malformed GUID. in query expression 'tbl_ActivityPaths.id = {identify}'. (Microsoft JET Database Engine)

Any thoughts would be appreciated...

Thanks,

Bart

ASKER CERTIFIED SOLUTION
Avatar of Arthur_Wood
Arthur_Wood
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Barton_Day
Barton_Day

ASKER

AW...that was Exactly right...!!!! Cant believe it is always the little things we overlook....thanks again...

Bart