Simple database for HTA

Question

I was instructed to create a pair of databases for local use in our office, one for registering calls with diseases, and the other for registering a taxi.

I have no way to install new software on machines that will be used to develop the application, or on computers that will use the application, so unfortunately, xAMP-based applications will not. Excel is available, but I would prefer not to go this route as I want to provide a clean user interface.

So, I am looking at creating an application based on HTA. The question is, I can’t find a simple and easy to use solution for storing database type data for an HTA application. Do I need to write something from scratch, or can someone recommend something that I can use?

Answer 1

You can try the SQLite ActiveX shell, such as SQLite COM or SqLite2X .

Answer 2

If you can’t install anything ...

• You should be able to connect to ... dun dun dunnnn ... Access the database using ADODB.Connection - An example of VBScript is here , but the API must be portable to JScript, for example http://www.kuro5hin.org/story/ 2005/7/14/13942/7643

• A quick and dirty idea is to store everything in a JavaScript Object and read / write JSON to / from a file.

Answer 3

You can also use XML using smthn: http://msdn.microsoft.com/en-us/library/ms762708%28VS.85%29.aspx

but in my opinion MDB (msaccess database) is the best way:

• no external requirements in xp, vista, seven and 8
• this is a real DB (triggers, indexes)

Answer 4

You can use something like Ragic instead of writing something from scratch. You really do not need to code anything, and your colleagues will not be too puzzled, as it uses a spreadsheet interface such as Excel. In addition, it is a cloud database on the Internet, so you do not have to install it on office computers.