I have been tasked with creating a couple of databases for local use in our office, one for logging sickness calls and another for logging staff taxis.

I do not have the ability to install new software on the machines that will be used to develop the app nor on the machines that will use the app, so no xAMP based application, unfortunately. Excel is available, but I'd rather not go down that route as I want to provide a clean UI.

So I'm looking at putting together an HTA based application. The question is: I cannot seem to find a simple, easy to use database-type storage solution for an HTA application. Do I need to write something from scratch, or can anyone remend something I can use?

I have been tasked with creating a couple of databases for local use in our office, one for logging sickness calls and another for logging staff taxis.

I do not have the ability to install new software on the machines that will be used to develop the app nor on the machines that will use the app, so no xAMP based application, unfortunately. Excel is available, but I'd rather not go down that route as I want to provide a clean UI.

So I'm looking at putting together an HTA based application. The question is: I cannot seem to find a simple, easy to use database-type storage solution for an HTA application. Do I need to write something from scratch, or can anyone remend something I can use?

• javascript
• hta

4 Answers 4

You can try an SQLite ActiveX wrapper, like SQLite COM or SqLite2X.

If you can't install anything...

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

• Quick and dirty idea - store everything in a JavaScript Object and read/write JSON to/from a file.

You can also use XML, with smthn like this: http://msdn.microsoft./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,sevent and 8
• it is a real DB (triggers,indexes)

You can use something like Ragic, instead of writing something from scratch. You really don't have to code anything, and your coworkers wouldn't be too perplexed, as it uses a spreadsheet interface like Excel. Also, it's a cloud database on the web, so you won't have to install on the office puters.