I built an Access 2003 survey database and want to send the forms I developed to 15 geographically dispersed company employees to fill out. We have internet access, intranet and shared drives.
The idea is to have them fill out the forms, and then I will take their data and append to my master database tables. I was thinking of cloning my master database 15 times, and sending each one a MDE version, with the standard forms and tables, and then getting the data filled out by the standard forms, and then appending the individual tables into the master tables. But I think there must be a better and easier way.
Is there anyway I can just email the forms (or tables) to the 15 people, they fill it out, and then email back to me?
Or, alternatively, I put my database on a company shared drive and let them input directly to the database.
Or, alternatively, put the database on the intranet or something?
Thanks for your responses.
The idea is to have them fill out the forms, and then I will take their data and append to my master database tables. I was thinking of cloning my master database 15 times, and sending each one a MDE version, with the standard forms and tables, and then getting the data filled out by the standard forms, and then appending the individual tables into the master tables. But I think there must be a better and easier way.
Is there anyway I can just email the forms (or tables) to the 15 people, they fill it out, and then email back to me?
Or, alternatively, I put my database on a company shared drive and let them input directly to the database.
Or, alternatively, put the database on the intranet or something?
Thanks for your responses.