Upgrading / Converting from ACCESS'97 to ACCESS'2003

message from Vern DeGeus on 27 May 2004
i will be converting a significant ACCESS'97 .mdb to
ACCESS'2003. The .mdb has complex forms, many pass-thru
queries and linked tables and a lot of DAO code. Can
anyone share with me any gotchas and other issues that i
will have to deal with ?
thank you
Vern
 
Kevin3NF replied to Vern DeGeus on 27 May 2004
I haven't done this but from other posts I suspect you mind need to set a
specific reference to DAO and make sure it is higher than the ADO reference
:-) Make sure the A97 version compiles cleanly.

My other advice would be to make a copy, convert that and see what
breaks....not very scientific, but you'll have a good understanding of about
where you are.
 
Vern replied to Kevin3NF on 28 May 2004
good thought, thanks ; i will follow this approach

mind need to set a
the ADO reference
see what
understanding of about
Worth area DBAs.
 
Tony Toews replied to Vern DeGeus on 27 May 2004
For what I've come across see Access 2.0 and Access 97 to Access
2000/2002 conversion problems
http://www.granite.ab.ca/access/conversionproblems.htm

Tony
 

Archived message: Upgrading / Converting from ACCESS'97 to ACCESS'2003 (Microsoft Access Forms)