ACCESS 2003 CRASH EXAMPLES

P

PACALA_BA

I am using SINGEL user Database MS ACCESS-2003
without large-data-tables, only Modules,forms,...
*************************************
There is since 01/2008 something WRONG...

eMAIL: (e-mail address removed)
*************************
this is Official Report to Microsoft from my PC:
Microsoft We are sorry for the inconvinience....

I does not have internet access on 10.213.52.132

IP: 10.213.52.132
---------------------------------------------
OFFICE-EVENTS(18/08/2008)
---------------------------------------------
Event Application Failure
Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 001ec79a
Date 18/08/2008 16:50:44

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 18/08/2008 17:53:45

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 9:30:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 15:13:07

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004bebf
Date 20/08/2008 16:50:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:15:47

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:18:29

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:23:58

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 17:44:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:45:53

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:51:48

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:54:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 12:18:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:45:50

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:48:30

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 13:03:21

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 13:45:01

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 17:51:22

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004ab9b
Date 21/08/2008 17:54:53

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 17:56:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 22/08/2008 9:40:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 22/08/2008 9:41:58

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 22/08/2008 10:37:45

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module msado15.dll
Module Version 2.81.1128.0
Module Stamp 45911e8b
Debug 0
Offset 00001595
Date 22/08/2008 11:55:44

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 22/08/2008 12:12:41

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 22/08/2008 12:13:41

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module msado15.dll
Module Version 2.81.1128.0
Module Stamp 45911e8b
Debug 0
Offset 00001595
Date 25/08/2008 12:44:26

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module msado15.dll
Module Version 2.81.1128.0
Module Stamp 45911e8b
Debug 0
Offset 00001595
Date 25/08/2008 12:45:31

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 13:15:20

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 13:26:04

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 13:53:26

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 13:54:57

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 13:57:05

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 14:51:44

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004abb6
Date 25/08/2008 14:56:21

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 15:39:31

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 16:40:59

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 001ec79a
Date 25/08/2008 16:43:39

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 16:47:22

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 16:54:49

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 17:08:44
----------------------------------------
RDO CORE
Description MicrosoftRDO.rdoEngine2.0
File C:\WINDOWS\system32\MSRDO20.DLL
Version 6.00.8862

Description MicrosoftRDO.rdoQuery2.0
File C:\WINDOWS\system32\MSRDO20.DLL
Version 6.00.8862

Description MicrosoftRDO.rdoConnection2.0
File C:\WINDOWS\system32\MSRDO20.DLL
Version 6.00.8862
----------------------------------------
ADO CORE
Description ADOConnectObject.ADOConnectObject.7
File C:\Program Files\Common Files\Microsoft Shared\Visual Database
Tools\VDT70.DLL
Version 7.10.3077

Description ADODB.Command
File C:\Program Files\Common Files\System\ado\msado15.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description ADODB.Command
File C:\Program Files\Common Files\System\ado\msado15.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description ADOMD.Catalog
File C:\Program Files\Common Files\System\ado\msadomd.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description ADOR.Recordset
File C:\Program Files\Common Files\System\ado\msado15.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description ADOX.Catalog
File C:\Program Files\Common Files\System\ado\msadox.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description RDS.DataControl
File C:\Program Files\Common Files\System\msadc\msadco.dll
Version 2.81.1124.0 (xpsp_sp2_gdr.060322-1613)

Description JRO.JetEngine
File C:\Program Files\Common Files\System\ado\msjro.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)
----------------------------------------
JET CORE
Description Jet 2.x
Path C:\WINDOWS\system32\MSRD2x35.dll
Version 3.50.3602.0

Description Jet 3.5
Path Not Available
Version

Description ODBC
Path Not Available
Version

----------------------------------------
OLE DB
MediaCatalogDB OLE DB Provider Not Available
Microsoft OLE DB Provider for SQL Server 2000.85.1117.0
MediaCatalogMergedDB OLE DB Provider Not Available
Microsoft ISAM 1.1 OLE DB Provider 4.0.3428.1
Microsoft OLE DB Provider For Data Mining Services 8.0.2039.0
MSDataShape 2.81.1117.0
Microsoft OLE DB Provider for Visual FoxPro 9.0.0.5815
OLE DB Provider for Microsoft Directory Services 5.1.2600.2180
MediaCatalogWebDB OLE DB Provider Not Available
Microsoft OLE DB DM Enumerator 8.0.2039.0
Microsoft OLE DB Provider for OLAP Services 8.0 8.0.2216.0
Microsoft OLE DB Provider for OLAP Services 8.0 8.0.2216.0
Microsoft OLE DB Provider for Internet Publishing 11.0.6715.60
SAP BW OLE DB Provider 3.5.1.635
SAP BW OLE DB Provider 3.5.1.635
Microsoft OLE DB Provider for ODBC Drivers 2.81.1117.0
Microsoft OLE DB Enumerator for ODBC Drivers 2.81.1117.0
Microsoft OLE DB Provider for Outlook Search 1.0.0.3723
Microsoft Jet 4.0 OLE DB Provider 4.0.9502.0
Microsoft OLE DB Enumerator for SQL Server 2000.85.1117.0
Microsoft OLE DB Simple Provider 2.81.1117.0
Microsoft OLE DB Provider for Oracle 2.81.1117.0
Microsoft OLE DB Provider for Indexing Service 5.1.2600.2935

----------------------------------------
ODBC DRIVERS
Name SQL Server
File SQLSRV32.dll
Date 04/08/2004 0:56:46
Version 2000.85.1117.0

Name Microsoft Access Driver (*.mdb)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Text Driver (*.txt; *.csv)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Excel Driver (*.xls)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft dBase Driver (*.dbf)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Paradox Driver (*.db )
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Visual FoxPro Driver
File vfpodbc.dll
Date 19/06/2003 12:05:04
Version 6.1.8630.1

Name Microsoft FoxPro VFP Driver (*.dbf)
File vfpodbc.dll
Date 19/06/2003 12:05:04
Version 6.1.8630.1

Name Microsoft dBase VFP Driver (*.dbf)
File vfpodbc.dll
Date 19/06/2003 12:05:04
Version 6.1.8630.1

Name Microsoft Access-Treiber (*.mdb)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Text-Treiber (*.txt; *.csv)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Excel-Treiber (*.xls)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft dBase-Treiber (*.dbf)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Paradox-Treiber (*.db )
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Visual FoxPro-Treiber
File vfpodbc.dll
Date 19/06/2003 12:05:04
Version 6.1.8630.1

