I have successfully installed the Devart SQLite ODBC driver and I can connect to the SQLite database using MS Access. I can update data and delete rows but I am having 2 issues I hope you can help me with.

 

·         I am unable to add new rows to any SQLite table from within Access. Either directly through the linked table or any other method. What could be causing this?

·         When I open a large table with over 300,000 records and attempt to move to the last record it takes 12-15 seconds. Using the open source SQLite ODBC driver from Christian Werner (http://www.ch-werner.de/sqliteodbc/) the last record can be reached in under a second. Is there any way to speed up record navigation?