As you are familiar with VBA I can see two other options:
1. Use Christian Werner's ODBC driver from Access (or Excel):
2. Use Olaf Schmidt's COM dll with Access (or Excel):
On Mon, Nov 13, 2017 at 9:54 PM, Balaji Ramanathan <
> I have been using SQLite without any programming language so far. I
> maintain the data in SQLite and use SqliteStudio (www.sqlitestudio.pl) for
> inputting data into it and running queries to look at outputs. However
> SqliteStudio does not have a programmable back-end that allows me to take
> the outputs of a query and do things with it (such as calculating running
> sums and averages, for instance). So, if things become too expensive for
> standard SQL, I just do without.
> In the past, I have maintained my data in an Access database and
> developed a pretty extensive set of forms and reports to input and extract
> data. I moved to SQLite because I wanted to move off a proprietary
> platform onto a free one. And SQLite is faster and includes more SQL
> functionality like CTE's also.
> But I miss the nice front-end with forms to take inputs (especially
> parent and child forms to input data related to foreign keys) and the
> reports to format my outputs the way I wanted them. I could also do
> running sums and averages, percentile scores and other things that require
> looking at a data dump of an entire columns of contents to do efficiently.
> I am familiar with programming in C and Java, but none of my
> programming has been for the windows platform (except for the programming
> inside MS Access, which was done in VBA). I have never developed GUI front
> ends with forms, buttons, etc.
> 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.
> Thank you very much.
> Balaji Ramanathan
> sqlite-users mailing list
sqlite-users mailing list