will try that now.

Here is something interesting...

One of our team memebers created a new Active Directory user by copying one of the failing users.  The new user now has full...

yeah - all users exist and the have public permissions to the database and select permission on views and tables and execute permissions on procedures and functions.

However, only 3 of...

I would focus on the layout.  Are you using the table control?  If so, are the fileds in the detail section of the table?