Drew Wutka
DWUTKA at marlow.com
Thu Nov 13 12:50:56 CST 2003
Personally, my favorite setup is to use the system.mdw for users, and an 'admin' .mdw for development/maintenance. That way, the only 'special' shortcuts I need is for administrators of the database. Of course that method only works if you can clump all of the 'users' in one pile. If the users need to be split up by their capabilities, you can't use that method. Drew -----Original Message----- From: Erwin Craps [mailto:Erwin.Craps at ithelps.be] Sent: Thursday, November 13, 2003 8:40 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] workgroup file (Sec Poll spin-off) I believe I'm not with with you.... First, to set thing strait. It's only in our office for develepmont I'm speaking. Second. You mean you have a shorcut that starts msaccess.exe with /workgroup xxx? Problem with that is that you need a hard path to msaccess.exe and hard paths is something I try to avoid. I always use roaming profiles and hard paths can problematic. I supose solutions are out there, but I already played alot with them and they are often OS dependent. You know, Gustav, It's not that a big deal... It's rarely I do a repair... And I don't use workgroups anymore at customer sites. I use the network user name and match them with the users in the database (user management based on tables/forms). If a network user is unkown in the database it exits instantly (after a msgbox). Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Thursday, November 13, 2003 3:21 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] POLL: Access Security Hi Erwin In my opinion it is not a good idea to have a special mdw assigned as the default. I have a shortcut for such an Access with the wkrgrp switch opening a secured database. /gustav > I know...I know... > At least I supose you mean that you can give msaccess.exe an /wrkgrp > command line option. Or use the /profile and a profile file. > I only use MDW for developing purposes indside the office and just > want it always to be my company.mdw group... > Specifying company.mdw for default gets reset to system.mdw in the > user profile folder.... Or is it in the program Files/common folder... > ? > Don't bother, I just overcopy all system.mdw with company.mdw... > Erwin > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav > Brock > Sent: Thursday, November 13, 2003 1:56 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] POLL: Access Security > Hi Erwin > You can supply your app with your own mdw, say erwin.mdw. Office won't > overwrite that. For that kind of apps we create shortcuts (menu > entries) which makes it easy for the user to open the app with the > needed command line. > /gustav >> .. I want to add that a office repair each time reset or overwrites >> your MDW file). _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com