First, what version of Access was the original database written it?
Are you using the same version or a newer one?
If it was written in an older version, have you converted it?

If that is not the problem, open the form you are using to enter the
person's name and see if there is any VBA code associated with the form and
specifically with the control where you enter the name. I would first look
to see if there is a before update or after update event for the control. If
so, put a break point on the first line of code, swith to form view, enter
the name and trace the code until it fails.

See what happens and post back.

"One confused underwriter" wrote:

I'm working on a database that stores a series of company audits that are
done every year. I was handed a database that was supposed to be near
completion (only a simple error or two) and I was asked to complete it. I'm
relatively new to Access (used it before in college but it's been a couple of
years now), and my question might be rather vague. I've made sure that all of
my information is correct, there are 3 tables and all keys are clearly
defined, correct, and relationships have been formed between the 3 tables.
I've gone over this database with two other associates who have more
experience than I do. We all agree that the database looks fine and should
work. However, whenever we start up the database it allows us to enter in the
name of the person who is doing the audit (which puts that person's name on
all audits they enter. But just after that point, the Access freezes. I have
no idea why and I was wondering if there might be some common bugs or certain
areas one should typically look first to find a solution. Any suggestions
would be VERY much appreciated.

Thank you all very much