Password

[Mike H.]

I put a password on my .mdk access file. How can I programatically supply
that password when I refresh the link to the data in excel?

 

[Alex Dybenko]

try something like this:
http://accessblog.net/2005/04/how-to-import-password-protected-excel.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Mike H.]

Sorry for the misunderstanding but I wish to refresh access data in excel,
not the other way around. If I have a password on the access file, I am
prompted for it in excel.

 

[Alex Dybenko]

Hi,
Ok, then you can try to check "Save Password" option in External Data range
properties dialog (menu Data-Import external data)
Or perhaps better as in Excel newsgroups

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com