Ahhhhhh!  Thank You!

Thanks so much -- that info is all very helpful.

Hello Brian --

Thank You -- that was in fact the issue --

Scouring the microsoft articles, I came across this:

https://docs.microsoft.com/en-us/sql/connect/odbc/using-always-encrypted-with-the-odbc-driver?view=sql-server-ver15

The SQL type of the parameter inserted into the SSN...

• This reply was modified 3 years, 8 months ago by  EsquireDeveloper.

Sorry should have searched this forum thoroughly.  This article was very helpful

https://www.sqlservercentral.com/articles/sql-server-2016-always-encrypted

Brian~

Thanks for that feedback -- yes, I will find a weekend to get to the bottom of this.

Hi Jeff,

Thanks again for your help -- I think I figured it out -- along the lines of what you were getting at -- I added the following line to...

Hi~

I do have a proxy account set up to run some of my VBS scripts.  If I'm understanding you correctly, I would need to change the Type to 'Operating System...

Hi guys ~

Thanks for your responses.  I am not querying a linked server. The code does work in its entirety, including sending an email, when I run it manually.

I changed...

• This reply was modified 3 years, 10 months ago by  EsquireDeveloper.

It appears so -- I had an end user log into my machine, and through MS Access tried to add a record to one of the tables in question and...

Thanks for all the feedback -- I'll take a look at that presentation.  Thanks All.

Thanks,I'll go in that direction -- I'm intrigued -- 'Force Them to Live Out Of Row' -- would you mind explaining further or pointing me to a link

Quick Follow Up Question:  The two sets of addresses and two sets of contact info for each applicant are obvious cues to normalize and create tables for each.

But everything else...

Ha....this one is going to hurt, as so much will have to be re-written.  But better now than a year from now.

Thanks for the replies....I'm hesitant to post any actual table structure or data for security reasons, but it does seem that ultimately I should break up this table, and this...

Thanks for the tips guys -- I'll definitely look into these options moving forward.