Thank you everyone for your suggestions. Looked at Xojo. Not sure if the free version will stick around. And there is no way to save and reuse reports from one session to another in the free version. Creating and recreating the report every time is going to become tedious very soon.
Continuing to use Access as a front end and connecting to my db using odbc is definitely an option. I wanted to move away fully from Access, so I am going to keep that as a backup option. I am leaning towards tcl/tk given the endorsement from both Peter and DRH. So, I downloaded tcl/tk version 8.6.7 from magicsplat ( http://www.magicsplat.com/tcl-installer/index.html), and then ran tclsh.exe. In the resulting command window, I typed "sqlite3 db1 <path to my sqlite database" as instructed on this page on the sqlite website: https://sqlite.org/tclsqlite.html . And all I got was "invalid command name sqlite3". So, I am stuck. What did I do wrong? BTW, the www.tcl-lang.org website has been down for at least the past 3 days it looks like. Not sure how to interpret the reliability of a technology whose home website is down for days at a time. Balaji Ramanathan On Tue, Nov 14, 2017 at 6:00 AM, < sqlite-users-requ...@mailinglists.sqlite.org> wrote: > > ---------- Forwarded message ---------- > From: Peter Da Silva <peter.dasi...@flightaware.com> > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Cc: > Bcc: > Date: Mon, 13 Nov 2017 22:03:34 +0000 > Subject: Re: [sqlite] Best way to develop a GUI front-end > Since sqlite originated as a Tcl extension it’s got excellent Tcl > bindings, and Tcl has an excellent platform-independent GUI in Tk, so it > seems to me that would be the best and simplest way to create a GUI front > end for sqlite. > > > > ---------- Forwarded message ---------- > From: Richard Hipp <d...@sqlite.org> > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Cc: > Bcc: > Date: Mon, 13 Nov 2017 17:06:20 -0500 > Subject: Re: [sqlite] Best way to develop a GUI front-end > On 11/13/17, Peter Da Silva <peter.dasi...@flightaware.com> wrote: > > Since sqlite originated as a Tcl extension it’s got excellent Tcl > bindings, > > and Tcl has an excellent platform-independent GUI in Tk, so it seems to > me > > that would be the best and simplest way to create a GUI front end for > > sqlite. > > +1 > > -- > D. Richard Hipp > d...@sqlite.org > > > > ---------- Forwarded message ---------- > From: Tim Streater <t...@clothears.org.uk> > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Cc: > Bcc: > Date: Mon, 13 Nov 2017 22:22:29 +0000 > Subject: Re: [sqlite] Best way to develop a GUI front-end > On 13 Nov 2017, at 21:54, Balaji Ramanathan <balaji.ramanat...@gmail.com> > wrote: > > > Is there a third party free tool like MS Access that would allow me > to > > connect to a SQLite db in the back-end and enable me to create a custom > > front-end to it with forms and reports? All my searches for this kind of > > tool only lead me to tools like SqliteStudio, which is a GUI front end > for > > SQLite, but not a programmable one like I want. If anyone can point me > > towards a programmable GUI front-end development tool (preferrably > > open-source, but just free and well-maintained is sufficient), I would > > appreciate it greatly. > > There is Xojo (www.xojo.com) which has SQLite built in and has reports > (which I have never used). It's cross-platform and you create your own GUI > front end with windows, buttons etc. It's free to use for development, but > if you want to compile and build a stand-alone application (.exe or .app) > then you buy a licence. There is a Lite licence to build for one platform > which is not a high cost. > > > > -- > Cheers -- Tim > > > ---------- Forwarded message ---------- > From: Bart Smissaert <bart.smissa...@gmail.com> > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Cc: > Bcc: > Date: Mon, 13 Nov 2017 23:52:18 +0000 > Subject: Re: [sqlite] Best way to develop a GUI front-end > As you are familiar with VBA I can see two other options: > > 1. Use Christian Werner's ODBC driver from Access (or Excel): > http://www.ch-werner.de/sqliteodbc/ > > 2. Use Olaf Schmidt's COM dll with Access (or Excel): > http://www.vbrichclient.com/#/en/About/ > > RBS > > > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
