Member Avatar for rubyscye

Hi all, not sure if this is the right place, but i'll give it a go

I need to create a short survey, 7 questions all likery scale (1-5) with some comments blocks. Making the form using HTML form controls i understand just fine...

here's where i am a bit lost. This survey will run on a closed network: there is no web server and no connection to the internet, they are just a group of networked computers.

I want to capture the user's answers and store it in a database that will be sitting on a network shared drive.

Any ideas on how to do this? I'm guessing I need to set the submit button to go to maybe another page with some scripting or programming to insert the data into the database, but i've only ever really used ASP and such which needs IIS and web servers to work....

Looking for suggestions or if anyone has done this before as well.

Any help is appreciated, Thanks!!

  • 2 Contributors
  • 3 Replies
  • 96 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by cguan_77

Dani AI

Generated

A few practical ways to collect the 7-question Likert survey on a closed LAN (no internet). Two workable approaches depend on whether you can run a single host service or must avoid installing servers on the network. mentioned VBS — that idea is viable; pointed toward using one machine as a host. Below are concrete, low-friction choices and the tradeoffs for a school environment.

Option 1 — HTA / VBS front end (fast, no server install)
Create an HTA or small VBScript that presents the HTML form and writes submissions directly to the shared folder. Store responses as CSV lines or use ADO to insert into an Access file on the share. Use a per-submission filename (for example response_YYYYMMDD_HHMMSS_user.csv) or append with proper locking to avoid collisions. Key cautions: give the share correct write permissions, test concurrent writes (Access has limits), and remember HTAs run with broad privileges — only deploy inside a trusted network.

Option 2 — Tiny LAN web service (more robust, slightly more setup)
Run a lightweight app on one stable machine (Flask, Node, or a small standalone server) that accepts form POSTs and writes into a central store (SQLite is simple and portable). This centralizes locking and logging and handles concurrency better than direct file appends. You will need to open a port on the host and set share/DB permissions. For quick static hosting, Python’s builtin server is handy; for form handling use a minimal framework and write to SQLite.

Practical checklist before roll-out
Decide based on admin rights: if no install rights, go HTA/VBS+CSV/Access; if a host and firewall access are available, run a small web service + SQLite. In all cases test with concurrent clients, set share permissions, add timestamps/unique IDs, and keep nightly backups. For reference: Python http.server and SQLite home.

Recommended Answers

All 3 Replies

Member Avatar for cguan_77

does your office have a local intranet? if don't have then you need to install one and configure it to achieve what you want..check out this site it might give you an idea..

search Google on how to configure and install intranet.

Goodluck!

Member Avatar for rubyscye

does your office have a local intranet? if don't have then you need to install one and configure it to achieve what you want..check out this site it might give you an idea..

search Google on how to configure and install intranet.

Goodluck!

Thanks for reply :)

It's a schoohouse enviroment, and what i am told is the classrooms housing the computers are just networked together but nowhere near a web server so that .asp, .jsp, .cfm and such wouldnt work.

I was thinking maybe i have to do this with a VBS script? I just am not sure where to even see if there are an examples or tutorials that explain what I'm trying to do.

Member Avatar for cguan_77

i'ts networked right..so all the computer are connected to a hub..what OS are the PC's running?
if one of the PC'S is running XP pro..you can configure IIS, and use that as a web server..
so it would be something like this..
and every workstation can access to your local intranet web...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.