Open SQLite db in Microsoft Access?

Question

Are there any tools to allow using sqlite databases from Microsoft Access?

Of course full access is preferred, being able to edit records, add tables & fields, etc. but read-only browsing would helpful too.

I'm using Access 2007 x64.

Answer 1

What you want is an ODBC driver for SQLite...

Such as:

• http://www.ch-werner.de/sqliteodbc/
• http://www.patthoyts.tk/sqlite3odbc.html

Just googling for "SQLite ODBC" returns a heap of results that can help you.

Answer 2

As an alternative to using access, I wrote a SQL browser for access called PlaneDisaster.NET. I also have a tool in there that converts from mdb to sqlite. I never wrote a tool to go the other way, but if you know C# that code is a good start.