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 * **************************************