Name Driver do Microsoft Access (*.mdb)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Driver da Microsoft para arquivos texto (*.txt; *.csv)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Driver do Microsoft Excel(*.xls)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Driver do Microsoft dBase (*.dbf)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Driver do Microsoft Paradox (*.db )
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Driver para o Microsoft Visual FoxPro
File vfpodbc.dll
Date 19/06/2003 12:05:04
Version 6.1.8630.1

Name Microsoft ODBC for Oracle
File msorcl32.dll
Date 04/08/2004 0:56:44
Version 2.575.1117.0

Name Ingres
File caiiod32.dll
Date 07/07/1998 12:39:14
Version 2.80.0.21

Name Microsoft FoxPro Driver (*.dbf)
File odbcjt32.dll
Date Not Available
Version Not Available

Name Microsoft ODBC Driver for Oracle
File MSORCL10.DLL
Date Not Available
Version Not Available

Name CR SQLBase
File Not Available
Date Not Available
Version Not Available

Name CR Oracle7
File Not Available
Date Not Available
Version Not Available

Name CR Sybase System 10
File Not Available
Date Not Available
Version Not Available

Name CA-OpenIngres
File caiiod32.dll
Date 07/07/1998 12:39:14
Version 2.80.0.21

Name IBM DB2 ODBC DRIVER
File DB2CLI.DLL
Date Not Available
Version Not Available

----------------------------------------
ODBC CORE
Description Administrator
Version 3.525.1117.0
File C:\WINDOWS\system32\odbccp32.dll

Description Control Panel Device
Version 3.525.1117.0
File C:\WINDOWS\system32\odbccp32.cpl

Description Control Panel Startup
Version 3.525.1117.0
File C:\WINDOWS\system32\odbcad32.exe

Description Cursor Library
Version 3.525.1117.0
File C:\WINDOWS\system32\odbccr32.dll

Description Driver Manager
Version 3.525.1117.0
File C:\WINDOWS\system32\odbc32.dll

Description Localized Resource DLL
Version 3.525.1117.0
File C:\WINDOWS\system32\odbcint.dll

Description Unicode Cursor Library
Version 3.525.1117.0
File C:\WINDOWS\system32\odbccu32.dll

----------------------------------------
LANG
UI Language 0
Help Language 0
Install Language 1033
SKU Language 1033
Web Locale 0

----------------------------------------
MS OFFICCE 2003-ACCESS
Application name Microsoft Access
Version 11.0
Build 8166
Product ID 70136-640-3675536-55076
Application path C:\Program Files\Microsoft Office\OFFICE11\
Language English (United States)
ADO version 2.8
VBA version 6.05
References VBA, Access, stdole, DAO, ADODB, ADOX, JRO, Excel, MSComctlLib,
EXTRA, Office, Scripting, MSForms, VBIDE, Outlook
Database name xPAC_DFT_XP.mde
Database path D:\_moje\_APL\AC\ADB
Database size 9252.0 KB
Database create date 11/08/2008 9:51:47
Current user pacadm
Jet version 4.0

----------------------------------------
JET-CORE
Description Jet 2.x
Path C:\WINDOWS\system32\MSRD2x35.dll
Version 3.50.3602.0

Description Jet 3.5
Path Not Available
Version

Description ODBC
Path Not Available
Version
----------------------------------------
----------------------------------------








PACALA_BA said:
Hi (MS ACCESS 2003, file format 2002/03)
i am using LARGE PROGRAM-(NOT-DATA) DATABASE MDB/MDE
MDB = cca. 15-18 MB, MDE = cca. 9MB
3 class modules 217 KB, 16 MODULES 5.05 MB, 3 REPORTS, 8 FORMS
Help,...There are PERMANET CRASHES(100 Reported to MICROSOFT) !!!!
I have tryed different setings
Compile on Demand,Backgroud compile,..but after some Time Crashes !!!
-------------------------------------
There are COMPILE ERRORS !!!!!!!!!!!!!!!
strSQL = "select * from [" & lcTAble & "] where ...." & lcWhere & "...."
After compile, the string is <SHORTEN> !!!
CNN.Execute strSQL
Debug.print =
strSQL = "select * from ["....<AND NOTHING !!!!>


----------------
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...-9337-eb7d4b6deab4&dg=microsoft.public.access
 
A

a a r o n . k e m p f

Yes, of course JET crashes without reason.

That is why 'anyone with a brain moved to SQL Server a decade ago'.



I am using SINGEL user Database MS ACCESS-2003
without large-data-tables, only Modules,forms,...
*************************************
There is since 01/2008 something WRONG...

eMAIL: (e-mail address removed)
*************************
this is Official Report to Microsoft from my PC:
Microsoft We are sorry for the inconvinience....

I does not have internet access  on 10.213.52.132

IP: 10.213.52.132
---------------------------------------------
OFFICE-EVENTS(18/08/2008)
---------------------------------------------
Event   Application Failure
Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  001ec79a
Date    18/08/2008 16:50:44

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    18/08/2008 17:53:45

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    20/08/2008 9:30:18

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    20/08/2008 15:13:07

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  0004bebf
Date    20/08/2008 16:50:55

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  00180b29
Date    20/08/2008 17:15:47

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  00180b29
Date    20/08/2008 17:18:29

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  00180b29
Date    20/08/2008 17:23:58

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    20/08/2008 17:44:18

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  00180b29
Date    20/08/2008 17:45:53

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  0001f4d7
Date    20/08/2008 17:51:48

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  0001f4d7
Date    20/08/2008 17:54:55

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    21/08/2008 12:18:19

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  0001f4d7
Date    21/08/2008 12:45:50

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  0001f4d7
Date    21/08/2008 12:48:30

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  0001f4d7
Date    21/08/2008 13:03:21

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    21/08/2008 13:45:01

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    21/08/2008 17:51:22

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  0004ab9b
Date    21/08/2008 17:54:53

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    21/08/2008 17:56:19

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    22/08/2008 9:40:19

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    22/08/2008 9:41:58

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  0001f4d7
Date    22/08/2008 10:37:45

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  msado15.dll
Module Version  2.81.1128.0
Module Stamp    45911e8b
Debug   0
Offset  00001595
Date    22/08/2008 11:55:44

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    22/08/2008 12:12:41

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    22/08/2008 12:13:41

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  msado15.dll
Module Version  2.81.1128.0
Module Stamp    45911e8b
Debug   0
Offset  00001595
Date    25/08/2008 12:44:26

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  msado15.dll
Module Version  2.81.1128.0
Module Stamp    45911e8b
Debug   0
Offset  00001595
Date    25/08/2008 12:45:31

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    25/08/2008 13:15:20

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    25/08/2008 13:26:04

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    25/08/2008 13:53:26

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    25/08/2008 13:54:57

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    25/08/2008 13:57:05

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    25/08/2008 14:51:44

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  0004abb6
Date    25/08/2008 14:56:21

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    25/08/2008 15:39:31

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    25/08/2008 16:40:59

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  vbe6.dll
Module Version  6.5.10.24
Module Stamp    464105f1
Debug   0
Offset  001ec79a
Date    25/08/2008 16:43:39

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    25/08/2008 16:47:22

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    25/08/2008 16:54:49

