Been using the www.ch-werner.de drivers successfully, including ones we locally compile 32/64 bit with VS2019. We mostly use from windows script files (scripts with .wsf extension) which is very similar to using from VBA. This works both 32 and 64 bit...someone mentioned here that you can have both installed at same time which is true.
Looking at your code above, one possible issue might be the connection string you are using. Here is what I use (Note the lack of curly brackets {}):
`DRIVER=SQLite3 ODBC Driver;Database=[path to database];`
Extra tidbit: You can also load extensions via the connection string and use via ODBC...just add the following to the connection string:
`LoadExt=[path to extension];`
Here is an example:
`DRIVER=SQLite3 ODBC Driver;Database=c:\temp\test.db;LoadExt=c:\sqlite\extensions\csv.dll;`
Note that no quotes are required for file paths in the connection string even if there are spaces in the paths (blasphemy!!!).
WRT recordset, I've had best luck using CursorType = adOpenStatic and LockType = adLockOptimistic. Pretty sure these are not the defaults...
Hopefully that helps...