Hi, the CODE is SIMPLE
My_public_const = "ABC"
strSQL = "SOME-STRING" & My_public_const
when running....
strSQL = "SOME-STRING" ...**MISSING** My_public_const, WHY ??
Debugger-Watch window....
strSQL = "SOME-STRING" & My_public_const...O.K.
--------------
I am building allways the same MDE, with little changes
This is allways problem, but allways ANOTHER-CODE-PLACE...!!!???
I have implemented an TEST-RUN, because of this Annoying errors....

"David W. Fenton" wrote:

=?Utf-8?B?UEFDQUxBX0JB?= wrote
in :

After Compile is all OK, NO-Errors (But it is NOT REALLY TRUE !!),
when executing SQL-string ,
comes an Error: ***Invalid syntax of SQL-String***,
because the Acces-System/Compiler
DO-NOT see the value of one public constant (=NullSting) !!!!,

Why not use the built-in Access constant, vbNullString, instead?
Then you don't have to worry about defining your own constants.

but in Debugger/Watch IS the value of public constant ANOTHER
(="LAB") After 'PSEUDO-LINE-EDIT' (Value before and after the
same) it is OK, and runs Error-free over night (15 Hours).
I have NEVER seen such error !!!

I have no idea what the hell you are talking about here.

And you didn't post the code that you say is compiling wrong, so I
really can't suggest anything at all.

It looks to me as though you don't actually want any assistance as
you're making it as hard as possible for anyone to even comprehend
your supposed problem, let alone offer a suggested solution.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/