By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Error with VB/Access StringFromGUID

P: n/a
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.description
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!
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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." <pe***@agilrastreamento.com.br> wrote in message
news:40*********************@news.frii.net...
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.description
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!

Nov 12 '05 #2

P: n/a
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!
Nov 12 '05 #3

P: n/a
"Pedro Carneiro Jr." <pe***@agilrastreamento.com.br> wrote...
Couldn't I put those query calls in an access stored procedure
Access does not have stored procedures.
and then call that stored procedure from VB?
No, as stated above there is no such thing.
Is it possible?


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.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.