I have a MSAccess97 database with security. When I try to create a query within Excel it cannot link to the database saying 'Do not have permissions'. So, in Access-Permissions, I ensure that the Admin user can administer the database then when I create the Excel query it connects and works fine. The problem is this then means that anyone can access the database without using the shortcuts with username and passwords I have created. I created my own Admin name which is what I want to continue using. Can anyone help?