Untill last month we were using SQLite database and recently to encrypt the database developer have changed it to SQL Cipher 4.
This was my code to access the SQLite databse
Set objConn = CreateObject("ADODB.Connection") Set objRecordset = CreateObject("ADODB.Recordset") objConn.Open "DRIVER=SQLite3 ODBC Driver; Database=C:\storagedata\Polldata.db3;"
objRecordset.open “Select * from Table_Name”, objConn
Can someone please tell me what changes do I have to make to access an encrypted database.
Thanks in Advance,