Hello,
I have an 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
Temp.mdb is used to 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
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 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, change the option to inherit
permissions to on.
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