Hi, never seen, Compiler corruption ???
******* MICROSOFT COMPILER WRONG !!!!! ********
===============================================
!!!!! EXAMPLE FOR TEST !!!!!!!! Missing -->>>> ";User ID="
Crazy-Errors (Unvisible strings) Run=YES, IMMEDIATE WINDOW=NO
-------------
DOWNLOAD
http://www.dbforums.com/microsoft-ac...xample-db.html
or
http://sites.google.com/site/pacalaba/
xPAC_DFT_AC2002_CCC_STR__PROVIDER_0.zip
-------------
AC 2002, with usual references....
download everywhere
open DB with Admin
open immediate window and type...
? CCC_STR(,eDB__DAT_DFT)

Provider=Microsoft.Jet.OLEDB.4.0Admin;Password=;Je t OLEDBatabase
Password=***;Data Source=D:\_MOJE\_APL\AC\BDB\DAT_DFT.MDB;Mode=16;Ex tended
Properties="";Jet OLEDBystem database=D:\_MOJE\_APL\AC\BDB\xPAC_SYS0.MDW;Jet
OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=1;Jet
OLEDB:Global Bulk Transactions=1

lcRet = "Provider=" & gkDatabaseProvider & ";User ID=" & CurrentUser & ";"
-----------------------------------------------0 * MISSING * 0----------------

after compactrepair the same, allways.... !!!!
references
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
C:\Program Files\Microsoft Office\Office10\MSACC.OLB
C:\WINDOWS\system32\stdole2.tlb
C:\Program Files\Common Files\system\ado\msado25.tlb
C:\Program Files\Common Files\Microsoft Shared\Web Components\10\OWC10.DLL
C:\Program Files\Common Files\System\ado\msadox.dll
C:\Program Files\Common Files\System\ado\msjro.dll
C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
C:\Program Files\Microsoft Office\Office10\EXCEL.EXE
C:\WINDOWS\system32\MSCOMCTL.OCX
C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLL
C:\WINDOWS\system32\scrrun.dll
C:\WINDOWS\system32\FM20.DLL
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
C:\Program Files\Microsoft Office\Office10\MSOUTL.OLB

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm....public.access

pacala_ba <(E-Mail Removed)> wrote:

>Hi, never seen, Compiler corruption ???
>******* MICROSOFT COMPILER WRONG !!!!! ********
>===============================================
>!!!!! EXAMPLE FOR TEST !!!!!!!! Missing -->>>> ";User ID="
>Crazy-Errors (Unvisible strings) Run=YES, IMMEDIATE WINDOW=NO

Please explain the problem you are having. Your posting isn't making
much sense to me.

Wow, that is a lot of references in the list below.

>references
>C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
>C:\Program Files\Microsoft Office\Office10\MSACC.OLB
>C:\WINDOWS\system32\stdole2.tlb
>C:\Program Files\Common Files\system\ado\msado25.tlb
**C:\Program Files\Common Files\Microsoft Shared\Web
Components\10\OWC10.DLL

Why do you need this one?

**C:\Program Files\Common Files\System\ado\msadox.dll

Unless you are using ADOX remove the above.

**C:\Program Files\Common Files\System\ado\msjro.dll

Why do you need this one?

>C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll

**C:\Program Files\Microsoft Office\Office10\EXCEL.EXE

Late binding means you can safely remove the reference and only have
an error when the app executes lines of code in question. Rather than
erroring out while starting up the app and not allowing the users in
the app at all. Or when hitting a mid, left or trim function call.

This also is very useful when you don't know version of the external
application will reside on the target system. Or if your organization
is in the middle of moving from one version to another.

For more information including additional text and some detailed links
see the "Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.htm

**C:\WINDOWS\system32\MSCOMCTL.OCX

How do you get rid of troublesome ActiveX Controls/references?
http://www.granite.ab.ca/access/referencetroubles.htm

**C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLL
**C:\WINDOWS\system32\scrrun.dll
**C:\WINDOWS\system32\FM20.DLL
**C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
**C:\Program Files\Microsoft Office\Office10\MSOUTL.OLB

You can likely get rid of the above five as well.

Remove one at a time and compile your project.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

=?Utf-8?B?cGFjYWxhX2Jh?= <(E-Mail Removed)> wrote
in news:4ED85294-3BAC-471B-8959-(E-Mail Removed):

> Hi, never seen, Compiler corruption ???

Fix your code.

--
Bob Quintal

PA is y I've altered my email address.

**** STEP-BY-STEP GUID ******
open DB with Admin
open immediate window and type...
? CCC_STR(,eDB__DAT_DFT)

