[AccessD] A2k - BE corruption???

Carlos Alberto Alves caa at highway.com.br
Mon Nov 3 18:21:57 CST 2003


Dear Mates:
I would like to have your opinion on this matter. I developed an A2k 
database system with three identical FE's and one BE. It has data from 
jan2001 to now. Upon executing a simple select query I noticed that I 
could not retrieve any records from 2002. The same query executed on a BE 
backup copy from jul2003 returned all due records.
Is this a BE corruption??? I tried “Compact and repair...”, JetComp and 
import all tables to a new BE with no better results.
Things that called my attention:
1- I use Jet 4.0 SP6 and my client uses something older than SP3;
2- I use Access 2000/Office 2000 and my client uses Access 2000/Office 97.
Thanks for any input,
-- 
**************************************
* Carlos Alberto Alves               *
* Child Neurologist                  *
* Systems Analyst/Programmer         *
* Rio de Janeiro, Brazil             *
* mailto:caa at highway.com.br          *
**************************************


More information about the AccessD mailing list