Event   Application Failure
Bucket ID       Not Available
Bucket Table    Not Available
Application     msaccess.exe
Application Version     11.0.8166.0
Application Stamp       46437912
Module  unknown
Module Version  0.0.0.0
Module Stamp    00000000
Debug   0
Offset  00000000
Date    25/08/2008 17:08:44
----------------------------------------
RDO CORE
Description     MicrosoftRDO.rdoEngine2.0
File    C:\WINDOWS\system32\MSRDO20.DLL
Version 6.00.8862

Description     MicrosoftRDO.rdoQuery2.0
File    C:\WINDOWS\system32\MSRDO20.DLL
Version 6.00.8862

Description     MicrosoftRDO.rdoConnection2.0
File    C:\WINDOWS\system32\MSRDO20.DLL
Version 6.00.8862
----------------------------------------
ADO CORE
Description     ADOConnectObject.ADOConnectObject.7
File    C:\Program Files\Common Files\Microsoft Shared\Visual Database
Tools\VDT70.DLL
Version 7.10.3077

Description     ADODB.Command
File    C:\Program Files\Common Files\System\ado\msado15.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description     ADODB.Command
File    C:\Program Files\Common Files\System\ado\msado15.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description     ADOMD.Catalog
File    C:\Program Files\Common Files\System\ado\msadomd.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description     ADOR.Recordset
File    C:\Program Files\Common Files\System\ado\msado15.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description     ADOX.Catalog
File    C:\Program Files\Common Files\System\ado\msadox.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description     RDS.DataControl
File    C:\Program Files\Common Files\System\msadc\msadco.dll
Version 2.81.1124.0 (xpsp_sp2_gdr.060322-1613)

Description     JRO.JetEngine
File    C:\Program Files\Common Files\System\ado\msjro.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)
----------------------------------------
JET CORE
Description     Jet 2.x
Path    C:\WINDOWS\system32\MSRD2x35.dll
Version 3.50.3602.0

Description     Jet 3.5
Path    Not Available
Version

Description     ODBC
Path    Not Available
Version

----------------------------------------
OLE DB
MediaCatalogDB OLE DB Provider  Not Available
Microsoft OLE DB Provider for SQL Server        2000.85.1117.0
MediaCatalogMergedDB OLE DB Provider    Not Available
Microsoft ISAM 1.1 OLE DB Provider      4.0.3428.1
Microsoft OLE DB Provider For Data Mining Services      8.0.2039.0
MSDataShape     2.81.1117.0
Microsoft OLE DB Provider for Visual FoxPro     9.0.0.5815
OLE DB Provider for Microsoft Directory Services        5.1.2600.2180
MediaCatalogWebDB OLE DB Provider       Not Available
Microsoft OLE DB DM Enumerator  8.0.2039.0
Microsoft OLE DB Provider for OLAP Services 8.0 8.0.2216.0
Microsoft OLE DB Provider for OLAP Services 8.0 8.0.2216.0
Microsoft OLE DB Provider for Internet Publishing       11.0.6715.60
SAP BW OLE DB Provider  3.5.1.635
SAP BW OLE DB Provider  3.5.1.635
Microsoft OLE DB Provider for ODBC Drivers      2.81.1117.0
Microsoft OLE DB Enumerator for ODBC Drivers    2.81.1117.0
Microsoft OLE DB Provider for Outlook Search    1.0.0.3723
Microsoft Jet 4.0 OLE DB Provider       4.0.9502.0
Microsoft OLE DB Enumerator for SQL Server      2000.85.1117.0
Microsoft OLE DB Simple Provider        2.81.1117.0
Microsoft OLE DB Provider for Oracle    2.81.1117.0
Microsoft OLE DB Provider for Indexing Service  5.1.2600.2935

----------------------------------------
ODBC DRIVERS
Name    SQL Server
File    SQLSRV32.dll
Date    04/08/2004 0:56:46
Version 2000.85.1117.0

Name    Microsoft Access Driver (*.mdb)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Microsoft Text Driver (*.txt; *.csv)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Microsoft Excel Driver (*.xls)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Microsoft dBase Driver (*.dbf)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Microsoft Paradox Driver (*.db )
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Microsoft Visual FoxPro Driver
File    vfpodbc.dll
Date    19/06/2003 12:05:04
Version 6.1.8630.1

Name    Microsoft FoxPro VFP Driver (*.dbf)
File    vfpodbc.dll
Date    19/06/2003 12:05:04
Version 6.1.8630.1

Name    Microsoft dBase VFP Driver (*.dbf)
File    vfpodbc.dll
Date    19/06/2003 12:05:04
Version 6.1.8630.1

Name    Microsoft Access-Treiber (*.mdb)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Microsoft Text-Treiber (*.txt; *.csv)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Microsoft Excel-Treiber (*.xls)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Microsoft dBase-Treiber (*.dbf)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Microsoft Paradox-Treiber (*.db )
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Microsoft Visual FoxPro-Treiber
File    vfpodbc.dll
Date    19/06/2003 12:05:04
Version 6.1.8630.1

Name    Driver do Microsoft Access (*.mdb)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Driver da Microsoft para arquivos texto (*.txt; *.csv)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Driver do Microsoft Excel(*.xls)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Driver do Microsoft dBase (*.dbf)
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Driver do Microsoft Paradox (*.db )
File    odbcjt32.dll
Date    04/08/2004 0:56:46
Version 4.0.6304.0

Name    Driver para o Microsoft Visual FoxPro
File    vfpodbc.dll
Date    19/06/2003 12:05:04
Version 6.1.8630.1

Name    Microsoft ODBC for Oracle
File    msorcl32.dll
Date    04/08/2004 0:56:44
Version 2.575.1117.0

Name    Ingres
File    caiiod32.dll
Date    07/07/1998 12:39:14
Version 2.80.0.21

Name    Microsoft FoxPro Driver (*.dbf)
File    odbcjt32.dll
Date    Not Available
Version Not Available

Name    Microsoft ODBC Driver for Oracle
File    MSORCL10.DLL
Date    Not Available
Version Not Available