than cursor on function 'CCC_STR' and press SHIFT+F2 (Definition)
Make a breakpoint at the start of 'CCC_STR'
goto immediate window to line
? CCC_STR(,eDB__DAT_DFT) .. and <PRESS ENTER>
Set NEXT STATEMENT to
Code:
lcRet = "Provider=" & gkDatabaseProvider & ";User ID=" & CurrentUser & ";"
Press F8 (STEP INTO)
----------- NOW Compare the Value of variable lcRet -----------
goto immediate window and type
Code:
? lcRet
Provider=Microsoft.Jet.OLEDB.4.0Admin;
Missing STRING: --->>> ";User ID=" <<<-----WHY ??????????????
-----------------
Now VERIFY Compiler lcRet = "Provider=" ....
Code:
? "Provider=" & gkDatabaseProvider & ";User ID=" & CurrentUser & ";"
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;
STRING is THERE : --->>> ";User ID="
-----------------
Any other questions ?

"Tony Toews [MVP]" wrote:

> pacala_ba <(E-Mail Removed)> wrote:
>
> >Hi, never seen, Compiler corruption ???
> >******* MICROSOFT COMPILER WRONG !!!!! ********
> >===============================================
> >!!!!! EXAMPLE FOR TEST !!!!!!!! Missing -->>>> ";User ID="
> >Crazy-Errors (Unvisible strings) Run=YES, IMMEDIATE WINDOW=NO
>
> Please explain the problem you are having. Your posting isn't making
> much sense to me.
>
> Wow, that is a lot of references in the list below.
>
> >references
> >C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
> >C:\Program Files\Microsoft Office\Office10\MSACC.OLB
> >C:\WINDOWS\system32\stdole2.tlb
> >C:\Program Files\Common Files\system\ado\msado25.tlb
> **C:\Program Files\Common Files\Microsoft Shared\Web
> Components\10\OWC10.DLL
>
> Why do you need this one?
>
> **C:\Program Files\Common Files\System\ado\msadox.dll
>
> Unless you are using ADOX remove the above.
>
> **C:\Program Files\Common Files\System\ado\msjro.dll
>
> Why do you need this one?
>
> >C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
>
> **C:\Program Files\Microsoft Office\Office10\EXCEL.EXE
>
> Late binding means you can safely remove the reference and only have
> an error when the app executes lines of code in question. Rather than
> erroring out while starting up the app and not allowing the users in
> the app at all. Or when hitting a mid, left or trim function call.
>
> This also is very useful when you don't know version of the external
> application will reside on the target system. Or if your organization
> is in the middle of moving from one version to another.
>
> For more information including additional text and some detailed links
> see the "Late Binding in Microsoft Access" page at
> http://www.granite.ab.ca/access/latebinding.htm
>
> **C:\WINDOWS\system32\MSCOMCTL.OCX
>
> How do you get rid of troublesome ActiveX Controls/references?
> http://www.granite.ab.ca/access/referencetroubles.htm
>
> **C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLL
> **C:\WINDOWS\system32\scrrun.dll
> **C:\WINDOWS\system32\FM20.DLL
> **C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB
> **C:\Program Files\Microsoft Office\Office10\MSOUTL.OLB
>
> You can likely get rid of the above five as well.
>
> Remove one at a time and compile your project.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
>

Hi
My code is O.K. (It seems to be...)
My problems is How to catch this Crazy Errors...
(When Running Error, but in Immediate window the same is OK !!!!!)
It happens Sometimes not Allways....
Im Singel User,local data, DB size VERY small =3MB
The same behaviour on diffeent machines....!!!!
I can remove this error, after compiling, reimporting into new one....
But I DO NOT KNOWN, Are there Crazy Errors Yes or not ?
Compile OK, mkae MDE OK, only while running code i see this Crazy errors...
It is really annoying thing...
The same Ac2000,Ac2002,Ac2003 SP3 (Full last office update)

"Bob Quintal" wrote:

> =?Utf-8?B?cGFjYWxhX2Jh?= <(E-Mail Removed)> wrote
> in news:4ED85294-3BAC-471B-8959-(E-Mail Removed):
>
> > Hi, never seen, Compiler corruption ???
>
> Fix your code.
>
> --
> Bob Quintal
>
> PA is y I've altered my email address.
>

pacala_ba <(E-Mail Removed)> wrote:

>? "Provider=" & gkDatabaseProvider & ";User ID=" & CurrentUser & ";"
>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;
>STRING is THERE : --->>> ";User ID="

I don't know enough about OLEDB to answer your question so I'll leave
that to others.

>Any other questions ?

You completely ignored my questions regarding your references. I
*strongly* urge you to read the section of my posting on that topic
and remove all possible references.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

=?Utf-8?B?cGFjYWxhX2Jh?= <(E-Mail Removed)> wrote
in news:8C7DEBB9-9149-47F9-BE55-(E-Mail Removed):

> Hi
> My code is O.K. (It seems to be...)
> My problems is How to catch this Crazy Errors...
> (When Running Error, but in Immediate window the same is OK !!!!!)
> It happens Sometimes not Allways....

If that is happening, then you have the probability that the code is
not always receiving correct parameters.

Example: A parameter is obtained from a recordset. The code works
except when the recordset is at .EOF.


