i want to create a form for people to fill in. after its filled in i want to import all the info into Access. what do you guys think is the best way that is the most user friendly?

 

create an access form?

 

assuming that most people don't have a lot of software. so either word, excel, pdf, or online form?

 

web application?

 

im trying to do it in excel right now. only problem is excel is not the most lockable or protectable thing. even if i lock it i just know some goofball is gonna unlock it by running a macro and screw around with the equations and such. not to mention embedding viruses

is there an easy way to put an online form?

 

you dont wanna try web app?

 

don't know how to do it on said web

 

your host might have a template?
otherwise with a bit of searching you might find something

 

use .net and make a db connection to an access db......then, put your form on a webserver.