[AccessD] workgroup file (Sec Poll spin-off)

Erwin Craps Erwin.Craps at ithelps.be
Fri Nov 14 01:39:21 CST 2003


I conclude.
(at client locations).

The user managment is insufficient from the workgrou file anyway.
Where you gnna put other data , like first, last, Dateinservice, direct
e-mail, private address, native language, date of birth.

I find for user management U most forget the workgroup and create your
own.
I don't have any form level security in my apps (next to a common
password for some functions) but that would be probably something I
goooing to be needing one day.

Erwin


-----Oorspronkelijk bericht-----
Van: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] Namens Francisco H Tapia
Verzonden: donderdag 13 november 2003 20:14
Aan: Access Developers discussion and problem solving
Onderwerp: Re: [AccessD] workgroup file (Sec Poll spin-off)


<shaking head in disbelief>  No no no no no.... the system.mdw SHOULD
NEVER BE TOUCHED.  This is just bad practice... while it makes it
incredibly convenient for a one database solution, when you begin adding
new databases they automatically go and seek the permissions from the
system.mdw, therefore all settings in that db are inherently applied to
the new databases.

Again this is all fine if you're doing this to one database for one
organization and even while you're the current developer.  But what
happens when a new guy takes over or if you are given an mdb for another
database.  You'll see weird errors that you wouldn't should you not have
messed w/ the original System.mdw.  Additionally other developers
following the Security FAQ will develop against their copy of the mdw.  

Of course I know you're the main / only? developer for access apps w/
your organization.  But things can not always be so smooth.


-- 
-Francisco


Drew Wutka wrote:

>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


More information about the AccessD mailing list