Link Excel to a secured MS Access

[qwerty70]

I have read the Tek-Tips' faq68-1403 concerning linking of MS Excel workbook to MS Access. This is great.

Is there any way to link the Excel workbook to Access query that bypasses the security workgroup. I tried to link my Excel workbook to my secured Access database but it is always asking me to put the User Name and Password. How do I bypass the Access security?

Your help is highly appreciated.

Regards,

qwerty70

 

[alvechurchdata]

How do I bypass the Access security?

You can do this in program code but I don't know of a way of doing it from the Access menu system.

Geoff Franklin

http://www.alvechurchdata.co.uk