Set conn = CreateObject("ADODB.Connection") conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data\old.mdb"
Microsoft replaced Jet 4.0 with the . This allows you to interact with Access databases (and Excel files) using modern systems. download microsoft jet oledb 4.0
The "story" gets complicated when 64-bit Windows arrived. Microsoft decided that Jet 4.0 would remain 32-bit forever Microsoft Learn The Problem: Set conn = CreateObject("ADODB