Hi,
I have built a process that contains several tables, hierarchy based look-up tables, that are linked with an OBDC driver. When running queries against these linked tables I am experiencing a performance issue. I have found that if I import these OBDC based tables into my DB the...
I really meant to say that I have several separate workbooks each of which has different passwords that are linked to an access db.
When going into access and trying to open one of linked workbooks I am not able to open the file. It gives me the following dialog box...."Could not decrypt...
I have an access db that has several linked in excel worksheets. To run queries in access off these worksheets the passwords must be logged into the excel worksheets, so bascally the sheet has to be opened. Is there some VB code where access can lookup the passwords to the worksheets?
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.