MastercafeCTV
mastercafe at ctv.es
Tue Jan 6 12:07:36 CST 2004
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