Database linking issue when db is opened (1 Viewer)

[penfold1992]

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

 

[llkhoutx]

Use Access security to make all tables read only. Read up on Access Security. alternatively, import the Excel data.

 

[smig]

Import the excell shit into access