Upgrading / Converting from ACCESS'97 to ACCESS'2003

[Vern DeGeus]

HI:
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]

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.



--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Tony Toews]

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.

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

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Vern]

good thought, thanks ; i will follow this approach