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

smercer

Registered User.
Local time
Tomorrow, 08:38
Joined
Jun 14, 2004
Messages
442
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
 
The code won't be different. There's just new features in Office 2003. I just upgraded recently and I like the new look.
 
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.
 
Last edited:
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.
 
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.
 
Pat Hartman said:
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.
 

Users who are viewing this thread

Back
Top Bottom