Re: machine level security

From: RipperT (nospam)
Date: 02/27/05 

Date: Sun, 27 Feb 2005 15:32:22 -0500

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: machine level security
    ... Ripper T Smith ... let's say you distribute your application to User1 to be used on ... >>> Access' security, which applies at the database engine level, can deal ... In other words, if somebody opens ...
    (microsoft.public.access.security)
  • Re: Setting up security level
    ... need to get a copy of the Security FAQ. ... Access Security: www.ltcomputerdesigns.com/Security.htm ... >>The others need to join the workgroup where your security ... >>a file from somebody elses computer it opens just fine ...
    (microsoft.public.access.security)
  • 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: machine level security
    ... Access' security, which applies at the database engine level, can deal ... In other words, if somebody opens ... >> remove uppercase letters for true email ...
    (microsoft.public.access.security)
  • 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)