H
hamking
I've tried setting up an access database using the following steps
described below from Microsoft's knowledge base:
http://support.microsoft.com/support/kb/articles/q254/3/72.asp
The steps as described below:
1. Open the Workgroup Administrator (Wrkgadm.exe) file and create a
new system database (System.mdw) that has a unique Name, Organization,
and Workgroup ID.
2. Start Microsoft Access and open any database.
3. On the Tools menu, point to Security, and then click User and Group
Accounts. Click the Change Logon Password tab, assign a password to
the Admin user account, and then click Apply.
4. In the User and Group Accounts dialog box, click the Users tab.
Create a new user account, and then add the account to the Admins
group.
5. In the Name box under User, click Admin. Remove the Admin account
from the Admins group, and then click OK.
6. On the File menu, click Exit. Restart Microsoft Access.
7. Create a new database.
After you have named the new database, and then clicked OK, the Logon
screen appears.
Note that this is different from earlier versions of Access, where the
Logon screen appears before Access starts.
8. Type the name of the user that you created in step 4. Leave the
password blank.
9. On the Tools menu, point to Security, and then click User and Group
Accounts.
10. Click the Change Logon Password tab, type a password, and then
click OK.
11. On the Tools menu, point to Security, and then click User and
Group Permissions. Click the Permissions tab, and then click to select
Groups under the List options to display the group names in the
User/Group Name box.
12. In the User/Group Name box, click Users. Select the appropriate
object type in the Object Type box to display the various objects in
the Object Name box, and then remove the default Users group
permissions for the following objects that appear in the Object Name
box:
<Current Database>
<New Tables/Queries>
<New Forms>
<New Reports>
<New Macros>
13. Import all the objects from your original database into the new
database.
14. Create other group and user accounts as necessary.
15. Assign group and user permissions to your objects as appropriate.
16. Optional: Close the database, and then use the Encrypt/Decrypt
Database command. To encrypt the database, click Tools, and then point
to Security. This step is optional.
I've completed all sthe steps up till #13. However, it will only
allow me to import 3 of the 10 tables. The remaining 7 tables would
not import because i do not have Read Design and Read Data
permissions. However, checking the permissions for the user created
in step #4 shows that it has all the permissions. Can anyone advise
why this is?
described below from Microsoft's knowledge base:
http://support.microsoft.com/support/kb/articles/q254/3/72.asp
The steps as described below:
1. Open the Workgroup Administrator (Wrkgadm.exe) file and create a
new system database (System.mdw) that has a unique Name, Organization,
and Workgroup ID.
2. Start Microsoft Access and open any database.
3. On the Tools menu, point to Security, and then click User and Group
Accounts. Click the Change Logon Password tab, assign a password to
the Admin user account, and then click Apply.
4. In the User and Group Accounts dialog box, click the Users tab.
Create a new user account, and then add the account to the Admins
group.
5. In the Name box under User, click Admin. Remove the Admin account
from the Admins group, and then click OK.
6. On the File menu, click Exit. Restart Microsoft Access.
7. Create a new database.
After you have named the new database, and then clicked OK, the Logon
screen appears.
Note that this is different from earlier versions of Access, where the
Logon screen appears before Access starts.
8. Type the name of the user that you created in step 4. Leave the
password blank.
9. On the Tools menu, point to Security, and then click User and Group
Accounts.
10. Click the Change Logon Password tab, type a password, and then
click OK.
11. On the Tools menu, point to Security, and then click User and
Group Permissions. Click the Permissions tab, and then click to select
Groups under the List options to display the group names in the
User/Group Name box.
12. In the User/Group Name box, click Users. Select the appropriate
object type in the Object Type box to display the various objects in
the Object Name box, and then remove the default Users group
permissions for the following objects that appear in the Object Name
box:
<Current Database>
<New Tables/Queries>
<New Forms>
<New Reports>
<New Macros>
13. Import all the objects from your original database into the new
database.
14. Create other group and user accounts as necessary.
15. Assign group and user permissions to your objects as appropriate.
16. Optional: Close the database, and then use the Encrypt/Decrypt
Database command. To encrypt the database, click Tools, and then point
to Security. This step is optional.
I've completed all sthe steps up till #13. However, it will only
allow me to import 3 of the 10 tables. The remaining 7 tables would
not import because i do not have Read Design and Read Data
permissions. However, checking the permissions for the user created
in step #4 shows that it has all the permissions. Can anyone advise
why this is?