syntax53

i know this is more of an ms access specific problem, but i thought this was the best place to post it.

at first i had access 97 and access XP installed on my computer. recently i installed access 2000 as well since i need to test automation using all three versions. before installing 2000, whenever my app called upon access it would launch whatever version i last opened manually. now, with access 2000 installed, it will only run access 2000 and access 97. even after i launch access xp manually, when the automation code runs, access 2000 is launched.

the basic code i'm using to launch access (without all the other code after it) is:

Dim oAccess as Object
Set oAccess = CreateObject("Access.Application")

i don't have any references to the access libraries in my app and making them a reference isn't an option. what i want is for it to work like access 97 and access xp. i'm going to try and uninstall all three and reinstall starting from 97 and then 2000 and then xp, but i was wondering if anyone had any other ideas.

thanks,
syn