Name    CR SQLBase
File    Not Available
Date    Not Available
Version Not Available

Name    CR Oracle7
File    Not Available
Date    Not Available
Version Not Available

Name    CR Sybase System 10
File    Not Available
Date    Not Available
Version Not Available

Name    CA-OpenIngres
File    caiiod32.dll
Date    07/07/1998 12:39:14
Version 2.80.0.21

Name    IBM DB2 ODBC DRIVER
File    DB2CLI.DLL
Date    Not Available
Version Not Available

----------------------------------------
ODBC CORE
Description     Administrator
Version 3.525.1117.0
File    C:\WINDOWS\system32\odbccp32.dll

Description     Control Panel Device
Version 3.525.1117.0
File    C:\WINDOWS\system32\odbccp32.cpl

Description     Control Panel Startup
Version 3.525.1117.0
File    C:\WINDOWS\system32\odbcad32.exe

Description     Cursor Library
Version 3.525.1117.0
File    C:\WINDOWS\system32\odbccr32.dll

Description     Driver Manager
Version 3.525.1117.0
File    C:\WINDOWS\system32\odbc32.dll

Description     Localized Resource DLL
Version 3.525.1117.0
File    C:\WINDOWS\system32\odbcint.dll

Description     Unicode Cursor Library
Version 3.525.1117.0
File    C:\WINDOWS\system32\odbccu32.dll

----------------------------------------
LANG
UI Language     0
Help Language   0
Install Language        1033
SKU Language    1033
Web Locale      0

----------------------------------------
MS OFFICCE 2003-ACCESS
Application name        Microsoft Access
Version 11.0
Build   8166
Product ID      70136-640-3675536-55076
Application path        C:\Program Files\Microsoft Office\OFFICE11\
Language        English (United States)
ADO version     2.8
VBA version     6.05
References      VBA, Access, stdole, DAO, ADODB, ADOX, JRO, Excel, MSComctlLib,
EXTRA, Office, Scripting, MSForms, VBIDE, Outlook
Database name   xPAC_DFT_XP.mde
Database path   D:\_moje\_APL\AC\ADB
Database size   9252.0 KB
Database create date    11/08/2008 9:51:47
Current user    pacadm
Jet version     4.0

----------------------------------------
JET-CORE
Description     Jet 2.x
Path    C:\WINDOWS\system32\MSRD2x35.dll
Version 3.50.3602.0

Description     Jet 3.5
Path    Not Available
Version

Description     ODBC
Path    Not Available
Version
----------------------------------------
----------------------------------------        





PACALA_BA said:
Hi   (MS ACCESS 2003, file format 2002/03)
i am using LARGE PROGRAM-(NOT-DATA) DATABASE MDB/MDE
MDB = cca. 15-18 MB, MDE = cca. 9MB
3 class modules 217 KB, 16 MODULES 5.05 MB, 3 REPORTS, 8 FORMS
Help,...There are PERMANET CRASHES(100 Reported to MICROSOFT) !!!!
I have tryed different setings
Compile on Demand,Backgroud compile,..but after some Time Crashes !!!
-------------------------------------
There are COMPILE ERRORS !!!!!!!!!!!!!!!
strSQL  = "select * from [" & lcTAble & "] where ...." & lcWhere & "...."
After compile, the string is <SHORTEN> !!!
CNN.Execute strSQL
Debug.print =
strSQL  = "select * from ["....<AND NOTHING !!!!>

----------------
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/community/en-us/default.mspx?mid=3d95....- Hide quoted text -

- Show quoted text -
 
B

BruceM

I cannot assess the lengthy error log you have sent, nor is it likely that
anybody here will be able to help with that. However, I need to tell you
that everything Aaron says should be ignored.

Regarding the compile error on this line:
strSQL = "select * from [" & lcTAble & "] where ...." & lcWhere & "...."

try taking the square brackets out of the string:

strSQL = "select * from " & [lcTAble] & " where ...." & lcWhere & "...."

For a more detailed response to the compile error you will probably need to
provide more of the code.

PACALA_BA said:
I am using SINGEL user Database MS ACCESS-2003
without large-data-tables, only Modules,forms,...
*************************************
There is since 01/2008 something WRONG...

eMAIL: (e-mail address removed)
*************************
this is Official Report to Microsoft from my PC:
Microsoft We are sorry for the inconvinience....

I does not have internet access on 10.213.52.132

IP: 10.213.52.132
---------------------------------------------
OFFICE-EVENTS(18/08/2008)
---------------------------------------------
Event Application Failure
Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 001ec79a
Date 18/08/2008 16:50:44

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 18/08/2008 17:53:45

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 9:30:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 15:13:07

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004bebf
Date 20/08/2008 16:50:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:15:47

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:18:29

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:23:58

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 17:44:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:45:53

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:51:48

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:54:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 12:18:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:45:50

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:48:30

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 13:03:21

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 13:45:01

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 17:51:22

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004ab9b
Date 21/08/2008 17:54:53

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 17:56:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 22/08/2008 9:40:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 22/08/2008 9:41:58

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 22/08/2008 10:37:45

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module msado15.dll
Module Version 2.81.1128.0
Module Stamp 45911e8b
Debug 0
Offset 00001595
Date 22/08/2008 11:55:44

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 22/08/2008 12:12:41

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 22/08/2008 12:13:41

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module msado15.dll
Module Version 2.81.1128.0
Module Stamp 45911e8b
Debug 0
Offset 00001595
Date 25/08/2008 12:44:26

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module msado15.dll
Module Version 2.81.1128.0
Module Stamp 45911e8b
Debug 0
Offset 00001595
Date 25/08/2008 12:45:31

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 13:15:20

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 13:26:04

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 13:53:26

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 13:54:57

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 13:57:05

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 14:51:44

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004abb6
Date 25/08/2008 14:56:21

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 15:39:31

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 16:40:59

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 001ec79a
Date 25/08/2008 16:43:39

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 16:47:22

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 16:54:49

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 25/08/2008 17:08:44
----------------------------------------
RDO CORE
Description MicrosoftRDO.rdoEngine2.0
File C:\WINDOWS\system32\MSRDO20.DLL
Version 6.00.8862

Description MicrosoftRDO.rdoQuery2.0
File C:\WINDOWS\system32\MSRDO20.DLL
Version 6.00.8862

Description MicrosoftRDO.rdoConnection2.0
File C:\WINDOWS\system32\MSRDO20.DLL
Version 6.00.8862
----------------------------------------
ADO CORE
Description ADOConnectObject.ADOConnectObject.7
File C:\Program Files\Common Files\Microsoft Shared\Visual Database
Tools\VDT70.DLL
Version 7.10.3077

