Given the age of ACE 2016 (no security patches since 2021 extended support), consider migrating away:
When you install the 32-bit redistributable, the following key files are placed in %ProgramFiles(x86)%\Microsoft Office\root\vfs\ProgramFilesCommonX86\Microsoft Shared\OFFICE16\ : microsoft access database engine 2016 redistributable 32 bit
: Requires a minimum of 1 GB RAM for the 32-bit version and approximately 3 GB of disk space. Important Installation Notes Compatibility matrix between COMOS and third-party software Given the age of ACE 2016 (no security
From *.xlsx to *.accdb without Excel installed – a common pattern in scheduled server jobs. microsoft access database engine 2016 redistributable 32 bit
Set conn = CreateObject("ADODB.Connection") conn.Open "Provider=Microsoft.ACE.OLEDB.16.0;Data Source=\\server\share\data.accdb"