Allow users to only add records and not see data source

[jhicsupt via AccessMonster.com]

Is there a way for me to have a basic Access form that the user can only fill
in a form? What I am trying to do is have each employee put in their
respective information. Once they put in their information, it will reside
on a server. This is a one time thing -- the employes will enter their
information just this one time.

I want to collect all of the employee's information in one table, but I don't
want any of the employees to see anyone's else.

So basically, once they have entered their information, press "Submit", which
will write to a server. I do not want them to be able to see where on the
server or the path where the information is going to be written, so I will
want to hide the code.

Is there a way to do this?

 

[Guest]

The easiest way to stop them from seeing other data, is to set the forms
"Data Entry" property to Yes. This will allow ONLY data entry.

Now it will not stop them from entering multiple records, but it will stop
them from seeing any other records.

HTH,
Larry