Re: machine level security
From: Jack MacDonald (jackMACmacdonald_at_telus.net)
Date: 02/21/05
- Next message: Bee: "Re: How do I reset the startup parameters"
- Previous message: WWV: "Protect db"
- In reply to: RipperT: "Re: machine level security"
- Next in thread: RipperT: "Re: machine level security"
- Reply: RipperT: "Re: machine level security"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 21 Feb 2005 03:32:22 GMT
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
- Next message: Bee: "Re: How do I reset the startup parameters"
- Previous message: WWV: "Protect db"
- In reply to: RipperT: "Re: machine level security"
- Next in thread: RipperT: "Re: machine level security"
- Reply: RipperT: "Re: machine level security"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
