64bit version crashes

[KallunWillock]

I just tried running the demo routine, and it crashed Excel four out of four times. I stepped through the code, and it crashes on the operative line of the SQLite3BackupStep routine.

I believe this is a result of the sqlite3_backup_init API declaration, which appears to return a Long data type, which is then passed to the BackupStep routine as the backuphandle (LongPtr). I changed the sqlite3_backup_init API declaration to return a LongPtr instead (as below) and it no longer crashes.

Private Declare PtrSafe Function sqlite3_backup_init Lib "SQLite3" (ByVal hDbDest As LongPtr, ByVal zDestName As LongPtr, ByVal hDbSource As LongPtr, ByVal zSourceName As LongPtr) As LongPtr

[govert]

I thought I fixed it here last year. 8f233e6
Did I miss something?

[KallunWillock]

I'm guessing the change wasn't made to the code in the XLSM file (Distribution Folder)?

[KallunWillock]

I just checked. It looks like you updated the BAS file 4 years ago but the demonstration workbooks were last updated 7 years ago.