Permanet CRASHES with LARGE DATABASE MDE(9MB)

P

PACALA_BA

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 [" & lcTAbleNAme & "] where ...." & lcWhere & "...."
After compile, the string is SHORTEN
CNN.Execute strSQL
Debug.print =
strSQL = "select * from ["
 
J

Jerry Whittle

A

a a r o n . k e m p f

if you're experiencing data corruption- you'd be best off if you moved
to SQL Server

SQL Server doesn't corrupt itself; and Jet just wasn't designed for
multiple users.
Jet doesn't even support half the networks in the real world.

File, New, Project (existing data) in Access 2003
 
P

PACALA_BA

My database is NOT REALLLY CORRUPT.
After Rebuilding and Compiling it works ON 80-100 %...
Problem is After TOO MANY COMPILING...
then comes ACCESS-CRASH
I can then STOP the Main Form Start
All Rebuilding
and it works fine.
My Opinion there must be something
WRONG in Microsoft-Compile background
This DECOMPILE command works NOT !


Jerry Whittle said:
Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

With all those crashed, I would worry that there is something wrong with the
network if the database is stored out in a network folder.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


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 [" & lcTAbleNAme & "] where ...." & lcWhere & "...."
After compile, the string is SHORTEN
CNN.Execute strSQL
Debug.print =
strSQL = "select * from ["
Click to expand...
Click to expand...
 
L

Larry Linson

a a r o n . k e m p f @ g m a i l . c o m said:
if you're experiencing data corruption- you'd be
best off if you moved to SQL Server
Click to expand...

Mr. Kempf, you are again advising a major change on the basis of your bias,
not on sufficient information from the user to diagnose the reasons for the
problem.
SQL Server doesn't corrupt itself;
Click to expand...

SQL Server can become corrupt, also. That happens, at times, for different
reasons, and, at times, for similar reasons, but it does happen. If a Jet
database is being corrupted due to dropped network connections, then that
situation possibly could be alleviated by replacing the back end database
with an SQL Server database. But, unless there is an uncorrected defect,
neither Jet nor SQL Server "corrupts itself."
and Jet just wasn't designed for
multiple users.
Click to expand...

Access and Jet work very nicely with multiple users... having multiple users
logged in to the same copy of the front end is not a good idea for a
database with either SQL Server or Jet. Each user should have their own copy
of the front end... this is independent of the back end database in use.
Jet doesn't even support half the networks in the
real world.
Click to expand...

Database engines do not "support" networks, though they often are executed
in network environments.
File, New, Project (existing data) in Access 2003
Click to expand...

This is not any longer the approach recommended by the Access team at
Microsoft for supporting server databases with Access. The approach of
using Access databases (MDB/ACCDB, Jet/ACE, and ODBC) is now recommended
because it is stable, simpler, and more secure than using Access Data
Projects (ADP).

Larry Linson
Microsoft Office Access MVP
 
A

a a r o n . k e m p f

there's no such thing as 'someone that should stay with jet'

I'm not rushing to judgement-- there is no decision other than JET
FUCKING SUCKS BECAUSE IT CORRUPTS. BECAUSE IT CRASHES.

Stop making excuses; if your database crashes, stop trying to talk
people OUT of moving to SQL Server
that's the problem-- if you guys wouldn't spread misinformation; I
wouldn't have to correct you guys.

SQL Server is simpler BECAUSE IT JUST WORKS
 
P

PACALA_BA

I am using SINGEL user Database MS ACCESS-2003
*************************************
There is since 01/2008 something WRONG...

eMAIL: (e-mail address removed)
*************************
this is Official Report to Microsoft from my PC:
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 !!!!>
Click to expand...
 
L

Larry Linson

Mr. Kempf, the facts of the matter are: (1) Microsoft packages Access with
default-installed Jet and ACE database engines; (2) Microsoft expects most
users to use the default engines; (3) Microsoft is correct that, in most
cases, those default engines are perfectly adequate for the uses to which
Access is put; (4) Microsoft is also correct that, in most cases, those
default engines are perfectly adequate for the size of multiuser groups with
which Access databases are used; (5) in addition, however, for those
situations in which that is not the case, Microsoft provides the capability,
in several ways, for users to take advantage of server databases (and some
desktop databases) when that capability is needed, (6) but only you, sir,
are so obsessed that you think that server capability, and, at that, the
particular server DB that you know, is always needed, and the particular
client database format that you prefer. And, (7) it clearly is distressing
to you and brings you to an agitated state -- evidenced by the fact that you
resort to shouting (ALL CAPS), untruths, vulgarity, cliches, and mottos.

Perhaps you would be happier, and less agitated, if you participated in
newsgroups where most of the questions were not about Access and Jet or
Access and ACE. Are you aware that in this same group of
Microsoft-sponsored newsgroups there is a newsgroup,
microsoft.public.access.adp.sqlserver, and another newsgroup,
microsoft.public.access.odbc.clientsvr, where your knowledge of .ADP, MS SQL
Server, and your observations on ODBC, might be of benefit in solving
posters' problems instead of just engaging in fruitless argument?

I am certain you are sufficiently intelligent to realize that your rants in
this newsgroup are unlikely to have led even a single poster to convert to
MS SQL Server. Because had they done so, and been happy with it, you know
they would have posted back thanking you and telling you how your advice had
solved their problem and saved them time and effort.

Larry Linson
Microsoft Office Access MVP


message
there's no such thing as 'someone that should stay with jet'

I'm not rushing to judgement-- there is no decision other than JET
FUCKING SUCKS BECAUSE IT CORRUPTS. BECAUSE IT CRASHES.

Stop making excuses; if your database crashes, stop trying to talk
people OUT of moving to SQL Server
that's the problem-- if you guys wouldn't spread misinformation; I
wouldn't have to correct you guys.

SQL Server is simpler BECAUSE IT JUST WORKS
 
A

a a r o n . k e m p f

ADP was the most popular format for most of this decade. Go File, New,
and count the options for ADP vs MDB.
DAO wasn't included with Office, Windows or MDAC for most of a decade.

Jet is not the default engine.

It is an obsolete engine.
And just because Microsoft brought 'Access back down to the lowest
common denominator' that does NOT mean that it is a reliable platform.

SQL Server is _EASIER_ development and _BETTER_ development because
SQL Server inherently supports CODE REUSE.

Jet does not.

I don't think that you can sit there and say that I am not
intelligent-- just because i _CHOOSE_ to use the worlds most popular
database.

NOBODY EVERY GOT FIRED FOR USING SQL SERVER.
and PLENTY of people have gotten fired for using Jet.

I got fired back in 2001 because I liked Jet. I wasn't adapting to
the needs of my company.

Ever since then-- I'll be damned if I let people sit by and spread
misinformation about SQL Server.
 

Ask a Question

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

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

Ask a Question

Similar Threads

ACCESS 2003 CRASHES PERMANENT !!! 4
COMPILER WRONG !!! 46
CRASHES Result-1- Access large programm-MDB (SIZE~15MB) 0
MDE dabase convert error 3
Access Database Crashes When Creating An .MDE File 2
ACCESS 2003 CRASH EXAMPLES 9
Creeating Access MDE with ADE installed fails 1
Large doc with many Excel links crashes Word 1

Top