Re: machine level security

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 02/27/05 

Date: Sun, 27 Feb 2005 16:20:53 -0500

What operating system are you using? 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"RipperT @comcast.net>" <rippertsmith<nospam> wrote in message 
news:%23X$cOuQHFHA.2704@tk2msftngp13.phx.gbl...
> Jack,
>
> I get a:
>
> runtime error '453': Can't find DLL entry point GetComputerNameA in kernel 
> 32
>
> Any idea what that means?
>
> Thanx
>
> Rip
>
> -- 
> Ripper T Smith
> rippertsmith<nospam>@comcast.net
> "Jack MacDonald" <jackMACmacdonald@telus.net> wrote in message 
> news:b3li11534tdill0mejf6gmqhgip4kqvkso@4ax.com...
>> Yes, it is possible.
>>
>> I presume a basic understanding of programming using VBA. If you do
>> not have that understanding, then you will need to brush up on those
>> skills.
>>
>> Open a new module and paste the code from the website that I
>> mentioned. Save the module.
>>
>> Open the form in design view.
>>
>> Open the forms OnOpen event -- you can find it in the Events tab of
>> the form's properties. Enter code similar to this
>>
>> Private Sub Form_Open(Cancel as Integer)
>> If fOSMachineName <> "TheCorrectMachineName" Then
>>   MsgBox "You cannot use this form on this computer"
>>  Cancel = True
>> end if
>> End Sub
>>
>>
>>
>>
>> On Sat, 19 Feb 2005 14:09:08 -0800, "RipperT"
>> <RipperT@discussions.microsoft.com> wrote:
>>
>>>Can you help me with how to use this function. I want to be able to use 
>>>it in
>>>such a way that a form will only open if machine = x. Is that possible?
>>>
>>>Thanx,
>>>
>>>Rip
>>>
>>>"Jack MacDonald" wrote:
>>>
>>>> Access' security, which applies at the database engine level, can deal
>>>> only with users. To deal with computer names, you will need to work at
>>>> the application, or program, level. In other words, if somebody opens
>>>> your database tables directly, they can make any modifications for
>>>> which they are granted permission, regardless of the computer that
>>>> they are using.
>>>>
>>>> Having said that, you can use a function found at
>>>> http://www.mvps.org/access/api/api0009.htm
>>>> to retrieve the name of the computer that is running the application.
>>>> Your application could apply logic to, say, close the form unless the
>>>> designated computer was being used.
>>>>
>>>> The CurrentUser() function returns the name of the user who is
>>>> currently logged onto Access. You can place code into the BeforeUpdate
>>>> event of your forms to populate fields in your tables with the values
>>>> returned by CurrentUser() and Now().
>>>>
>>>>
>>>>
>>>>
>>>> On Fri, 11 Feb 2005 18:09:04 -0800, "RipperT"
>>>> <RipperT@discussions.microsoft.com> wrote:
>>>>
>>>> >Hello,
>>>> >I have user level security in place and working nicely. However, in 
>>>> >addition
>>>> >to that, I would like to implement 'workstation level' security, 
>>>> >meaning if
>>>> >users need to perform certain tasks, they will need to be logged onto 
>>>> >a
>>>> >certain workstation to do it. Is this possible and if so, how?
>>>> >
>>>> >A related question: our office has a specific once-a-day task where a 
>>>> >user
>>>> >needs to alter the data in a form and "submit" it. It is then 
>>>> >collected by
>>>> >the administrator and the data, time, date and user who submitted it 
>>>> >are
>>>> >verified. What's the best way to do this?
>>>> >Thanx to all who can help,
>>>> >Ripper T
>>>>
>>>>
>>>> **********************
>>>> jackmacMACdonald@telusTELUS.net
>>>> remove uppercase letters for true email
>>>> http://www.geocities.com/jacksonmacd/ for info on MS Access security
>>>>
>>
>>
>> **********************
>> jackmacMACdonald@telusTELUS.net
>> remove uppercase letters for true email
>> http://www.geocities.com/jacksonmacd/ for info on MS Access security
>
>

Relevant Pages

  • Re: Enabling telnet, ftp, pop3 for root...
    ... MASIVE security improvement over just having an open port sitting there. ... only OPENS THE PORT! ... While I could be wrong on that, it's the most likely scenerio with three possible levels of security: low, if you're only using a password, mediocre if you're using a key protected by a password, and relatively high if you're using a key that you are protecting with a complex passphrase and swapping out routinely. ... Point being, when there are already such networks on the Internet -- and not just in the United States -- with a wide range of ISPs, it's not at all outside the realm of possibility that somebody has a box that is listening to all the traffic on your node and analyzing it. ...
    (alt.os.linux)
  • Re: Default User Serurity Permission
    ... and then the [File Security] section. ... and once a new MMC console opens, ... > profiles, I just changed them. ... >>Restore XP to installation Security Defaults ...
    (microsoft.public.windowsxp.security_admin)
  • Re: machine level security
    ... Ripper T Smith ... In other words, if somebody opens ... >>>>I have user level security in place and working nicely. ... >>> http://www.geocities.com/jacksonmacd/ for info on MS Access security ...
    (microsoft.public.access.security)
  • Re: Finally, a secure computer
    ... > security at the IBM website is compromised, ... Therefore it is extremely unlikely that any hacker ... > a tiny system served by IIS or the PWS protect himself with the same ... > ICF which does not listen on ports but only opens to responses to messages ...
    (microsoft.public.inetserver.iis.security)
  • Re: machine level security
    ... I presume a basic understanding of programming using VBA. ... In other words, if somebody opens ... >> remove uppercase letters for true email ...
    (microsoft.public.access.security)