open SQLite database without ODBC

[FuzMic]

Hi help
With ODBC we can link to any table in an SQLite database.
How to do table link without ODBC eg with Open table

 

[jdraw]

Fuzmic,

How about an overview of your project that shows how the pieces fit together?

 

[FuzMic]

Instead of using SQL server my BE is in a SQLite, the FE is msaccess. I want link these tables so they become queries data for forms or reports

 

[FuzMic]

Thanks Pat.
Being very new with SQLite my aim in this thread is I am hoping some forerunner can help & show me the way to link from my msaccess FE to BE SQLite tables WITHOUT using ODBC. The reason is something to do with the registry .INI for each database using ODBC.

 

[isladogs]

I've never tried linking Access to SQLite so can't provide specifics.
How about using DSN less connection strings?
See whether you can adapt anything from these Web pages

Access connection strings - ConnectionStrings.com

Connection strings for Access. Connect using Microsoft.ACE.OLEDB.12.0, Microsoft.Jet.OLEDB.4.0, OleDbConnection, Microsoft Access accdb ODBC Driver.

www.connectionstrings.com

SQLite connection strings - ConnectionStrings.com

Connection strings for SQLite. Connect using SQLite.NET, Finisar.SQLite .NET Provider, SQLite3 ODBC and ODBC .NET Provider.

www.connectionstrings.com

 

[FuzMic]

Isla Thanks the connection string to start tinkering.

 

[isladogs]

Good luck. Let us know how you get on.
Please post the correct connection string if you succeed

 

[jdraw]

FuzMic,

There is a thread here by a person working with SQLite and Access- you may get some more focused advice/comments if you contact or participate/ask questions.

 

[gemma-the-husky]

DSN less connection

how to do a DSN less connection in Access (what is Local and - Microsoft Community