Thanks for the replies.
In this case I have taken two posted examples and tried to combine and use them. My first attempts failed so I copied the example code and Dave S’s answer at the top of this thread to hopefully get someone to point out the error that I must have made.
Trying to use the backup command example to create in in memory db with this code I get a “Unable to extract path from the FolderItem.” error on the .CreateDatabase line. I had thought leaving out a disk file reference would result in a in memory db.
Var backupDB As New SQLiteDatabase
try
backupDB.CreateDatabase
db.Backup(backupDB, Nil, -1)
Catch error As IOException
MsgBox("Failed to create backup database. Error: " + error.Message)
End Try