This one stumped me when asked, though I don't touch MS Access much being mainly Lotus Notes guy so sorry if this is a stupid question!
There is currently an Access MDB which users access through a simple Excel sheet. The Excel sheet opens the MDB using \ hyperlink file://\\server\share\dir\file.mdb
When the users click on the link they are NOT prompted for a password (which is 'correct')
When a user (or admin) opens the MDB specifically they ARE asked for a password
Now..... a certain machine, with multiple different users when clicking on the link in the Excel sheet is also being prompted for the password.
I don't understand the mechanism for how the other users (including myself who has never touched it before) can click on the link in the Excel sheet and have it open the MDB?!
Any pointers gratefully accepted.
Office XP + 2007 compatibility pack.