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.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
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.
Although I'm aware not specifically answering your question, you might also consider Kexi (www.kexi-project.org), which is an Access-like or Framemaker-like software and natively using sqlite. It was initially written for Linux with KDE Destkop, but was compiled to a binary for Windows too (https://forum.kde.org/viewtopic.php?f=221&t=110012) and Kexi's main author is currently paying attention to the native Window port (https://forum.kde.org/viewtopic.php?f=220&t=127422).