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 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.