Need to be able to link to a Password Protected Workbook

W

WildlyHarry

Does anyone know how to link an Access table to a password protected Excel
workbook? I can create the link if the Excel workbook is open. However I
cannot open the table in Access unless the workbook is open. Thanks in
advance for your help.
 
A

a a r o n _ k e m p f

move it from excel to a real database

is it our fault that Excel is mis-used as a database?

keep your DATA in a DATABASE and wean people off of excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password protect new workbooks from template 0
Turning off automatic calculation 0
Visio to Excel 0
Shortcuts in OneDrive 0
How do I link a cell in a workbook? 1
Link a table to a password protected excel file? 0
Dealing with the error: unable to filter on excel hc home school 0
Need Help with Macro Security 1

Top