[AccessD] MDB Stability vs Perfomance

Charlotte Foust cfoust at infostatsystems.com
Mon Jan 5 20:02:07 CST 2004


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


More information about the AccessD mailing list