Hi
I have an excel file with 3 sheets. each sheet has a table linked to sql views. each time i open the file for the first time i get prompted for the password when i refresh the tables (or list objects).
i want to be able to open the file from access and refresh the tables without the password prompt popping up.
can i set the connection up to retain password info??
Thanks.
Bookmarks