On 2016/05/30 7:09 PM, Balaji Ramanathan wrote:
The strength of Access is not in having a good built-in front end, but in
giving the user the ability to build a good custom front-end. Forms and
reports with a visual basic based programming language (VBA) behind it to...//
Ah ok, but those are not real applications - they require Access to be
on the target machines. Those are essentially scripted forms running on
Access to deal with data, a complication by any standard. It's M$'s way
of making something feel like programming your own system when your
really you are not. Why not simply do it for real? Access is not less
complicated than any other - It hails from the days of Mail-Merge and
other once-great ideas that's been usurped by modern accessibility. The
reason there are no other systems like Access, and no-one else bothers,
is a testament to how useful it is. I am willing to venture out and say
that the only reason Access had any survivability is that it comes
bundled with Office[1].
If you try your hand at some programming, there are myriad platforms
available where you can build custom applications requiring Zero
pre-installed applications, all with arrays of custom text boxes and
what all to make displaying/editing data a pleasure for the end user.
And you can connect to any DB with such a system, not just SQLite. you
could even find those that still use VB, but probably C or such would be
better. MSVC and Lazarus (among others) are both excellent and free.
Delphi is probably by far the best rapid development tool out there,
faster than Access at making multi-tier data applications, and then use
the same code over Windows, Mac, iPhone and Android, but it is also
really expensive (though you only pay for the tool, with Access you have
to pay per end user!).
On the other hand - if you really like Access, it can be used with
SQLite too. Here is a quick guide:
http://sqlite.awardspace.info/syntax/sqliteodbc.htm
[1] - If the above sounds like I am strongly opposed to Access - I'm
not, I think it's a great tool for some very specific uses - but should
be avoided for any other uses.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users