I am in the process of convincing my colleagues to build a CMS database to store all our files / customer content etc.
The challenge I have today is that due to confidentiality of the data in this proposed database it can't be stored outside of either:
(a) Our work Network or
(b) Our local laptops
I have started creating the database using forms to display the results but I wanted to use the richer functionality of HTML5 to query the database and render the results. In this way I could:
a) Store a HTML5 file which is like a search report that lists all the content based on filters etc selected by user
b) Store the underlying access database
I don't wish to use "Data Access Pages" because I believe those seem very limited visually.
I don't wish to use Forms because once again I am finding they tend to be very archaic in the appearance especially once we start nesting the forms.
I basically want to leverage all the benefits of 'client side' web programming but the benefit of database access that is typically the domain of server side programming like PHP. Yet I can't use PHP, ASP etc because everything has to stay within the 'walls' of the network or laptop.
Anyway, wanted to know what thoughts people have. The reason I suggest MS Access is that it is normally installed by default on everyone's laptop and if the network solution (no.1 choice) is not possible, at least I can set up some kind of synchronization feature that allows a localized version of that database that can be queried using HTML5 search / report features.
The option of getting a server at work or commissioning a system is not going to be possible until I get a working solution that proves the value and also gets the traction / usage by the rest of my colleagues.
Many thanks if you got this far! :-)