1. Open access 2000/2002 and then go file - open and select the database
2. Click on the little arrow next to the open button and click open exclusive
3. Click on the menu Tools - Security - Set database password
4. Input the new password twice and click ok
5. Your password is now set in the database

PLEASE NOTE : To undo the password feature you do the same as above except it will say unset Database password

Remember to change the password (letmein) in the script to match the one you set in the database

Set the Tv Guide to use the password

1. Open the common.asp file in the Tv Guide root folder
2. Under where the Initialise variables there is one called 'strDatabasePassword = "letmein"
3. Un comment that line so it is just strDatabasePassword = "letmein"
4. Under the strCon there is this line 'strCon = strCon & " Password=" & strDatabasePassword &""
5. Un comment that line so it is just strCon = strCon & " Password=" & strDatabasePassword &""
6. Now the password has been added to the connection string and the script will use it.
7. Repeat the above on the common.asp in the admin folder.