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

 

[Pat Hartman]

ODBC is ODBC. That is the point. Once the driver is installed and the database is created, you can link to a table in the database and it will work just like any other ODBC table. In fact, I have applications where I swap the BE from Oracle to SQL Server. Unless I do something that is not supported by both, then everything I do will work regardless of which BE the FE is linked to.

 

[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

 

[Pat Hartman]

An easy way to find the valid connection string is to create a DSN and then link a table. Open the MSysObjects and look at the connection string that Access saved.

 

[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