Does anyone know of a driver that would allow Access to work as a front end for SQLite files? I would prefer this to a conversion facility since I need Access to read SQLite files on an ongoing basis.
Any ideas would be greatly appreciated.
-Tim
Novice
Windows 7 
Access 2010 (version 14.0)
Reading SQLite db files
Does anyone know of a driver that would allow Access to work as a front end for SQLite files? I would prefer this to a conversion facility since I need Access to read SQLite files on an ongoing basis.
Any ideas would be greatly appreciated.
-Tim
MS MVP - Access Expert
Windows 7 Access 2010 (version 14.0)
I have never used SQLite it before but will all the SQL servers I have worked with I installed an ODBC driver.
I would see if there is an Windows ODBC driver for SQLite.
Boyd Trimmell aka Hitechcoach
Database Architect and Problem Solver
Microsoft MVP - Access Expert
25+ years specializing in Accounting, Inventory, and CRM systems
"If technology doesn't work for people, then it doesn't work."
MS MVP - Access Expert
Windows 7 Access 2010 (version 14.0)
I was curious. A quick google lead to this:
SQLite ODBC Driver
and
SQLite 3 ODBC Driver
Boyd Trimmell aka Hitechcoach
Database Architect and Problem Solver
Microsoft MVP - Access Expert
25+ years specializing in Accounting, Inventory, and CRM systems
"If technology doesn't work for people, then it doesn't work."
Posting Permissions
Reply With Quote