By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,461 Members | 1,108 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,461 IT Pros & Developers. It's quick & easy.

convert from 2000 to 97

P: n/a
I have a system that we have had running for many years. We keep our
file in 2000 format, but develop in 2003 environment... ussually we
use our test computer with 2000 loaded to convert back to 97 and then
open our 97 test computer and fix references etc. recently once we
convert to 97 we can open the file but many forms are corrupt. Does
any one have any advice on this?

Tony
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The backward conversion process should work okay. I'm guessing that the
corruption is already present, and is just being exposed by the conversion.

To avoid the corruption:
1. Make sure all your databases have Name AutoCorrect disabled. Explanation:
http://allenbrowne.com/bug-03.html

2. Decompile a copy of your database before you convert it back to A97.
That's a matter of entering something like this at the command prompt, while
Access is not running. It's all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Then compact: Tools | Database Utilities | Compact.

3. Make sure you have SP3 for your Office 2000 machines, and JET 4 SP8
installed on both your Office 2000 and 2003 machines. The service packs can
be downloaded from:
http://support.microsoft.com
and the JET s.p. is downloaded and applied separately.

4. More general ideas on avoiding corruption:
http://allenbrowne.com/ser-25.html

The other important factor is that you must use the DAO 3.5x library in A97,
not 3.6. More info on references:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tony Gambee" <to**@camptrak.com> wrote in message
news:eb**************************@posting.google.c om...
I have a system that we have had running for many years. We keep our
file in 2000 format, but develop in 2003 environment... ussually we
use our test computer with 2000 loaded to convert back to 97 and then
open our 97 test computer and fix references etc. recently once we
convert to 97 we can open the file but many forms are corrupt. Does
any one have any advice on this?

Tony

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.