MS Access 2K, Windows XP
====================
Hi,
I have a database split into FE and BE with User Level Security, and the FE
is converted into an MDE. Each user has a copy of MDE and I'm also using Tony
Toews's Auto_FE updater program.
I have follwoing folders on the shared drive:
1. BE (for Back end database file)
2. Master-FE (for master copy of FE file)
3. MDE (for MDE file that is copied to the C: drive if it is newer than the
copy on C: drive)
4. AutoFE_Updater (for StartMDB.exe and all INI files - I have more than one
INI file as different users have MSAccess.exe in different folders)
5. Wrkgrp (for the security MDW file)
The users also have a copy of the MDE on their desktops, and are accessing
the database using a short-cut that checks for the latest version of MDE, and
uses the MDW file.
I'm aware that the users need to have read-write permissions on the folder
that has the BE file. And, they probably need to have read-execute
permissions on AutoFE_Updater folder since the INI file is read, and they are
executing the exe file.
Do they need to have write access to the Wrkgrp folder and AutoFE_Updater
folder? What would be sufficient permissions for the MDE folder?
Thanks.
-Amit
Douglas J. Steele - 29 Aug 2005 22:55 GMT
I don't believe they should require anything more than Read for the
AutoFE_Updater folder, but they'll need at least read-write for the Wrkgrp
folder. The permissions required for MDEs are no different than they are for
MDBs

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> MS Access 2K, Windows XP
> ====================
[quoted text clipped - 34 lines]
>
> -Amit
Paul Overway - 29 Aug 2005 23:11 GMT
Just to clarify...they need Full Control of the folder(s) where the BE and
FE are located....otherwise, you'll have issues with compact/repair.

Signature
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com
>I don't believe they should require anything more than Read for the
>AutoFE_Updater folder, but they'll need at least read-write for the Wrkgrp
[quoted text clipped - 41 lines]
>>
>> -Amit
Amit - 31 Aug 2005 16:47 GMT