Windows 10 update wont run my code!!

I have this workbook that I ran on windows 7 but it will ont open the connection to access db in windows 10. every time it goes to run the line

cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & AccessFile

it just says not responding and restarts excel.
any ideas why? thank you

Set cnn = New ADODB.Connection
cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & AccessFile
cnn.CursorLocation = adUseClient

Set rs = New ADODB.Recordset

rs.Open SQL, ActiveConnection:=cnn, _
CursorType:=adOpenDynamic, LockType:=adLockOptimistic, _
Options:=adCmdText

If rs.EOF And rs.BOF Then
    rs.Close
    cnn.Close
    Set rs = Nothing
    Set cnn = Nothing
    Application.ScreenUpdating = True
    MsgBox "No records found!", vbCritical, "No Records"
    Exit Sub
End If

Hi,
This will not be a great help, I am only just staring to learn this ADO stuff and you may know all this...

_1) The line that is erroring for you is some sort of “connection thing”. Every time I have used that Line I have had a problem. Up until now I have got the thing to work just by experimenting with the different available “connections”
_1a) Here is one good source for some different connections
https://www.connectionstrings.com/excel/
https://www.connectionstrings.com/access/

_1b) I noticed that some published connection strings have syntax error , such as missing, or incorrectly place quotes, for example. But I guess then that would work or not work in both operating systems, so there should be no differences there, ....... Or maybe that could explain why there are what appears to me to be syntax errors. – Possibly they “work” in a different system. But this seems unlikely to me. .... ?
http://www.connectionstrings.com/que...-syntax-error/


_2) However, I expect a Windows 7 to Windows 10 difference should not be a “connection” thing as I thought the different “connections” were to do with different Excel / Access software rather than Operating system. I guess you have searched the internet and have seen that many people gave had a similar problem to what you are having.. ( ADO connections not working when going from Win 7 to Win 10 ) . In particular these seemed relevant.
http://stackoverflow.com/questions/3...-machines-only
https://www.microsoft.com/en-us/down....aspx?id=13255
http://stackoverflow.com/questions/1...nder-windows-8
http://www.mikesdotnetting.com/artic...-local-machine

_............


_.. Sorry I cannot help more, as I only have XP Vista and occasionally Win 7. However I am considering an update to Win 10 with a new computer. So please if you do get the problem solved feedback as that could be relevant to me.

Hope at least my reply has brought the thread back up for you so that an ADO expert may catch it for us.

Alan