I pick one of them, open a new form and complete the edit. " No Problem"

The next line fires off a post, updates the display and done.
I've done this many times now. BUT
This time it takes almost 2 minutes to complete the post.

Even the monitor seems to reset during the search.

There is a primary key on the database and two other fields that are part of the indices.

What could make a simple post go on and on for this amount of time?

--
JMAC out

Deadlocks in a wait transaction state would cause it since you are editing a record.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

I pick one of them, open a new form and complete the edit. " No Problem"

The next line fires off a post, updates the display and done.
I've done this many times now. BUT
This time it takes almost 2 minutes to complete the post.

Even the monitor seems to reset during the search.

There is a primary key on the database and two other fields that are part of the indices.

What could make a simple post go on and on for this amount of time?

--
JMAC out

Deadlocks in a wait transaction state would cause it since you are editing a record.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)