10
1
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.
matt wilkie
Posted 2011-03-30T16:40:49.843
Reputation: 4 147
8
What you want is an ODBC driver for SQLite...
Such as:
Just googling for "SQLite ODBC" returns a heap of results that can help you.
Majenko
Posted 2011-03-30T16:40:49.843
Reputation: 29 007
0
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).
OuzoPower
Posted 2011-03-30T16:40:49.843
Reputation: 184
0
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.
Justin Dearing
Posted 2011-03-30T16:40:49.843
Reputation: 2 704
3For people finding this through Google, I had the mismatch architecture problem when the sqliteodbc version was a different architecture (32bit vs 64bit) to MS Office, not to the OS it's installed on. ie installing 64bit ODBC on 64bit windows won't work with 32bit Office. – Holloway – 2015-01-29T12:20:25.800
thanks for ODBC keyword. I'm as yet unable to get sqliteodbc to work, "The specified DSN contains an architecture mismatch between the Driver and Application (#0)", but at least now I have a path to follow. – matt wilkie – 2011-03-30T18:42:23.670
@mattwilkie Were you able to get this working? – Forethinker – 2013-05-22T04:44:08.073
@Forethinker, yes, though the details are lost in time and I've not used the connection for quite awhile. It was through reading and testing the linke above though. – matt wilkie – 2013-05-22T17:41:22.880