Re: machine level security

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

Date: Sun, 27 Feb 2005 17:09:52 -0500

It's a Windows NT machine at work, not sure which 'version'.

Rip 

-- 
Ripper T Smith
rippertsmith<nospam>@comcast.net
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message 
news:ulcR2IRHFHA.3628@TK2MSFTNGP15.phx.gbl...
> 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: XP bootup Progress bar
    ... Rip ... To see which programs load with Windows, ... > Ripper T Smith ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: date/time shift
    ... Rip ... > Dim MyDate as Date ... >> Ripper T Smith ...
    (microsoft.public.access.formscoding)
  • Re: Code to see if a value exists in table
    ... Rip ... > Msgbox "Part 123 does not exist.", ... >> Ripper T Smith ...
    (microsoft.public.access.formscoding)
  • append contents of field to another field
    ... Rip ... Ripper T Smith ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • 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)
Loading