I have created a database using Access 2002 and created a macro to open the database which is on my desktop. I also have a copy of Access 97 on my machine and when I click on the macro it trys to open the database in Access 97 instead of Access 2002. Does anyone know if there is away of assigning this file to Access 2002 permanently?