Password Protecting Program?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Can someone give me a short way to set up passwords for two groups.

I have clerical staff that need complete access to program using one
password.

I have worker staff that need read only access to program with one
password.

There are no passwords on program right now.
 
You should repost your question in the Security news group. I think you will
get better information there.
 
Which "program" are you referring to?

Note that this newsgroup is for Microsoft Access (a database application)
and not general computer "access". If you question relates to another
application, suggest you re-post to the appropriate newsgroup for the
"program" you are referring to.
 
Randy said:
Microsoft Access 2003....................
Click to expand...
User-level security is what you need. There are links to the MS FAQ on ULS
on my web site. Be warned, it is not for newbies and has no filler; you
must follow all steps in the order stated.

Regards,
Keith.
www.keithwilby.com
 
Keith there are two things I need an understanding about and that is
the setting up of a Workgroup Name and the Admin group.

What are the implications of setting up a new Workgroup?
When I set up a workgroup I want it only to apply to the specific
application I have set up not to other applications.

Also it is my understanding that you have to shutoff the Admin
group????

Can you just set up two user groups and then let those specific groups
have one user name and password for each group?
 
Randy said:
What are the implications of setting up a new Workgroup?
When I set up a workgroup I want it only to apply to the specific
application I have set up not to other applications.
Click to expand...

You create a new Workgroup Information File (WIF) using the Workgroup Admin
tool and store it where all users can access it. DO NOT modify the default
"system.mdw". Once you have your security in place you would open your app
using a shortcut with a target line in the format

"full path to MSACCESS.exe" "full path to your file.mdb" /wrkgrp "full path
to your WIF.mdw"

which will allow you to join your custom workgroup for that session only -
all sessions started from an explorer window etc will remain joined to the
unmodified default "system.mdw".
Also it is my understanding that you have to shutoff the Admin
group????
Click to expand...

One of the steps is to deny access to the Admin *user* once you have set up
your own administration account and made it a member of the Admins *group*.
This is not by any means all you need to do, please follow the FAQ closely
and backup your files in case you lock yourself out.
Can you just set up two user groups and then let those specific groups
have one user name and password for each group?
Click to expand...
Yes (the password is allocated at user level, permissions are best set at
group level IMO).

HTH - Keith.
www.keithwilby.com
 
Keith if I do get through this process of creating the security for
this access program what happens if I need to move the program to
another county or location and set it up on their computers? Or do I
need to keep a program without security so I can set it up in each
different location?
 
Randy said:
Keith if I do get through this process of creating the security for
this access program what happens if I need to move the program to
another county or location and set it up on their computers? Or do I
need to keep a program without security so I can set it up in each
different location?
Click to expand...
If you need to deploy a copy elsewhere then you need three things - the mdb,
the mdw and the shortcut(s). Obviously you'd need to tailor the shortcuts
where necessary for the new location. Whilst we're at it, I might just
mention that, if you're deploying a multi-user application it is essential
that each user has their own copy of the Front End. If you're not familiar
with that term, search the help (might be a job for another day but bear it
in mind for now).

Regards,
Keith.
 
Keith sorry for asking so many questions, but is it best to set
security before or after spliting into Front End and Back End?
 
Randy said:
Keith sorry for asking so many questions, but is it best to set
security before or after spliting into Front End and Back End?
Click to expand...
It's probably a bit easier to split after setting up security but there's
not that much in it to be honest.
 
Keith thanks for your comments. I am just going to have to go in an
practice on a couple of programs to get it down. I just wanted to be
careful so I don't mess up anything.
 
I looked at your instructions to set security on a database. Do you
have to go through this process everytime you have a different database
you want to set passwords?
 
Randy said:
I looked at your instructions to set security on a database. Do you
have to go through this process everytime you have a different database
you want to set passwords?
Click to expand...
Depends. If you want a new workgroup then yes, but you can have many
database files affiliated to a single workgroup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel macro and passwords 3
Are password protected WiFi networks secure? 3
Windows 10 W10 password prob. 2
How to create a username and password in Access 2
Excel Protection 2
Expiration notification 4
Editorial How to create secure passwords 6
Biometric USB Drive Recommendations 8

Back
Top