Search results

Hi I have inherited a ms access 2010 database and now I need to do some changes to some of the queries and objects. the problem I am facing is saved import export, for the life of me I cannot find full specifications for the imports. when I right click on the thing I only get options to run or...

Hi Denis Actually it is a linked table. However I have managed to include it in the query itself. Like so. sql = "OPEN Symmetric Key HRSecureSymmetricKey DECRYPTION By PASSWORD = '*********' SQL STATEMENT Close Symmetric Key HRSecureSymmetricKey" It's working fine. Thanks for the feedback

Hi I need help with data decryption I have a application in access which connects to a sql server database and using the provided tables it calculates salary increases per department, per month. Now last month I had to employ encryption on all tables that contains sensitive data. That being done...