Problems when using a DB created in Access 2002 (XP) in Access 2003

[Raneil]

I have an Access DB that I created in Access XP. It works perfectly when used in Access XP. When used in an Access 2003 environment some of the functions don't work anymore. I have users who use Office XP and users who use Office 2003. Does anybody know how to make this DB work in Access 2003 without having to do wholesale code changes?

I have already changed the security to "Low" to bypass the security feature built in in Jet 4.0 but it didn't help. I might have to uninstall Windows XP SP2 to make it work because I know that the application works in an Office 2003 environment with Windows XP SP1 only. But I'm trying to avoid having to uninstall XP SP2 because it's a pain. Any ideas would be greatly appreciated.

Thank you.

My workstation environment is as follows:

OS: Windows XP SP2
Office: Office 2003 SP1
Jet: 4.0

Raneil

 

[Raneil]

The culprit was a virus or a spyware

After much work trying to get Access to work it turns out that the problem was either a virus and/or a spyware that was causing Access to not work properly.

I ran the following:

-McAfee online scan
-Norton online scan
-Lavasoft Ad-Aware
-Spybot Search & Destroy
-Spywareblaster

I removed all the spyware and the virus that was found on my PC and, voila, Access started working again.

Moral of the story: keep your virus definitions up-to-date and frequently check for and clean spyware/trojans/worms/etc. from your PC.

Thanks.