Survey Database

[trixxnixon]

i have a survey database that i have built and i would like to distribute surveys company wide. The only tools i have to do this with are access, outlook, access to some shared drives , Livelink(by opentext).

does anyone have any ideas about distributing form(survey) to multiple users, via email(or other method) that links to a central table?


Thank you.

[NeoPa]

Not my area Trixx, but I think this is usually done via a web interface. You can get help for that at HTML / CSS.

It's sort of possible in Access alone, but involves distributing database front ends. Quite tricksy (pun intended).

[DonRayner]

Try looking into ASP.net, I've played with it a bit and it looks like it can be used as a front end for any ADODB compatible database of which Access is one. You can download ASP.net express directly from Microsoft. Also check out the ASP.net area of our site.

[phillikl]

Trixx,

I am in the same boat as you. Not sure how "large" your company is, but for the Navy this is how I have mine setup.

Send the database to command. They share the database to all users with modify permissions.

End user creates own unique login/password.

Survey is complete; admin returns survey via (email, cd, sneaker net, or txt output).

I then import completed surveys into an analyzer for compilation.

If your company is all on the same network, you could bypass the import feature, by just creating a Network Share and placing your survey in that folder. One thing you do need to look at.... Multi-User environment for your database.

I know its only about 2cents worth, hope it helps.

~Kendall