> Im Singel User,local data, DB size VERY small =3MB
> The same behaviour on diffeent machines....!!!!
> I can remove this error, after compiling, reimporting into new
> one.... But I DO NOT KNOWN, Are there Crazy Errors Yes or not ?
> Compile OK, mkae MDE OK, only while running code i see this Crazy
> errors... It is really annoying thing...

See my example above.

> The same Ac2000,Ac2002,Ac2003 SP3 (Full last office update)

The same problem in all versions indicates a coding problem, like the
example I gave above.

>
> "Bob Quintal" wrote:
>
>> =?Utf-8?B?cGFjYWxhX2Jh?= <(E-Mail Removed)>
>> wrote in news:4ED85294-3BAC-471B-8959-(E-Mail Removed):
>>
>> > Hi, never seen, Compiler corruption ???
>>
>> Fix your code.
>>
>> --
>> Bob Quintal
>>
>> PA is y I've altered my email address.
>>



--
Bob Quintal

PA is y I've altered my email address.

1. I don't know enough about OLEDB .. does not matter,
It is ONLY ( !/? ) STRING/Compiler Problem,
my Compiler SKIPs some string by RANDOM proccess
Ac 2000,Ac2002,Ac2003 SP3 last update the same....

2. The same also ONLY with
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
C:\Program Files\Microsoft Office\Office10\MSACC.OLB
C:\Program Files\Common Files\system\ado\msado25.tlb
C:\Program Files\Common Files\System\ado\msadox.dll
C:\WINDOWS\system32\scrrun.dll
C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
or see
http://www.dbforums.com/microsoft-ac...xample-db.html

"Tony Toews [MVP]" wrote:

> pacala_ba <(E-Mail Removed)> wrote:
>
> >? "Provider=" & gkDatabaseProvider & ";User ID=" & CurrentUser & ";"
> >Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;
> >STRING is THERE : --->>> ";User ID="
>
> I don't know enough about OLEDB to answer your question so I'll leave
> that to others.
>
> >Any other questions ?
>
> You completely ignored my questions regarding your references. I
> *strongly* urge you to read the section of my posting on that topic
> and remove all possible references.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
>

My Compiler do not see some strings, recompile helps, but it happens
by RANDOM Procces, I do not is it OK ?
Allways i encounter another Place is WRONG while running code, but in
immediate
the same is O.K. !!!!!!, see :
http://www.dbforums.com/microsoft-ac...xample-db.html

"Bob Quintal" wrote:

> =?Utf-8?B?cGFjYWxhX2Jh?= <(E-Mail Removed)> wrote
> in news:8C7DEBB9-9149-47F9-BE55-(E-Mail Removed):
>
> > Hi
> > My code is O.K. (It seems to be...)
> > My problems is How to catch this Crazy Errors...
> > (When Running Error, but in Immediate window the same is OK !!!!!)
> > It happens Sometimes not Allways....
>
> If that is happening, then you have the probability that the code is
> not always receiving correct parameters.
>
> Example: A parameter is obtained from a recordset. The code works
> except when the recordset is at .EOF.
>
>
> > Im Singel User,local data, DB size VERY small =3MB
> > The same behaviour on diffeent machines....!!!!
> > I can remove this error, after compiling, reimporting into new
> > one.... But I DO NOT KNOWN, Are there Crazy Errors Yes or not ?
> > Compile OK, mkae MDE OK, only while running code i see this Crazy
> > errors... It is really annoying thing...
>
> See my example above.
>
> > The same Ac2000,Ac2002,Ac2003 SP3 (Full last office update)
>
> The same problem in all versions indicates a coding problem, like the
> example I gave above.
>
> >
> > "Bob Quintal" wrote:
> >
> >> =?Utf-8?B?cGFjYWxhX2Jh?= <(E-Mail Removed)>
> >> wrote in news:4ED85294-3BAC-471B-8959-(E-Mail Removed):
> >>
> >> > Hi, never seen, Compiler corruption ???
> >>
> >> Fix your code.
> >>
> >> --
> >> Bob Quintal
> >>
> >> PA is y I've altered my email address.
> >>
>
>
>
> --
> Bob Quintal
>
> PA is y I've altered my email address.
>

pacala_ba <(E-Mail Removed)> wrote:

I simply don't understand your English. It would appear that English
is not your first language. Is there an Access newsgroup available in
your native language? See the list at
http://www.microsoft.com/communities...s/default.aspx and
see if your native language is available there.

> 1. I don't know enough about OLEDB .. does not matter,
> It is ONLY ( !/? ) STRING/Compiler Problem,
>my Compiler SKIPs some string by RANDOM proccess
>Ac 2000,Ac2002,Ac2003 SP3 last update the same....

We don't know that.

>2. The same also ONLY with
>C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
>C:\Program Files\Microsoft Office\Office10\MSACC.OLB
>C:\Program Files\Common Files\system\ado\msado25.tlb
>C:\Program Files\Common Files\System\ado\msadox.dll
>C:\WINDOWS\system32\scrrun.dll
>C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll

I have no idea what you mean by this reply. Have you removed all the
other references so this is all you have left? What is the
scrrun.dll reference for? Can it be removed?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/