This an Access ADO data retrieval that is in a Word document macro.

I recently bought a new laptop and I'm moving this old macro over to it. The first problem I had was getting "Type Mismatch" error when using Recordset.RecordCount. In my research, it appeared that I was going from a 32-bit environment to a 64-bit environment and that I needed to download and reference Microsoft ActiveX Data Objects 6.1 Library. I did that and it seems to have fixed that particular problem.

I'm getting the same error when I execute a Select command as follows:
Set myRs = conn.Execute(mySelectStmt)
mySelectStmt = "SELECT [TtlPgHdrTxt], [TtlPgHdrStyle], [CntPgHdrStyle], [FtrStyle] FROM [My Preferences] WHERE " _& "[User Co Nm] = '" & UserCoNm & "'"
It just Selects some small amount of text from the database reflecting the User's preferences.

This has worked flawlessly for years, so I'm thinking this has to do with the 32-bit vs 64-bit environment. "Type Mismatch" doesn't make sense because it's all text. There's no different data type involved.

I've researched this on-line but can't find anything directly addressing this issue.

Any ideas?