COMPILER WRONG example-DB

P

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
 
T

Tony Toews [MVP]

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

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
Click to expand...
**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
Click to expand...

**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/
 
P

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

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)
 
T

Tony Toews [MVP]

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

I don't know enough about OLEDB to answer your question so I'll leave
that to others.
Any other questions ?
Click to expand...

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/
 
B

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....
Click to expand...

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...
Click to expand...

See my example above.
The same Ac2000,Ac2002,Ac2003 SP3 (Full last office update)
Click to expand...

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

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
 
T

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....
Click to expand...

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
Click to expand...

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/
 
P

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)
 
P

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
 
S

sku1-2

df
pacala_ba said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compiler WRONG example-DB 0
object or class does not support the set of events 9
I cannot run a query in Access 2007 that joins to Paradox 1
what reference library to use for common dialog boxes 1
Windows 7 "Windows cannot find svchost.exe?" 1
Access XP Runtime with Access 2003 Full Version MSO.dll error 0
Assigning references with VBA code 1
Visual Basic References 2

Top