Identify who is updating a database MS Access

You can build a login system, and then "stamp" the records with the users name. Or you can capture the Windows username and use that.

There is no builtin facility to manage this, however. You'd have to build your own. Allen Browne has a great writeup on creating an audit utility:

http://allenbrowne.com/appaudit.html

Or you can just "stamp" the record when the user begins to edit. You would do this in the Dirty event, perhaps. Add fields to your table for UserName and LastUpdated, and then do this:

Me.UserName= YourUserName
Me.LastUpdate = Now()

The link to Allen's site has code to get that username:

http://allenbrowne.com/AppAuditCode.html

Using the "stamp" method, what is to prevent someone from signing in under someone else's username and entering data?   What I'm trying to do is ensure that the person supposed to be answering the questions is actually the one answering them.  In a situation like this, would I be the one to send out the usernames to the individuals and those usernames would serve as a passwords?

What I'm trying to do is ensure that the person supposed to be answering the questions is actually the one answering them.

Other than physically monitoring the session, you can't ensure this. Even if you send me a username/password that is tied my "identity", I could still get my wife to enter the data for me by giving her that information. Or I could open a session on my machine with the username/pass, and leave to get coffee (without logging off) and someone else could take up the session and enter/modify data.

In other words, machine based authentication and data security can only go so far, regardless of the platform you're using. If you think that a user would knowingly try to enter data under another login - and if that is important to you or your business - then I would respectfully submit that your troubles are deeping that data auditing.

I was expecting a response like that.   Unfortunately, I'm finding out on here that I have spell out my explanations in complete detail instead of leaving certain things to be inferred.

Of course a user may give his user name or password to someone else.  Of course, a user may leave a session open and someone else sits down and takes over.  That doesn't concern me.  I want to send an email with an interface attached to a recipient and be able to identify that that recipient (or anyone associated with him or access to his equipment) is the one answering the questions.

As an example, let's say I sent an interface to Manager Joe Smith. He opens it and says to his secretary "come here and sit down at my desk and complete this questionnaire for me."  I couldn't care less that his secretary is actually the one completing the questionnaire. As far as I'm concerned, the email was sent to Joe Smith and therefore Joe Smith answered the questions. And I want to be able to record that Joe Smith answered them.  One thing I can say is that everyone is on a network computer and therefore has to sign into the main system with a user ID. Can't that user ID be picked up and written to a file?   Or maybe the email address the interface was sent to be picked up and use that as an identifier?