Creating a New Administrator Account

As mentioned earlier, the Admin user is a default user used by Microsoft Jet for all installations of the Microsoft Jet engine. Because the Admin user is the same across every installation of Microsoft Jet, you want to make sure your secure objects are owned by a new account you create, not by the Admin user.

The easiest way to do this is to use Microsoft Access. You could also write DAO code to programmatically create the user.

Û To create a new administrator account with Microsoft Access

On the Tools menu, point to Security, and then click User And Group Accounts.
On the Users tab, click New.
In the New User/Group dialog box, type a name and personal ID (PID) for the new administrator account, and then click OK.
In the Name box, select the new administrator account’s name, and then under Available Groups, click Admins. Click Add. This adds your new administrator account to the Admins group.
In the Name box, select Admin, and then, under Member Of, click Admins. Click Remove. This removes the default Admin user from the Admins group.

Caution Be sure to write down the name and PID for this new administrator account, and store it in a safe place. You will need it if you ever have to re-create the account. The name and PID are case-sensitive.

Before you can log on as your new administrator account, you must set a password for the default Admin user account so that the Logon dialog box will display the next time you start Microsoft Access. When you log on as your new administrator account, you can create a password for that account.

Û To set a password for the default Admin user account

On the Tools menu, point to Security, and then click User And Group Accounts.
On the Change Logon Password tab, enter a new password for the default Admin user account. Don’t type anything in the Old Password box.
Caution Passwords are case-sensitive. Be sure to write down this password and store it in a safe place.
Exit Microsoft Access.