Recent content by bitflipper

The resolution to my problem was to convert my function from DAO to ADO. Hope the following code helps someone else down the road: Public Function ExecuteSPWithParamsQueryADO(pSPROCName As String, ParamArray pParams() As Variant) As ADODB.RecordSet...

Rewriting my function to use ADO rather than DAO solved the problem. Here is my code in hopes that it helps someone else: Public Function ExecuteSPWithParamsQueryADO(pSPROCName As String, ParamArray pParams() As Variant) As ADODB.RecordSet...

I will look into Access 2016 support for Always Encrypted. Thank you.

If I upgrade to a newer version of MS Access do you think that will resolve this particular issue?

SQL Server 2016 Always Encrypted Parameterization I'm evaluating whether or not SQL Server 2016 Always Encrypted will work with an existing MS Access 2010 Application that I support. Here's my current roadblock: My application calls many SQL Server stored procedures that require parameters. I...