The Microsoft Access Link To SQLite Table GUI Add-In

This 100% Free, Open Source Microsoft Access Link-to-SQLite GUI Add-In tool was designed to help create MS Access linked tables to any SQLite database file. This tool provides a GUI for connecting to the SQLite database and allows the user to select exactly which SQLite tables to link to your Access database. This tool can link Access databases to tables in .sqlite, .sqlite3, .db, .db3, .s3db, and .sl3 (and probably more!) database file types.

The Access Link-To-SQLite tool creates the connection string to the SQLite db, creates the Access linked tables in your local database, and then establishes the connection to those SQLite tables. Once the SQLite tables are linked in your Access database, you will see them in the NavPane as normal linked tables, and you will be able to add, edit, query, and delete records in your SQLite database directly from your Microsoft Access database application.

*** NOTE ***

Using the Access Link-to-SQLite Add-In tool requires a ODBC driver for SQLite installed on your system. It also requires that the ODBC driver is the same architecture as Microsoft Access on your system, so if you're running 32-bit Access, you'll need a 32-bit ODBC driver, and if you're running 64-bit Access, you'll need a 64-bit ODBC driver, both of which are available in this package. See the "Where to Download" section below for more information about where to get the correct SQLite ODBC driver for Windows needed for your version of Microsoft Access, if you don't have a SQLite ODBC driver already.

Screenshots of the Access Link-to-SQLite GUI Add-In Tool:

A screenshot of the main form used within the Microsoft Access Link-to-SQLite GUI Add-In tool:

Where to Download:

Download the FREE Microsoft Access Link-to-SQLite GUI Add-In (.accda file) here: Latest ACCDA Download

Or download the latest Stable Release package here: Latest Full Release Package

If you don't have an SQLite ODBC driver already, you can download one from GitHub here

• The 64-bit SQLite ODBC driver can be downloaded here
• The 32-bit SQLite ODBC driver can be downloaded here

NOTE: ODBC drivers should match the same architecture as Microsoft Access. So if you have 64-bit Access, use the 64-bit ODBC driver.

Christian's original site providing links to download the SQLite ODBC drivers can be seen here.

System Requirements:

The following software is required to be installed to use this Microsoft Access Add-In tool:

1. Microsoft Access 2007/2010/2013/2016/2019/2021/2024/365 or Higher More Info
2. SQLite Database System More Info
3. An ODBC Driver for SQLite More Info

NOTE: ODBC drivers should match the same architecture as Microsoft Access. So if you have 64-bit Access, use the 64-bit ODBC driver.

How to Install:

To just install the latest version of this Access Add-In without messing with any of the source code, complete the following steps:

1. Download the latest ACCDA file from HERE.
2. Open any database in Microsoft Access and go to the "Database Tools" ribbon menu.

3. On the "Database Tools" ribbon, click the "Add-Ins" option drop down, and choose the "Add-In Manager" option. This will open the Access "Add-In Manager" form.

4. The Access "Add-In Manager" form will be opened, click the "Add New..." button.

5. The Access "Open" file dialog will be opened.

6. On the "Open" file dialog, navigate to the ACCDA file you downloaded and click the "Open" button.

7. The Add-In will be installed and will now show in the "Add-In Manager" form.

The Microsoft Access Link-to-SQLite GUI Add-In should now be installed correctly.

How to Use this Tool:

To use this tool once it has been installed:

1. Open any Access database in Microsoft Access.
2. On the "Database Tools" ribbon, click the "Add-Ins" option drop down, and choose the "Link to SQLite Database" option.

3. The "Access Link to SQLite" GUI form will open.

Project Resources:

Here is a list of some resources available for this project:

1. Log bugs and issues in our Issues Database Here

2. Discussions about this project can be created in our Discussion Forum Here

Project Contributors and Acknowledgements:

A GREAT BIG "THANKS" to the following contributors to this project:

1. The Microsoft Access Team - A HUGE THANKS for creating the most AMAZING and VERSATILE database product ever to exist, it has changed my life FOREVER!!!

2. The SQLite Team - Another HUGE THANKS for creating such an AMAZING database system too, a system which is up and coming in this brave new world and I'm loving it!

3. Christian Werner - Thank you for the GREAT SQLite ODBC drivers for Windows!

4. Albert Kallal - Thanks for inspiring me to use SQLite databases more!

5. Crystal Long - Thanks for always being my biggest fan, especially when it comes to my work involving Microsoft Access!

6. George Hepworth - Thanks for always hosting the Access Users Group Meetings and for always coming up with GREAT ideas for Access database applications.

7. The Access Users Groups - A HUGE THANKS to the Access Pacific and Access Express Australia groups for inspiring me to use Access more and for always giving me ideas for database apps to create!

8. The AccGPT Tool for MS Access - For helping me build this tool in less than one day!

9. The Access Add-In Helper Tool - For helping me create this Add-In from my initial Link-to-SQLite Access App in just a few minutes!

10. Geoffrey Griffith - For my work to create this 100% FREE tool to help people connect Microsoft Access to their SQLite data.

Other Free Microsoft Access Tools:

Some other projects I've created in MS Access that I've also made available 100% FREE:

1. Access Add-In Helper

2. Access Database Property Editor Add-In

3. Remove VBA Line Numbers Add-In

4. Win32 API Declarations for VBA