using vb6 to do db chores eg vaccum
(1) By fuzmic on 2022-09-22 04:59:39 [link] [source]
Hi there I am moving along with SQLite quite smoothly. Now I want to use vb6 to execute commands, I would like to start with vaccum my db .. any leads. TQ
(2) By Larry Brasfield (larrybr) on 2022-09-22 05:18:23 in reply to 1 [source]
You are going to use SQLite built as a DLL. VB6 programs can be made to load and call into DLLs, but that's a topic for a forum other than this one.
(3.1) By Chris Locke (chrisjlocke1) on 2022-09-22 07:23:35 edited from 3.0 in reply to 1 [link] [source]
I would strongly suggest not using VB6, but using vb.net.
There is a small library which is easy to plug into .net and it only takes a couple of lines.
.Net is more 'futureproof' than VB6 - VB6 barely installs on Win 10. It does, but only after gentle coaxing.
If you head over to DB Browser for SQLite discussion area I'm happy to go through the process with you. DB Browser for SQLite is also a handy GUI to get used to SQLite databases.
If you know VB6, .Net is relatively painless transition. You still end up with a small .exe which can help do what you need.
(4.1) By fuzmic on 2022-09-22 23:45:13 edited from 4.0 in reply to 3.1 [link] [source]
Thanks Chris for the kind offer on DB Browser I will certainly check our this path later. meanwhile I choose vb6 because I am used to msAccess as Front end.
Larry appreciate the lead to dll