Hi garyd1234
Try this and see if this helps you...
Creating Changing Passwords
Start Microsoft Access by using the workgroup the user account is stored in, and log on using the name of the account for which you want to create or change the password.
You can find out which workgroup is current or change workgroups by using the Workgroup Administrator.
Open a database.
On the Tools menu, point to Security, and then click User and Group Accounts.
On the Change Logon Password tab, leave the Old Password box blank if a password hasn't been defined previously for this account. Otherwise, type the current password in the Old Password box.
Type the new password in the New Password box.
Retype the password in the Verify box, and then click OK.
Guide lines for passwords:
User names can range from 1 to 20 characters, and can include letters, accented characters, numbers, spaces, and symbols, with the following exceptions:
The characters " \ [ ] : | < > + = ; , . ? *
Leading spaces
Control characters (ASCII 10 through ASCII 31)
To clear a security account password:
To complete this procedure, you must be logged on as a member of the Admins group.
Start Microsoft Access by using the workgroup information file in which the user account is stored.
You can find out which workgroup information file is current or change workgroups by using the Workgroup Administrator.
Open a database.
On the Tools menu, point to Security, and then click User and Group Accounts.
On the Users tab, enter the user account name in the Name box.
Click Clear Password.
Repeat steps 4 and 5 to clear any additional passwords, and then click OK when you have finished.
Hope this helps you
Gemini32