I have an Access 2000 database with the BE on a network and the FE on individual computers. We have recently gone to Office 2003 but I have kept both version of Access on my system as well as leaving the db in 2000. I have a form with a drop down list of queries to select from (queries are in a table). The user selects the query then the cmd button "run query". It works great on my machine, but, when anyone else tries it, the query doesn't open - there is no error message, but also no hourglass to show that it is attempting to open, it's just as if the button wasn't even selected.
When I check references, my machine has msacc9.olb (9.0) and the other user, who is opening the db in 2003, has msacc.olb (11.0).
Has anyone experienced this? There are no missing references, it just doesn't do anything at all and the only thing I can see that is different between the two machines is the one reference version.
Thanks,
Toni
When I check references, my machine has msacc9.olb (9.0) and the other user, who is opening the db in 2003, has msacc.olb (11.0).
Has anyone experienced this? There are no missing references, it just doesn't do anything at all and the only thing I can see that is different between the two machines is the one reference version.
Thanks,
Toni
