Simplified versions of the situation:
I have two Company Files...A and B.
I have two users Admin and Fred.
Fred can successfully open both A and B.
Admin can only open A, and get a password failure when trying to open B.
Same occurs on hosting computer and on other computers in the network (using Multi-User Mode).
Why can't Admin (yes...THE Admin) open Company File B?