Description ADODB.Command
File C:\Program Files\Common Files\System\ado\msado15.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description ADODB.Command
File C:\Program Files\Common Files\System\ado\msado15.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description ADOMD.Catalog
File C:\Program Files\Common Files\System\ado\msadomd.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description ADOR.Recordset
File C:\Program Files\Common Files\System\ado\msado15.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description ADOX.Catalog
File C:\Program Files\Common Files\System\ado\msadox.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)

Description RDS.DataControl
File C:\Program Files\Common Files\System\msadc\msadco.dll
Version 2.81.1124.0 (xpsp_sp2_gdr.060322-1613)

Description JRO.JetEngine
File C:\Program Files\Common Files\System\ado\msjro.dll
Version 2.81.1128.0 (xpsp_sp2_gdr.061226-0034)
----------------------------------------
JET CORE
Description Jet 2.x
Path C:\WINDOWS\system32\MSRD2x35.dll
Version 3.50.3602.0

Description Jet 3.5
Path Not Available
Version

Description ODBC
Path Not Available
Version

----------------------------------------
OLE DB
MediaCatalogDB OLE DB Provider Not Available
Microsoft OLE DB Provider for SQL Server 2000.85.1117.0
MediaCatalogMergedDB OLE DB Provider Not Available
Microsoft ISAM 1.1 OLE DB Provider 4.0.3428.1
Microsoft OLE DB Provider For Data Mining Services 8.0.2039.0
MSDataShape 2.81.1117.0
Microsoft OLE DB Provider for Visual FoxPro 9.0.0.5815
OLE DB Provider for Microsoft Directory Services 5.1.2600.2180
MediaCatalogWebDB OLE DB Provider Not Available
Microsoft OLE DB DM Enumerator 8.0.2039.0
Microsoft OLE DB Provider for OLAP Services 8.0 8.0.2216.0
Microsoft OLE DB Provider for OLAP Services 8.0 8.0.2216.0
Microsoft OLE DB Provider for Internet Publishing 11.0.6715.60
SAP BW OLE DB Provider 3.5.1.635
SAP BW OLE DB Provider 3.5.1.635
Microsoft OLE DB Provider for ODBC Drivers 2.81.1117.0
Microsoft OLE DB Enumerator for ODBC Drivers 2.81.1117.0
Microsoft OLE DB Provider for Outlook Search 1.0.0.3723
Microsoft Jet 4.0 OLE DB Provider 4.0.9502.0
Microsoft OLE DB Enumerator for SQL Server 2000.85.1117.0
Microsoft OLE DB Simple Provider 2.81.1117.0
Microsoft OLE DB Provider for Oracle 2.81.1117.0
Microsoft OLE DB Provider for Indexing Service 5.1.2600.2935

----------------------------------------
ODBC DRIVERS
Name SQL Server
File SQLSRV32.dll
Date 04/08/2004 0:56:46
Version 2000.85.1117.0

Name Microsoft Access Driver (*.mdb)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Text Driver (*.txt; *.csv)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Excel Driver (*.xls)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft dBase Driver (*.dbf)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Paradox Driver (*.db )
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Visual FoxPro Driver
File vfpodbc.dll
Date 19/06/2003 12:05:04
Version 6.1.8630.1

Name Microsoft FoxPro VFP Driver (*.dbf)
File vfpodbc.dll
Date 19/06/2003 12:05:04
Version 6.1.8630.1

Name Microsoft dBase VFP Driver (*.dbf)
File vfpodbc.dll
Date 19/06/2003 12:05:04
Version 6.1.8630.1

Name Microsoft Access-Treiber (*.mdb)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Text-Treiber (*.txt; *.csv)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Excel-Treiber (*.xls)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft dBase-Treiber (*.dbf)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Paradox-Treiber (*.db )
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Microsoft Visual FoxPro-Treiber
File vfpodbc.dll
Date 19/06/2003 12:05:04
Version 6.1.8630.1

Name Driver do Microsoft Access (*.mdb)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Driver da Microsoft para arquivos texto (*.txt; *.csv)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Driver do Microsoft Excel(*.xls)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Driver do Microsoft dBase (*.dbf)
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Driver do Microsoft Paradox (*.db )
File odbcjt32.dll
Date 04/08/2004 0:56:46
Version 4.0.6304.0

Name Driver para o Microsoft Visual FoxPro
File vfpodbc.dll
Date 19/06/2003 12:05:04
Version 6.1.8630.1

Name Microsoft ODBC for Oracle
File msorcl32.dll
Date 04/08/2004 0:56:44
Version 2.575.1117.0

Name Ingres
File caiiod32.dll
Date 07/07/1998 12:39:14
Version 2.80.0.21

Name Microsoft FoxPro Driver (*.dbf)
File odbcjt32.dll
Date Not Available
Version Not Available

Name Microsoft ODBC Driver for Oracle
File MSORCL10.DLL
Date Not Available
Version Not Available

Name CR SQLBase
File Not Available
Date Not Available
Version Not Available

Name CR Oracle7
File Not Available
Date Not Available
Version Not Available

Name CR Sybase System 10
File Not Available
Date Not Available
Version Not Available

Name CA-OpenIngres
File caiiod32.dll
Date 07/07/1998 12:39:14
Version 2.80.0.21

Name IBM DB2 ODBC DRIVER
File DB2CLI.DLL
Date Not Available
Version Not Available

----------------------------------------
ODBC CORE
Description Administrator
Version 3.525.1117.0
File C:\WINDOWS\system32\odbccp32.dll

Description Control Panel Device
Version 3.525.1117.0
File C:\WINDOWS\system32\odbccp32.cpl

Description Control Panel Startup
Version 3.525.1117.0
File C:\WINDOWS\system32\odbcad32.exe

Description Cursor Library
Version 3.525.1117.0
File C:\WINDOWS\system32\odbccr32.dll

Description Driver Manager
Version 3.525.1117.0
File C:\WINDOWS\system32\odbc32.dll

Description Localized Resource DLL
Version 3.525.1117.0
File C:\WINDOWS\system32\odbcint.dll

Description Unicode Cursor Library
Version 3.525.1117.0
File C:\WINDOWS\system32\odbccu32.dll

----------------------------------------
LANG
UI Language 0
Help Language 0
Install Language 1033
SKU Language 1033
Web Locale 0

