No permission to use file problem

Archived from groups: microsoft.public.win2000.security (More info?)

Hello,
I had posted this before in the Access groups but it looks like it is more
of a Windows security problem. I hope someone can help.

I have an Access app that has a FE.mde and Temp.mdb on the user's local
drive and BE.mdb on the fileserver.
Temp.mdb and BE.mdb are linked to FE.mde
The FE.mde uses Temp.mdb store lookup tables and temporary data during the
session. It is never deleted or recreated.
My programs don't mess about with any windows file permissions.
All users are Win2000/XP in a 2000Server domain.
OpLocks is off
All users have modify/read/write permissions on the folder and the Admin has
full control. All files are set to inherit folder permissions.
The weird thing...
User A is an Windows Admin user.
User B is not an Windows Admin user.
User B logs into Windows as B and runs the app no problem.
User A logs into Windows as A and runs the app no problem.
User B logis into Windows as B and runs the app. FE.mde opens but stops and
says No Permission to use Temp.mdb

When you check the windows file security settings all the windows file
security settings on Temp.mdb are gone and only User A and Administrator
have permissions to Temp.mdb and the option to inherit permissions is off.
FE.mde has all of its normal settings - no change. Only Temp.mdb is
affected. To fix it an Administrator has to log in, put back on the option
to inherit folder permissions.

Are there some special combination of windows file permissions that I should
use? I've asked my network guys but they say it should work.

Thanks a lot
Brian