I'm using Access 2002, and looking to save an mdb as 97. When I saved as, it
said i needed to set references while IN access 97. Is that correct?
Yes. References ALWAYS need to be checked when converting between versions of
Access. For example, just look at the reference (2002) "Microsoft Access 10.0
Object Library", which in A97 must change to "Microsoft Access 8.0 Object
Library". DAO might change from 3.6 to 3.5. You might have references beyond
the minimum required 3, which may or may not be present. Even if everything
works, your code will at the least be "decompiled".
I can't
'save as' unless I have access 97?
No. You don't need A97 to convert back. You need A97 to test'n'fix after
conversion. If you are thinking of just converting and posting to someone
without testing, don't.
No. Workarounds are for bugs. This is not a bug. You are converting between
different "complex" database systems. Access is not at all like Excel or Word
conversions, which are piffling programs <g>.
Alternatively, YES!!! Get rid of as many references as you can!!! Don't use
any "fancy features" and you can reduce an mdb to the minimum requirement of 3
references.
(which will still change, however, but usually automatically)
Chris
