I am trying to link a access DB to an excel sheet and everything works as expect it to, unless the DB is open.
my db is an encrypted accdb file and I have connected it via the "From Access" wizard within excel.
it is an encrypted file as I do not want the users to gain write-access to the tables that are in the database.

the error I get is:
"Do you wish to connect to 'db-location'?
if I select "Yes" I get the excel "Data Link Properties" connection window expecting me to confirm the data source and enter a login and password. regardless of what I enter, I am brought to the same page as if I click "No".

if I click "No", I get the "Microsoft Access Database Engine OLE DB Initialization Information" again asking me to verify the Data Source, Username, Password, Provider String and Open Mode.

Is there a way to get around this?
Possible thoughts:
Create a new database which has a link to the back-end as well but dont password protect it, then attempt to link from the newly created front end?

Thanks in advance for any help