Access locks up after I select the reviewer, and I have to hit ctrl-alt-del
and close access.

"John Vinson" wrote:

On Wed, 19 Apr 2006 12:33:01 -0700, One confused underwriter One
confused 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.

owwww....

I hate to tell you how many times I've heard THAT line.

The only good thing about it from my perspective is that (as a
consultant) it usually means "Billable Hours" - *lots* of them,
typically.

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.

That's better than most.

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.

Please post a bit more information. Are you entering this data on a
Form (good) or directly into tables (not the best idea)? WHere are you
entering the name? Do you get any error messages? What "freezes" - do
you need to Ctrl-Alt-Del and shut down Access, or what?

John W. Vinson[MVP]