----------------------------------------
MS OFFICCE 2003-ACCESS
Application name Microsoft Access
Version 11.0
Build 8166
Product ID 70136-640-3675536-55076
Application path C:\Program Files\Microsoft Office\OFFICE11\
Language English (United States)
ADO version 2.8
VBA version 6.05
References VBA, Access, stdole, DAO, ADODB, ADOX, JRO, Excel, MSComctlLib,
EXTRA, Office, Scripting, MSForms, VBIDE, Outlook
Database name xPAC_DFT_XP.mde
Database path D:\_moje\_APL\AC\ADB
Database size 9252.0 KB
Database create date 11/08/2008 9:51:47
Current user pacadm
Jet version 4.0

----------------------------------------
JET-CORE
Description Jet 2.x
Path C:\WINDOWS\system32\MSRD2x35.dll
Version 3.50.3602.0

Description Jet 3.5
Path Not Available
Version

Description ODBC
Path Not Available
Version
----------------------------------------
----------------------------------------








PACALA_BA said:
Hi (MS ACCESS 2003, file format 2002/03)
i am using LARGE PROGRAM-(NOT-DATA) DATABASE MDB/MDE
MDB = cca. 15-18 MB, MDE = cca. 9MB
3 class modules 217 KB, 16 MODULES 5.05 MB, 3 REPORTS, 8 FORMS
Help,...There are PERMANET CRASHES(100 Reported to MICROSOFT) !!!!
I have tryed different setings
Compile on Demand,Backgroud compile,..but after some Time Crashes !!!
-------------------------------------
There are COMPILE ERRORS !!!!!!!!!!!!!!!
strSQL = "select * from [" & lcTAble & "] where ...." & lcWhere & "...."
After compile, the string is <SHORTEN> !!!
CNN.Execute strSQL
Debug.print =
strSQL = "select * from ["....<AND NOTHING !!!!>


----------------
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...-9337-eb7d4b6deab4&dg=microsoft.public.access
 
P

PACALA_BA

Hi, it is ALLWAYS the same TYPE of ERROR

strSQL = str1 & str2 & str3 & ....
cnn.execeute strSQL ( strSQL = str1 & str2 AND NOTHING !!!)
in the Debugger but i see the WHOLE string strSQL
Lotion: i make an PSEUDO-LINE-EDIT, Compile-ALL, and it works !!!
The values of str1,str2, are CORRECT !!!

Problem: I CAN-NOT make myApp.MDE on the FIRST TRY !!!!
*****************************************************
Reason: Memory Problem, Microsoft Wrong compiler,....??
Since 01/2008 is something WRONG....

This is an LONG running App( run=20 Hours), it works OK,
But i must implementate an TEST-RUN, for catching this
UNBELIEVABLE-ERRORS !!!!

I Allways create a new Database before creating an MDE.
Full Export, New MDB,Import, Compile-ALL
(Compile on Demand=FALSE)
Compact & Repair, Make MDE

But WHAT says MICROSOFT ????
it is SINGEL-USER Program MDE-database SIZE ~6MB
I am now really ANGRY about this ...

I have about 10 CRASHES dailly.
My Opinion it is this WRONG COMPILER.
Because i CAN-NOT test ALL with this TEST-RUN
i does not have on volkswagen-PC Internet access.

eMAIL:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
*****************************************************
BruceM said:
I cannot assess the lengthy error log you have sent, nor is it likely that
anybody here will be able to help with that. However, I need to tell you
that everything Aaron says should be ignored.

Regarding the compile error on this line:
strSQL = "select * from [" & lcTAble & "] where ...." & lcWhere & "...."

try taking the square brackets out of the string:

strSQL = "select * from " & [lcTAble] & " where ...." & lcWhere & "...."

For a more detailed response to the compile error you will probably need to
provide more of the code.

PACALA_BA said:
I am using SINGEL user Database MS ACCESS-2003
without large-data-tables, only Modules,forms,...
*************************************
There is since 01/2008 something WRONG...

eMAIL: (e-mail address removed)
*************************
this is Official Report to Microsoft from my PC:
Microsoft We are sorry for the inconvinience....

I does not have internet access on 10.213.52.132

IP: 10.213.52.132
---------------------------------------------
OFFICE-EVENTS(18/08/2008)
---------------------------------------------
Event Application Failure
Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 001ec79a
Date 18/08/2008 16:50:44

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 18/08/2008 17:53:45

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 9:30:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 15:13:07

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004bebf
Date 20/08/2008 16:50:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:15:47

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:18:29

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:23:58

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 17:44:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:45:53

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:51:48

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:54:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 12:18:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:45:50

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:48:30

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 13:03:21

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 13:45:01

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 17:51:22

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004ab9b
Date 21/08/2008 17:54:53

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 17:56:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
 
B

BruceM

Without seeing the code it is not possible to know, or even to guess, the
source of the compile error. For instance, I don't know what cnn is. For
another I can't tell if str1 & str2 etc. will give you a string that you can
execute.

PACALA_BA said:
Hi, it is ALLWAYS the same TYPE of ERROR

strSQL = str1 & str2 & str3 & ....
cnn.execeute strSQL ( strSQL = str1 & str2 AND NOTHING !!!)
in the Debugger but i see the WHOLE string strSQL
Lotion: i make an PSEUDO-LINE-EDIT, Compile-ALL, and it works !!!
The values of str1,str2, are CORRECT !!!

Problem: I CAN-NOT make myApp.MDE on the FIRST TRY !!!!
*****************************************************
Reason: Memory Problem, Microsoft Wrong compiler,....??
Since 01/2008 is something WRONG....

This is an LONG running App( run=20 Hours), it works OK,
But i must implementate an TEST-RUN, for catching this
UNBELIEVABLE-ERRORS !!!!

I Allways create a new Database before creating an MDE.
Full Export, New MDB,Import, Compile-ALL
(Compile on Demand=FALSE)
Compact & Repair, Make MDE

But WHAT says MICROSOFT ????
it is SINGEL-USER Program MDE-database SIZE ~6MB
I am now really ANGRY about this ...

I have about 10 CRASHES dailly.
My Opinion it is this WRONG COMPILER.
Because i CAN-NOT test ALL with this TEST-RUN
i does not have on volkswagen-PC Internet access.

eMAIL:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
*****************************************************
BruceM said:
I cannot assess the lengthy error log you have sent, nor is it likely
that
anybody here will be able to help with that. However, I need to tell you
that everything Aaron says should be ignored.

Regarding the compile error on this line:
strSQL = "select * from [" & lcTAble & "] where ...." & lcWhere & "...."

try taking the square brackets out of the string:

strSQL = "select * from " & [lcTAble] & " where ...." & lcWhere & "...."

