Thank you for your comments.
This is an area I have never been to before so I am having trouble understanding the implications of what you have said. For example "you have to create your DSN in two locations:" sadly means nothing to me but I guess something may need to be done to the line
my $dsn = 'driver=Microsoft Access Driver (*.mdb, *.accdb);dbq='.$dbfi
+le;
I have found that I do have odbccad32.exe and odbc32.dll in both the SysWOW64 and System32 directories. I am using Windows 10 OS.
I get the impression that I may have to do something so that the correct odbccad32.exe is used?
Is that correct and if so can you point me to some web page that has more 'clues'?