0

The error message is "Data source name not found and no default driver specified (0)"

conn_str = (
        r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};'
        r'SERVER=(C:\Users\Matthew\OneDrive\Documents)\SQLEXPRESS;'
        r'DATABASE=chemicals.accdb;'
        r'Trusted_Connection=yes'
    )
rioV8
  • 24,506
  • 3
  • 32
  • 49
MatthewO
  • 11
  • 2
  • 1
    Note that, in addition to the guidance on the duplicate, that connection string looks weird. Server/Database/Trusted connection are all not meaningful for an Access connection. See connectionstrings.com for example strings – Erik A Nov 16 '22 at 11:08

0 Answers0