Should I upgrade to Office 2003 while I am designing a database?

[smercer]

Hi all

Should I upgrade my Office XP to Office 2003?

Will the coding in the Office XP be different to Office 2003?

will Major changes to the macros and Visual basic coding be needed when I change to Office 2003?

what are the benfits for upgrading?

Thanks in advance

 

[Mile-O]

The code won't be different. There's just new features in Office 2003. I just upgraded recently and I like the new look.

 

[Oldsoftboss]

One drawback is that you cant make A2000 mde files. So it will be handy to have a PC around with A2000 if you wish to distribute you Db's as A2000 mde files.

 

[quest4]

Macros seem to change with every version. I have heard a few other things no longer working. If you upgrade, be ready to do a lot of checking. LOL. hth.

 

[Pat Hartman]

Yet another reason for avoiding macros.

I tried to install Office 2003 and leave XP. That doesn't work! NEITHER version of Outlook would run and the Linked tables manager in Access ceased to work. Ultimately, I felt having 2003 was better so I got rid of XP and installed the software that was dependent on XP (measureUp! testing software) on a different PC.

 

[ghudson]

the Linked tables manager in Access ceased to work.

I had a simular problem with Access 97 and Access 2003 installed on the same PC but the KB article 835519 did not work for me. I had to copy the Office 2003 accwiz.dll from the Office11 directory and replace it with the Access 2003 accwiz.dll file in the C:\WINDOWS\system32\ directory. Then I had to register it with this command...

regsvr32.exe "C:\WINDOWS\system32\accwiz.dll"

The location of the "accwiz.dll" file for Access 97 was C:\WINDOWS\system32\accwiz.dll
The location of the "accwiz.dll" file for Access 2003 was C:\Program Files\Microsoft Office\Office11\accwiz.dll

I had installed Office 97 first then I installed Office 2003. Maybe this will benefit somebody else one day.