I forgot to post how my tables are set up:

tblLogin:
username
name
password

tblSales:
key
salesID

The username from tblLogin will match an entry in salesID, ie. username = CD, salesID = CD.

The login 'admin' needs to access the entire database.

I'm new to programming in asp. I think it's an if statement like if username = "", where username=salesID, then... I'm really not sure though!