Access 97 upgrading to 2003

[lemon_balm]

My company has finally bitten the bullet and decided to upgrade their systems before their software goes out of date for user support. However, this means that they are about tio upgrade from Office 97 to Office 2003 running on a Windows 2000 operating system.
How much of an issue am I going to face in converting my databases into the new format. I realise there will be DAO/ADO issues but is there going to be anything else? I am acutely aware that I will be having to sort databases out across the whole company nationwide and the fewer surprises, the better.
Has anyone been through this and if so what were the issues?

Regards

Jason

 

[workmad3]

Well, I went through this a little while back, but only had to sort out about 4 machines (small company). Only real problem was converting the old db to MDE format, as this required converting to 2003 format first. How easily the conversion goes depends mostly on how well written the code is, and how many deprecated functions you use that now no longer exist. All of my ADO code ported fine, the stuff that didnt was mainly to do with printers, which got changed slightly between access 97 and access 2000 I think.

 

[RuralGuy]

And here's some additional information on the topic from MVP Allen Browne.
Converting from Access 97

By the way, if you edit the other duplicate thread it will let you delete it!