Hello Rickey,
you are in the right way, you should have be and fe, and then you dispatch your fe database as accde file to users where they can use,
first you need to setup a customized login and logout procedure, your users table should have, ID, UserID, UserName, UserPass, UserStatus...