Users/Group problem

  • Thread starter Thread starter juan
  • Start date Start date
J

juan

Hello,
I was trying to set up users/groups to add a user as the
admin. I did this but I accidentally deleted the Admins
from the Member section. Now it only shows USERS. But it
doesn't give me option to add/create. Seems as when I
deleted the Admins from the Member. So not sure if there's
a way around this.
Please advise any help.

thanks,

Juan
 
juan said:
Hello,
I was trying to set up users/groups to add a user as the
admin.
Click to expand...

Did you first create a new workgroup information file? If not you are
modifying the standard system.mdw that ships with Access, and you really
don't want to do that. If you want to secure a database, please download
and study the security FAQ available from

http://support.microsoft.com/?kbid=207793

Be sure to follow every step outlined or your database won't be secure.
I did this but I accidentally deleted the Admins
from the Member section. Now it only shows USERS. But it
doesn't give me option to add/create.
Click to expand...

If I understand you correctly, you've gone to Tools, security, User and
Group Accounts and added a new user. Automatically that user will be made a
member of the Users group and nothing else. To add them to the Admins
Group, you select Admins under 'Available Groups' and click on the Add
button to the right.

But as I said, you shouldn't go any further before reading the FAQ. Other
good sources of information are
Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

Lynn Trapp's
http://www.ltcomputerdesigns.com/Security.htm

Jack MacDonald's
www.geocities.com/jacksonmacd
 
Hello Joan,
thanks. Yes I created a new workgroup Info file and yes I
was doing the tools,security etc. There were three tabs
before now there are only two.
USERS and Change Logon Password. But the new,delete and
clear passowrd buttons are not working. Here's what I have.
User
Name Admin
Group membership
Available groups
 
Sorry my last post was sent but wasn't finished.
here's what I have
Under AVailable groups: Member OF:
Admins Users
Users

Before there was Admins under Member of but I deleting
this.

So I think this is why the Buttons dont' work.
Is this clear?

Please advise .
thanks,
JUAN
 
Hi Juan,

JUAN said:
Hello Joan,
thanks. Yes I created a new workgroup Info file and yes I
was doing the tools,security etc. There were three tabs
before now there are only two.
Click to expand...

Well that is odd; there should be three tabs - Users, Groups, Change Logon
Password.
I cannot think of a case when the Groups tab is missing. I suggest you
backup your databases and try a reinstall of Access.
 
Hello Joan,
thanks. In my last post I mention that I deleted the Admin
from the members group, so I think that this might be the
case. I don't know why I see only two tabs. Thanks for
assistant me.

Juan
 
Hi Juan,

Juan said:
Hello Joan,
thanks. In my last post I mention that I deleted the Admin
from the members group, so I think that this might be the
case. I don't know why I see only two tabs. Thanks for
assistant me.
Click to expand...

There is no built in 'members' group, only Users and Admins. When you
secure a database, you create a new user, make them a member of Admins
group. Then you exit Access and log back in as this user and remove the
builtin Admin user from the Admins group.

I don't understand what you mean by the members group.
 
Back
Top