Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Access Security Wizard

Access Security Wizard

Access Security Wizard

I posted this question on the General Discussion forum, but I thought I would try here to.  I would like to secure my database for two types of users, read only and read/write access.  I have used the wizard, but do not feel it is informative enough to do what I need to do.  My MS Press book is also not informative enough.  I've tried to setup a workgroup info. file, but when I add users to the database, I can never login as those new users to be able to test it.  Only myself and the admin have access to the secured database.  If the wif file is supposed to store the user names and Passwords, why can't I login as one to test it?  Any help the get the security working correctly, would be great.

RE: Access Security Wizard

Read the FAQ,s under general by Elisabeth and follow the links it sure helped me understand it

RE: Access Security Wizard

On our network which run NT4 on the server and WIN95/98 on the clients we handle database access rights using the permissions property of NT4, assigning read only and read/write access to the various persons/groups as required. May be not so comprehensive as Access security but its a lot easier to achieve the desired effect!

RE: Access Security Wizard

It sounds like your user accounts are coming back with the "Not a valid account name or password" box, right? If so, it seems to me you must not be joined to the right Workgroup Information File. After you ran the wizard, did you run the Workgroup Administrator and join the new workgroup? That step is easy to forget, since it runs outside of Access.

RE: Access Security Wizard

Thanks for the help, but I figured out the problem. It was kind of stupid.  Since I could not get my test-user to login, I needed to check the permission rights to the objects in the database on both front and back-ends.  Access hides the database objects permission rights, so obviously i had none of those checked on.  I checked those on and it all works.  I hate MS sometimes and I would have never found it if someone did not point it out to me.  So, if you are using the security, make sure you have the permissions set for the database object and everything will work fine. My co-workers are using what I developed now and I will be making changes in the future.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close