Error with VB/Access StringFromGUID

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Pedro Carneiro Jr.
    #1

    Error with VB/Access StringFromGUID

    Hello, everybody.

    I have several queries which are within my customer's Access database.
    They query each other to generate results.

    If I run a certain query X from inside Access, there happens no error,
    but when I run it from my VB app the following error is returned:
    ?err.Number
    -2147217900
    ?err.descriptio n
    Function 'StringFromGUID ' not defined in the expression. (Translated
    from Portuguese)
    ?ERR.Source
    Microsoft JET Database Engine

    What should I do?
    Does anybody have any clue about that?

    Thanks in advance for any help.

    []s,
    Pedro.




    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Tags: None
    • Terry Kreft
      #2
      Re: Error with VB/Access StringFromGUID

      You can't run Access queries which contain function calls from VB.

      When you run the queries in Access the expression service evaluates teh
      result of the function as the query is processed, as you are not running
      Access this does not happen.


      --
      Terry Kreft
      MVP Microsoft Access


      "Pedro Carneiro Jr." <pedro@agilrast reamento.com.br > wrote in message
      news:40743ec6$0 $194$75868355@n ews.frii.net...[color=blue]
      > Hello, everybody.
      >
      > I have several queries which are within my customer's Access database.
      > They query each other to generate results.
      >
      > If I run a certain query X from inside Access, there happens no error,
      > but when I run it from my VB app the following error is returned:
      > ?err.Number
      > -2147217900
      > ?err.descriptio n
      > Function 'StringFromGUID ' not defined in the expression. (Translated
      > from Portuguese)
      > ?ERR.Source
      > Microsoft JET Database Engine
      >
      > What should I do?
      > Does anybody have any clue about that?
      >
      > Thanks in advance for any help.
      >
      > []s,
      > Pedro.
      >
      >
      >
      >
      > *** Sent via Developersdex http://www.developersdex.com ***
      > Don't just participate in USENET...get rewarded for it![/color]


        Comment

        • Pedro Carneiro Jr.
          #3
          Re: Error with VB/Access StringFromGUID

          Hi.

          Couldn't I put those query calls in an access stored procedure and then
          call that stored procedure from VB?

          Is it possible?

          Pedro Carneiro Jr.
          Developer
          Goiania - GO - Brasil


          *** Sent via Developersdex http://www.developersdex.com ***
          Don't just participate in USENET...get rewarded for it!

            Comment

            • Michael \(michka\) Kaplan [MS]
              #4
              Re: Error with VB/Access StringFromGUID

              "Pedro Carneiro Jr." <pedro@agilrast reamento.com.br > wrote...
              [color=blue]
              > Couldn't I put those query calls in an access stored procedure[/color]

              Access does not have stored procedures.
              [color=blue]
              > and then call that stored procedure from VB?[/color]

              No, as stated above there is no such thing.
              [color=blue]
              > Is it possible?[/color]

              No, sorry. :-(


              --
              MichKa [MS]
              NLS Collation/Locale/Keyboard Development
              Globalization Infrastructure and Font Technologies

              This posting is provided "AS IS" with
              no warranties, and confers no rights.


                Comment

                Previous template Next
                Working...