Code Charge and MS Access

Posted on 2005-05-03
Last Modified: 2008-02-01
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 = {identify}

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

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

Any thoughts would be appreciated...



Question by:Barton_Day
    LVL 44

    Accepted Solution

    the {...}  characters are SPECIAL indicators to Access that what is contained between them is a GUID (Globally Unique Identifier) a GUID ia a 128 bit  Hex Number, which, by the way it is constructed, is essentailly gauaranteed to the 'gloablly unique' -  you migth try enclosing the {...} in [...]:

    UPDATE tbl_ActivityPaths
    SET  tbl_ActivityPaths.path='{path}'
    WHERE = [{identify}]

    Access is trying to interpret the

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

    where I would have expected the {...}  tokens to have been replaced with Literal values before the SQL is sent to Access to be processed.  That is the real source of the error message - why isn't the SQL being pre-processed, before being sent to Access.


    Author Comment

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


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    This article will show, step by step, how to integrate R code into a R Sweave document
    The viewer will learn how to implement Singleton Design Pattern in Java.
    This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now