For a more detailed response to the compile error you will probably need
to
provide more of the code.

PACALA_BA said:
I am using SINGEL user Database MS ACCESS-2003
without large-data-tables, only Modules,forms,...
*************************************
There is since 01/2008 something WRONG...

eMAIL: (e-mail address removed)
*************************
this is Official Report to Microsoft from my PC:
Microsoft We are sorry for the inconvinience....

I does not have internet access on 10.213.52.132

IP: 10.213.52.132
---------------------------------------------
OFFICE-EVENTS(18/08/2008)
---------------------------------------------
Event Application Failure
Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 001ec79a
Date 18/08/2008 16:50:44

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 18/08/2008 17:53:45

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 9:30:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 15:13:07

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004bebf
Date 20/08/2008 16:50:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:15:47

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:18:29

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:23:58

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 17:44:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:45:53

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:51:48

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:54:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 12:18:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:45:50

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:48:30

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 13:03:21

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 13:45:01

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 17:51:22

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004ab9b
Date 21/08/2008 17:54:53

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 17:56:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
 
P

PACALA_BA

cnn is an CONNECTION
there is DIFFERENCE WITH RUN AND DEBUG
i run the code:
CONNECTION.execute strSQL
than comes error-message with WRONG-STRING CONTENTS !!!!!
than i go to Debugger and in the Immediate window is the Command strSQL =OK
i must PSEUDO-EDIT this line, Compile-ALL, and Continue...
WITHOUT-ERRORS !!!!!

ALL THE THINGS ARE OK, ONLY I MUST MAKE THIS RE-COMPILE !!!!
**************************************************

BruceM said:
Without seeing the code it is not possible to know, or even to guess, the
source of the compile error. For instance, I don't know what cnn is. For
another I can't tell if str1 & str2 etc. will give you a string that you can
execute.

PACALA_BA said:
Hi, it is ALLWAYS the same TYPE of ERROR

strSQL = str1 & str2 & str3 & ....
cnn.execeute strSQL ( strSQL = str1 & str2 AND NOTHING !!!)
in the Debugger but i see the WHOLE string strSQL
Lotion: i make an PSEUDO-LINE-EDIT, Compile-ALL, and it works !!!
The values of str1,str2, are CORRECT !!!

Problem: I CAN-NOT make myApp.MDE on the FIRST TRY !!!!
*****************************************************
Reason: Memory Problem, Microsoft Wrong compiler,....??
Since 01/2008 is something WRONG....

This is an LONG running App( run=20 Hours), it works OK,
But i must implementate an TEST-RUN, for catching this
UNBELIEVABLE-ERRORS !!!!

I Allways create a new Database before creating an MDE.
Full Export, New MDB,Import, Compile-ALL
(Compile on Demand=FALSE)
Compact & Repair, Make MDE

But WHAT says MICROSOFT ????
it is SINGEL-USER Program MDE-database SIZE ~6MB
I am now really ANGRY about this ...

I have about 10 CRASHES dailly.
My Opinion it is this WRONG COMPILER.
Because i CAN-NOT test ALL with this TEST-RUN
i does not have on volkswagen-PC Internet access.

eMAIL:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
*****************************************************
BruceM said:
I cannot assess the lengthy error log you have sent, nor is it likely
that
anybody here will be able to help with that. However, I need to tell you
that everything Aaron says should be ignored.

Regarding the compile error on this line:
strSQL = "select * from [" & lcTAble & "] where ...." & lcWhere & "...."

try taking the square brackets out of the string:

strSQL = "select * from " & [lcTAble] & " where ...." & lcWhere & "...."

For a more detailed response to the compile error you will probably need
to
provide more of the code.

I am using SINGEL user Database MS ACCESS-2003
without large-data-tables, only Modules,forms,...
*************************************
There is since 01/2008 something WRONG...

eMAIL: (e-mail address removed)
*************************
this is Official Report to Microsoft from my PC:
Microsoft We are sorry for the inconvinience....

I does not have internet access on 10.213.52.132

IP: 10.213.52.132
---------------------------------------------
OFFICE-EVENTS(18/08/2008)
---------------------------------------------
Event Application Failure
Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 001ec79a
Date 18/08/2008 16:50:44

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 18/08/2008 17:53:45

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 9:30:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 15:13:07

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004bebf
Date 20/08/2008 16:50:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:15:47

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:18:29

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:23:58

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 17:44:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:45:53

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:51:48

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:54:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 12:18:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:45:50

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:48:30

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 13:03:21

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 13:45:01
 
P

PACALA_BA

My
Contact
Messanger: (e-mail address removed)
eMAIL: (e-mail address removed) (HOME)
eMAIL: (e-mail address removed) (OFFICE)


PACALA_BA said:
cnn is an CONNECTION
there is DIFFERENCE WITH RUN AND DEBUG
i run the code:
CONNECTION.execute strSQL
than comes error-message with WRONG-STRING CONTENTS !!!!!
than i go to Debugger and in the Immediate window is the Command strSQL =OK
i must PSEUDO-EDIT this line, Compile-ALL, and Continue...
WITHOUT-ERRORS !!!!!

ALL THE THINGS ARE OK, ONLY I MUST MAKE THIS RE-COMPILE !!!!
**************************************************

BruceM said:
Without seeing the code it is not possible to know, or even to guess, the
source of the compile error. For instance, I don't know what cnn is. For
another I can't tell if str1 & str2 etc. will give you a string that you can
execute.

PACALA_BA said:
Hi, it is ALLWAYS the same TYPE of ERROR

strSQL = str1 & str2 & str3 & ....
cnn.execeute strSQL ( strSQL = str1 & str2 AND NOTHING !!!)
in the Debugger but i see the WHOLE string strSQL
Lotion: i make an PSEUDO-LINE-EDIT, Compile-ALL, and it works !!!
The values of str1,str2, are CORRECT !!!

Problem: I CAN-NOT make myApp.MDE on the FIRST TRY !!!!
*****************************************************
Reason: Memory Problem, Microsoft Wrong compiler,....??
Since 01/2008 is something WRONG....

This is an LONG running App( run=20 Hours), it works OK,
But i must implementate an TEST-RUN, for catching this
UNBELIEVABLE-ERRORS !!!!

I Allways create a new Database before creating an MDE.
Full Export, New MDB,Import, Compile-ALL
(Compile on Demand=FALSE)
Compact & Repair, Make MDE

But WHAT says MICROSOFT ????
it is SINGEL-USER Program MDE-database SIZE ~6MB
I am now really ANGRY about this ...

