Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
User-Level Security Wizard 1
- Thread starter Caryisms
- Start date
-
1
- #2
First, you must always have at least one user account assigned to the Admins group, so if you haven't already created an account for yourself and assigned it to Admins, do so now.
Then, assuming you haven't already given the Admin user a password, log on as Admin (the default) and go to Tools>Security>User and Group Accounts. Select the Change Logon Password page and change Admin's password to something other than an empty string.
Exit Access, then reopen your database. You will get a logon prompt. Logon using your own personal account. Then choose Tools>Security>User and Group Permissions. Select the Admin user in the left list. In the Object Type combo box, select each item one by one, and for each item, select all the items in the Object Name list box (it's a multiselect list). Clear the check boxes for the permissions you want to remove, then click the Apply button before you move on to the next object type.
Note that you must also do this for the Users group. Every user is a member of this group, and inherits any permissions it has.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
Then, assuming you haven't already given the Admin user a password, log on as Admin (the default) and go to Tools>Security>User and Group Accounts. Select the Change Logon Password page and change Admin's password to something other than an empty string.
Exit Access, then reopen your database. You will get a logon prompt. Logon using your own personal account. Then choose Tools>Security>User and Group Permissions. Select the Admin user in the left list. In the Object Type combo box, select each item one by one, and for each item, select all the items in the Object Name list box (it's a multiselect list). Clear the check boxes for the permissions you want to remove, then click the Apply button before you move on to the next object type.
Note that you must also do this for the Users group. Every user is a member of this group, and inherits any permissions it has.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
- Thread starter
- #3
Apparently, you have given Admin a password already, so you should have skipped the second paragraph.
It concerns me that you didn't know you'd given Admin a password, and that the reason for the error message wasn't obvious to you. I think you should consider reading up on Access user-level security before you continue. You could get yourself locked out, and have to revert to an unsecured backup copy.
In fact, if you don't have a good record of what you've done so far--what Workgroup ID you assigned to the workgroup file, what Personal IDs you assigned to your users and groups, and what steps you've taken, in order--by all means start over and make a careful record.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
It concerns me that you didn't know you'd given Admin a password, and that the reason for the error message wasn't obvious to you. I think you should consider reading up on Access user-level security before you continue. You could get yourself locked out, and have to revert to an unsecured backup copy.
In fact, if you don't have a good record of what you've done so far--what Workgroup ID you assigned to the workgroup file, what Personal IDs you assigned to your users and groups, and what steps you've taken, in order--by all means start over and make a careful record.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
- Thread starter
- #5
Rick,
I gave myself a password, not the default admin user. In the wizard, I can't seem to find where you would assign the default "admin" user a password. When I logon to Access and start the wizard it does not default to admin; it defaults to my name on the software account.
I gave myself a password, not the default admin user. In the wizard, I can't seem to find where you would assign the default "admin" user a password. When I logon to Access and start the wizard it does not default to admin; it defaults to my name on the software account.
- Thread starter
- #7
Rick,
I am running Access 2002 SP-2 on a Windows XP machine. Where in the world is the "Admin" user? Do you have to run the wizard from wherever the file is going to reside inorder for it to work? I was running from my hard drive and trying to put the db out on the network. Thank you.
I am running Access 2002 SP-2 on a Windows XP machine. Where in the world is the "Admin" user? Do you have to run the wizard from wherever the file is going to reside inorder for it to work? I was running from my hard drive and trying to put the db out on the network. Thank you.
Slow down. Your questions are jumping all over. By the time I get enough information to address one, you've asked three more. I--or you--could lose track of where we are in the conversion, and then we'd just have wasted each other's time.
The Wizard builds a workgroup file, and gives its Admin user a password. That's what makes the logon prompt appear. I don't have Access 2002, but in 2000 it certainly did ask for a password, and listed it on its report as well. You did get a summary report from the wizard, didn't you?
The Admin user is defined in the workgroup file. In fact, it's in every workgroup file, and except for the password (which can vary from one workgroup to another) is always the same.
I'm not even sure what you mean by "where is 'Admin'". Is it that you are looking for Access to put "Admin" in the logon prompt? That won't happen. Whatever account you last logged on with is what appears in the prompt--but you can easily overtype it.
"Do you have to run the wizard from wherever the file is giong to reside in order for it to work?" Again, I'm not sure what you're asking. All the evidence, as I can see it, is that the wizard DID work. It secured your database and created a secure workgroup file to go with it.
Let's get resynchronized. What exactly is not working the way you want/need it to?
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
The Wizard builds a workgroup file, and gives its Admin user a password. That's what makes the logon prompt appear. I don't have Access 2002, but in 2000 it certainly did ask for a password, and listed it on its report as well. You did get a summary report from the wizard, didn't you?
The Admin user is defined in the workgroup file. In fact, it's in every workgroup file, and except for the password (which can vary from one workgroup to another) is always the same.
I'm not even sure what you mean by "where is 'Admin'". Is it that you are looking for Access to put "Admin" in the logon prompt? That won't happen. Whatever account you last logged on with is what appears in the prompt--but you can easily overtype it.
"Do you have to run the wizard from wherever the file is giong to reside in order for it to work?" Again, I'm not sure what you're asking. All the evidence, as I can see it, is that the wizard DID work. It secured your database and created a secure workgroup file to go with it.
Let's get resynchronized. What exactly is not working the way you want/need it to?
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
- Thread starter
- #9
Rick,
The security wizard in Access 2002 is defaulting with my network user id as the "admin" user id. If you type over it and enter "admin" as the user id and leave the password blank the database does not open. This is the reason why I am confused about the Security FAQ instructions and my version of Access. I would like to know how to make the "admin" user id appear. I think its a Windows XP/Access 2002 thing.
The security wizard in Access 2002 is defaulting with my network user id as the "admin" user id. If you type over it and enter "admin" as the user id and leave the password blank the database does not open. This is the reason why I am confused about the Security FAQ instructions and my version of Access. I would like to know how to make the "admin" user id appear. I think its a Windows XP/Access 2002 thing.
You said, "If you type over it and enter "admin" as the user id and leave the password blank the database does not open." What error message are you getting?
"I would like to know how to make the 'admin' user id appear."
No, it's not a WinXP/Access 2002 thing. The same thing would happen in any version of Access, once you've assigned a password to Admin and logged on with another user account.
To make Admin become the default logon user, you have to successfully log on as Admin, providing the correct password. I'm guessing that you're joined to your secure workgroup, you don't have the Admin password, and you're getting the message "Not a valid account name or password."
The Wizard created a report listing all the accounts, passwords, and personal IDs it created (as well as all the permissions assigned). If you printed the report, you can look the Admin password up. Otherwise, if you can open the database using your network ID, you can print the report. If you don't have the report and can't get the database open, or if you deleted the report, I'm afraid you'll have to start over with the unsecured version (be sure to read all the things the Wizard tells you).
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
"I would like to know how to make the 'admin' user id appear."
No, it's not a WinXP/Access 2002 thing. The same thing would happen in any version of Access, once you've assigned a password to Admin and logged on with another user account.
To make Admin become the default logon user, you have to successfully log on as Admin, providing the correct password. I'm guessing that you're joined to your secure workgroup, you don't have the Admin password, and you're getting the message "Not a valid account name or password."
The Wizard created a report listing all the accounts, passwords, and personal IDs it created (as well as all the permissions assigned). If you printed the report, you can look the Admin password up. Otherwise, if you can open the database using your network ID, you can print the report. If you don't have the report and can't get the database open, or if you deleted the report, I'm afraid you'll have to start over with the unsecured version (be sure to read all the things the Wizard tells you).
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
- Thread starter
- #11
Rick,
I am creating the security for the db from the beginning using the security wizard. How do you successfully logon as the admin if when you start the wizard it defaults with my network id? The wizard does not start up with the "admin" id. The report has my netword id and password located in the workgroup not "admin".
I am creating the security for the db from the beginning using the security wizard. How do you successfully logon as the admin if when you start the wizard it defaults with my network id? The wizard does not start up with the "admin" id. The report has my netword id and password located in the workgroup not "admin".
You do realize, don't you, that a workgroup can have more than one account? The workgroup has to have the Admin account--it can't be deleted. It should also have an account for your network ID, so you can log on as the administrator.
It is normal that the Workgroup Information File section of the report list Name as something other than Admin. This is not a security account name, but just documentation of who the workgroup was created for. Typical names are "Payroll Department" etc. The security accounts are listed under "Groups" and "Users" at the end of the report (at least in my Access 2000 version). You can get the Admin password from there, if you need it, though I'm not sure why you would. You don't normally use the Admin account at all with a secured database, because it should have no permissions.
At any rate, you're starting over, so you need to make sure you're doing the following:
1. Run the Workgroup Administrator and join the system.mdw workgroup. The Admin account in this workgroup shouldn't have a password associated with it, so the logon prompt shouldn't even appear after you join the workgroup.
2. Start with the unsecured copy of the database. The wizard saved it for you, with a default extension of .bak.
3. Open the database and run the wizard.
Please try to be a little more descriptive. For instance, "When you start the wizard it defaults with my network id"--Where? Which text box on which dialog page? I think the problem is mainly mistaken expectations, but I can't correct them because I can't tell what it is I need to explain. I also think you're mixing up some concepts, such as the Admin account and an administrator account (they're different), but when you're vague I can't be sure.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
It is normal that the Workgroup Information File section of the report list Name as something other than Admin. This is not a security account name, but just documentation of who the workgroup was created for. Typical names are "Payroll Department" etc. The security accounts are listed under "Groups" and "Users" at the end of the report (at least in my Access 2000 version). You can get the Admin password from there, if you need it, though I'm not sure why you would. You don't normally use the Admin account at all with a secured database, because it should have no permissions.
At any rate, you're starting over, so you need to make sure you're doing the following:
1. Run the Workgroup Administrator and join the system.mdw workgroup. The Admin account in this workgroup shouldn't have a password associated with it, so the logon prompt shouldn't even appear after you join the workgroup.
2. Start with the unsecured copy of the database. The wizard saved it for you, with a default extension of .bak.
3. Open the database and run the wizard.
Please try to be a little more descriptive. For instance, "When you start the wizard it defaults with my network id"--Where? Which text box on which dialog page? I think the problem is mainly mistaken expectations, but I can't correct them because I can't tell what it is I need to explain. I also think you're mixing up some concepts, such as the Admin account and an administrator account (they're different), but when you're vague I can't be sure.
Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein
- Status
Similar threads
- Locked
- Question
- Locked
- Question