So with the help of many of you on this site, I was able to build my first Access database. Thank you all.
Now that I'm all done, I have one final thing to figure out.
I have incorporated user authentication into the database for a minimal level of security. Everything finally works like it should, however there is one "flaw" I have found.
In "Access Options" I have the login form set to open when the DB is open, and navigation and ribbon/toolbars are deactivated so only the login form and "Home" ribbon are showing when the DB is opened.
The problem with this, is that a curious user that shouldn't have access could get access fairly easily.
If they right clicked the "Home" ribbon, then left clicked "Customize Quick Access Toolbar", they could change the default form to whatever they wanted. Thus bypassing the login form and nullifying any security that it offered. Ideally, there should be no ribbons or toolbars. I just don't know how to get rid of them.
Has anyone else run into this problem?
Now that I'm all done, I have one final thing to figure out.
I have incorporated user authentication into the database for a minimal level of security. Everything finally works like it should, however there is one "flaw" I have found.
In "Access Options" I have the login form set to open when the DB is open, and navigation and ribbon/toolbars are deactivated so only the login form and "Home" ribbon are showing when the DB is opened.
The problem with this, is that a curious user that shouldn't have access could get access fairly easily.
If they right clicked the "Home" ribbon, then left clicked "Customize Quick Access Toolbar", they could change the default form to whatever they wanted. Thus bypassing the login form and nullifying any security that it offered. Ideally, there should be no ribbons or toolbars. I just don't know how to get rid of them.
Has anyone else run into this problem?