[AccessD] MDB Stability vs Perfomance

Charlotte Foust cfoust at infostatsystems.com
Tue Jan 6 14:54:01 CST 2004


There shouldn't be any performance difference using a 2000 data file instead of a 2002 data file.    ADO is going to provide slower access in some cases than DAO but there's no reason you can't use DAO in AXP.

Charlotte Foust

-----Original Message-----
From: MastercafeCTV [mailto:mastercafe at ctv.es] 
Sent: Tuesday, January 06, 2004 12:15 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] MDB Stability vs Perfomance


Then I think that is better mainten the Data Files on A2k format and the applications on AXP format. I suposse that the perfomance between A2k & AXP formats is not the format but yes the ADO/DAO access from the FE application.

Juan Menendez


===========================================
MASTERCAFE SL - NIF B-82.617.614
www.mastercafe.com
Deleg. Asturias 
Tel 985.88.49.44 / 627.531.764
Fax 627.500.205
info at mastercafe.com
juan at mastercafe.com
Deleg. Madrid
Tel 627.474.285
cecilia at mastercafe.com ===========================================


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: martes, 06 de enero de 2004 20:16
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] MDB Stability vs Perfomance


The 2002 file format contains a system file, MSysAccessStorage, that doesn't exist in the 2000 format.  This table NEVER compacts, it just keeps growing. The only cure is to import all the non-system objects into a new database.  

Charlotte Foust

-----Original Message-----
From: MastercafeCTV [mailto:mastercafe at ctv.es] 
Sent: Tuesday, January 06, 2004 10:08 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] MDB Stability vs Perfomance


The front end applications are all on AXP, only the data files was in A2k and now in AXP. What is the unrecoverable bloat?? Colud be the problem for our data files? ... Are this the problem that we find and need repair ?

Juan Menendez

===========================================
MASTERCAFE SL - NIF B-82.617.614
www.mastercafe.com
Deleg. Asturias 
Tel 985.88.49.44 / 627.531.764
Fax 627.500.205
info at mastercafe.com
juan at mastercafe.com
Deleg. Madrid
Tel 627.474.285
cecilia at mastercafe.com ===========================================


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: martes, 06 de enero de 2004 17:05
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] MDB Stability vs Perfomance


Access 2000 can't open 2002 format files.  Is that the nature of the error message, corrupted database file?  Or are you talking about problems you had when using the 2000 file format for the datafile with an AXP front end?  I prefer to use the 2000 format for data files to avoid the unrecoverable bloat issue in 2002 format.  We haven't had any problems with them in our commercial applications.  You do need to make sure that all your machines have the same service packs of Office XP and Jet installed however.

Maybe if you give more specific information about the kind of error messages you're getting, someone else will have some ideas.

Charlotte Foust

-----Original Message-----
From: MastercafeCTV [mailto:mastercafe at ctv.es] 
Sent: Monday, January 05, 2004 8:56 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] MDB Stability vs Perfomance


Our main programs are AXP at this moment, all in MDE format, but on A2k we have the error message to screen and on AXP some of them close the Access in the computer (same problem on Runtime version or AXP standar). The data container was A2k just august'03 and then change to AXP then beginning the problems... Too high size for some MDB that compacted have 4 mb and working more than 18 mb. At this moment all Applications and data are AXP (2002) format... But with corruption problems.

Juan Menendez


===========================================
MASTERCAFE SL - NIF B-82.617.614
www.mastercafe.com
Deleg. Asturias 
Tel 985.88.49.44 / 627.531.764
Fax 627.500.205
info at mastercafe.com
juan at mastercafe.com
Deleg. Madrid
Tel 627.474.285
cecilia at mastercafe.com ===========================================


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: martes, 06 de enero de 2004 3:02
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] MDB Stability vs Perfomance


I'm sorry, but it isn't clear to me whether you're talking about the file format or the version of Access you're using.  If you have mixed versions updating the same database, you're likely to have corruption problems.  What is your main program written in?

Charlotte Foust

-----Original Message-----
From: MastercafeCTV [mailto:mastercafe at ctv.es] 
Sent: Monday, January 05, 2004 5:16 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] MDB Stability vs Perfomance


The MDE problem is correct, we saw months ago. And we have installed the 3 patches for AXP (SP-1 , Patch Office XP 2, and secur. Patches) but the most significant problem is our main program STEEL TPV that uses a STEELDAT.MDB only for data, this MDB have no problem with A2k format, and the last september change to AXP format, from this we repeat Compact & Repair every month.

Juan Menendez


===========================================
MASTERCAFE SL - NIF B-82.617.614
www.mastercafe.com
Deleg. Asturias 
Tel 985.88.49.44 / 627.531.764
Fax 627.500.205
info at mastercafe.com
juan at mastercafe.com
Deleg. Madrid
Tel 627.474.285
cecilia at mastercafe.com ===========================================


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: martes, 06 de enero de 2004 2:08
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] MDB Stability vs Perfomance


I haven't found AXP SP-1 to be any less stable or have more problems than A2k.  Be aware, though, that if you switch to AXP, you will only be able to create an MDE in 2002 format, not in 2000 format.

Charlotte Foust

-----Original Message-----
From: MastercafeCTV [mailto:mastercafe at ctv.es] 
Sent: Monday, January 05, 2004 4:50 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] MDB Stability vs Perfomance


Hi group, on the last year we are changing all our applications from Access 2k to Access XP, but at this moment we have one problem on all applications that it take more time for maintenance and repair.

MDB from Access 2k are much more stable VS MDB XP  (better A2k)
MDB from Access 2k have similar speed vs MDB XP		(better A2k)
Applications on A2k are much more stable vs MDB/MDE XP (better A2k) MDB A2k corrupted not always can be repaired vs MDB XP always was be
repaired	(Better AXP)

On the last version for application FE we obtain sometimes a reset error, I
explain: close tha Access XP with application without any error message or similar, simply close and then you can open renew.

Anyone knows how to solve this problems wih AXP?? Is better program with AXP on MDB format A2k?? Is the AXP less stable than A2k??

Thanks in advance

Juan Menéndez


===========================================
MASTERCAFE SL - NIF B-82.617.614
www.mastercafe.com
Deleg. Asturias 
Tel 985.88.49.44 / 627.531.764
Fax 627.500.205
info at mastercafe.com
juan at mastercafe.com
Deleg. Madrid
Tel 627.474.285
cecilia at mastercafe.com ===========================================

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list