COMPILER WRONG example-DB

[pacala_ba]

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-access/1640960-compiler-wrong-example-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/com...-8959-3c0bc1b6750e&dg=microsoft.public.access

 

[Tony Toews [MVP]]

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/

 

[Bob Quintal]

Hi, never seen, Compiler corruption ???

Fix your code.

 

[pacala_ba]

**** 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="

 

[pacala_ba]

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)

 

[Tony Toews [MVP]]

? "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/

 

[Bob Quintal]

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.

 

[pacala_ba]

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-access/1640960-compiler-wrong-example-db.html

 

[pacala_ba]

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-access/1640960-compiler-wrong-example-db.html

 

[Tony Toews [MVP]]

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/newsgroups/en-us/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/

 

[pacala_ba]

Dbforums: 15 replies/131 views
http://www.dbforums.com/microsoft-access/1640960-compiler-wrong-example-db.html
Screen shot --------> Test_lcRet__PAC.zip (368.8 KB, 9 views)
---------------------------
Utter : 75 replies/ 450 views
http://www.utteraccess.com/forums/s...1812504&page=0&view=collapsed&sb=5&o=&fpart=1
---------------------------
I am sorry, you are right my native languague is not there...
But Dbforums/Utter users , they understand to me ....
See the screen shot, there is exactly my problem explained...
Thank for the answer
I am 15 years DB programming (dBase, FoxPro, MsAccess 2000,2002,2003)

 

[pacala_ba]

Direct screenshot (not ZIP)
http://sites.google.com/site/pacalaba/

 

[Tony Toews [MVP]]

Thank for the answer

Glad to hear you've got an answer that works.

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/

 

[pacala_ba]

I installed Access 2002 just to test your "compiler problem"
.. Indeed, you are right - it is the compiled code that is wrong. Let me
explain;
=================================================
I first confirmed the issue exists with the .MDB file from your website....
http://www.utteraccess.com/forums/s...1812504&page=0&view=collapsed&sb=5&o=&fpart=9
------------
The same AC 2003 SP3 !!!!!! (pacala_ba)
--------------
The {ERROR REF-1} line in the broken version is the problem. Basically there
is a reference table in each compiled module that links indices in the
current module to globally defined constants (etc). In this case, the
reference table has a -1 pointer (0xFFFFFFFF) which is clearly invalid.
---------------
PushStringPtr2Stack (LITERAL-CONST) "Provider="
PushStringPtr2Stack (LITERAL-CONST) MOD_ZZ0_CON.gkDatabaseProvider
ConcatString2Stack NewStackItem = Stack2 & Stack1
PushStringPtr2Stack (LITERAL-CONST) {ERROR REF-1}
ConcatString2Stack NewStackItem = Stack2 & Stack1CallInterfaceMethod
NewStackItem = Access.Application.CurrentUser()ConcatString2Stack
NewStackItem = Stack2 & Stack1PushStringPtr2Stack (LITERAL-CONST) ";"
ConcatString2Stack NewStackItem = Stack2 & Stack1
StoreStackStringToVar lcRet

 

[sku1-2]

df

I installed Access 2002 just to test your "compiler problem"
. Indeed, you are right - it is the compiled code that is wrong. Let me
explain;
=================================================
I first confirmed the issue exists with the .MDB file from your
website....
http://www.utteraccess.com/forums/s...1812504&page=0&view=collapsed&sb=5&o=&fpart=9
------------
The same AC 2003 SP3 !!!!!! (pacala_ba)
--------------
The {ERROR REF-1} line in the broken version is the problem. Basically
there
is a reference table in each compiled module that links indices in the
current module to globally defined constants (etc). In this case, the
reference table has a -1 pointer (0xFFFFFFFF) which is clearly invalid.
---------------
PushStringPtr2Stack (LITERAL-CONST) "Provider="
PushStringPtr2Stack (LITERAL-CONST) MOD_ZZ0_CON.gkDatabaseProvider
ConcatString2Stack NewStackItem = Stack2 & Stack1
PushStringPtr2Stack (LITERAL-CONST) {ERROR REF-1}
ConcatString2Stack NewStackItem = Stack2 & Stack1CallInterfaceMethod
NewStackItem = Access.Application.CurrentUser()ConcatString2Stack
NewStackItem = Stack2 & Stack1PushStringPtr2Stack (LITERAL-CONST) ";"
ConcatString2Stack NewStackItem = Stack2 & Stack1
StoreStackStringToVar lcRet