Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / August 2005

Tip: Looking for answers? Try searching our database.

Folder permissions for a split database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Amit - 29 Aug 2005 21:54 GMT
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
Thanks guys!

-Amit
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.