[AccessD] MDB Stability vs Perfomance

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



More information about the AccessD mailing list