I have about 10 CRASHES dailly.
My Opinion it is this WRONG COMPILER.
Because i CAN-NOT test ALL with this TEST-RUN
i does not have on volkswagen-PC Internet access.

eMAIL:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
*****************************************************
:

I cannot assess the lengthy error log you have sent, nor is it likely
that
anybody here will be able to help with that. However, I need to tell you
that everything Aaron says should be ignored.

Regarding the compile error on this line:
strSQL = "select * from [" & lcTAble & "] where ...." & lcWhere & "...."

try taking the square brackets out of the string:

strSQL = "select * from " & [lcTAble] & " where ...." & lcWhere & "...."

For a more detailed response to the compile error you will probably need
to
provide more of the code.

I am using SINGEL user Database MS ACCESS-2003
without large-data-tables, only Modules,forms,...
*************************************
There is since 01/2008 something WRONG...

eMAIL: (e-mail address removed)
*************************
this is Official Report to Microsoft from my PC:
Microsoft We are sorry for the inconvinience....

I does not have internet access on 10.213.52.132

IP: 10.213.52.132
---------------------------------------------
OFFICE-EVENTS(18/08/2008)
---------------------------------------------
Event Application Failure
Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 001ec79a
Date 18/08/2008 16:50:44

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 18/08/2008 17:53:45

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 9:30:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 15:13:07

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004bebf
Date 20/08/2008 16:50:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:15:47

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:18:29

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:23:58

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 17:44:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:45:53

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:51:48

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:54:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 12:18:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:45:50

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:48:30

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
 
B

BruceM

Sorry, I don't think I can help. I don't think anybody can without seeing
all of the code. The string contents in the error message (whatever it is)
are most likely the string you have assembled.

PACALA_BA said:
cnn is an CONNECTION
there is DIFFERENCE WITH RUN AND DEBUG
i run the code:
CONNECTION.execute strSQL
than comes error-message with WRONG-STRING CONTENTS !!!!!
than i go to Debugger and in the Immediate window is the Command strSQL
=OK
i must PSEUDO-EDIT this line, Compile-ALL, and Continue...
WITHOUT-ERRORS !!!!!

ALL THE THINGS ARE OK, ONLY I MUST MAKE THIS RE-COMPILE !!!!
**************************************************

BruceM said:
Without seeing the code it is not possible to know, or even to guess, the
source of the compile error. For instance, I don't know what cnn is.
For
another I can't tell if str1 & str2 etc. will give you a string that you
can
execute.

PACALA_BA said:
Hi, it is ALLWAYS the same TYPE of ERROR

strSQL = str1 & str2 & str3 & ....
cnn.execeute strSQL ( strSQL = str1 & str2 AND NOTHING !!!)
in the Debugger but i see the WHOLE string strSQL
Lotion: i make an PSEUDO-LINE-EDIT, Compile-ALL, and it works !!!
The values of str1,str2, are CORRECT !!!

Problem: I CAN-NOT make myApp.MDE on the FIRST TRY !!!!
*****************************************************
Reason: Memory Problem, Microsoft Wrong compiler,....??
Since 01/2008 is something WRONG....

This is an LONG running App( run=20 Hours), it works OK,
But i must implementate an TEST-RUN, for catching this
UNBELIEVABLE-ERRORS !!!!

I Allways create a new Database before creating an MDE.
Full Export, New MDB,Import, Compile-ALL
(Compile on Demand=FALSE)
Compact & Repair, Make MDE

But WHAT says MICROSOFT ????
it is SINGEL-USER Program MDE-database SIZE ~6MB
I am now really ANGRY about this ...

I have about 10 CRASHES dailly.
My Opinion it is this WRONG COMPILER.
Because i CAN-NOT test ALL with this TEST-RUN
i does not have on volkswagen-PC Internet access.

eMAIL:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
*****************************************************
:

I cannot assess the lengthy error log you have sent, nor is it likely
that
anybody here will be able to help with that. However, I need to tell
you
that everything Aaron says should be ignored.

Regarding the compile error on this line:
strSQL = "select * from [" & lcTAble & "] where ...." & lcWhere &
"...."

try taking the square brackets out of the string:

strSQL = "select * from " & [lcTAble] & " where ...." & lcWhere &
"...."

For a more detailed response to the compile error you will probably
need
to
provide more of the code.

I am using SINGEL user Database MS ACCESS-2003
without large-data-tables, only Modules,forms,...
*************************************
There is since 01/2008 something WRONG...

eMAIL: (e-mail address removed)
*************************
this is Official Report to Microsoft from my PC:
Microsoft We are sorry for the inconvinience....

I does not have internet access on 10.213.52.132

IP: 10.213.52.132
---------------------------------------------
OFFICE-EVENTS(18/08/2008)
---------------------------------------------
Event Application Failure
Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 001ec79a
Date 18/08/2008 16:50:44

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 18/08/2008 17:53:45

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 9:30:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 15:13:07

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0004bebf
Date 20/08/2008 16:50:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:15:47

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:18:29

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:23:58

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 17:44:18

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 00180b29
Date 20/08/2008 17:45:53

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:51:48

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 20/08/2008 17:54:55

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 12:18:19

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:45:50

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 12:48:30

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module vbe6.dll
Module Version 6.5.10.24
Module Stamp 464105f1
Debug 0
Offset 0001f4d7
Date 21/08/2008 13:03:21

Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 21/08/2008 13:45:01
 
P

PACALA_BA

WHAT SAYS MICROSOFT
for this ALL-CRASHES .....
I must ALLWAYS, Rebuild my Database.
Full Export to Backup Database
(I make NOT export to TXT)
Create New Database
Full Import from Backup Database

Allways (70-90 %) It is Problem From CRASH-Database
create the new ONE, on the FIRST TRY.
*****************************
there is MISSING an TOOL IN ACCESS:
FULL-REBUILD-YOUR-DATABASE (ful export, new ONE, and Import)
(for removing this Bugs)
*****************************
I have also Reported FORMS 2.0 CRASH,
when Form.height <= 0.
This works now O.K.
Thank for Microsoft.


Event Application Failure
Bucket ID Not Available
Bucket Table Not Available
Application msaccess.exe
Application Version 11.0.8166.0
Application Stamp 46437912
Module unknown
Module Version 0.0.0.0
Module Stamp 00000000
Debug 0
Offset 00000000
Date 20/08/2008 17:44:18
and so on ( see down...)
---------------------------------------------------------------------------
 
P

PACALA_BA

Why should i report to microsoft...
we are sorry for the inconvinience..

I want to participate on this errors....
because i have reported NEW 100 crashes...

what is the result from this Crash-reports...???
 

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

Top