var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: In need of a crash course in assigning users and permissions on an Access Database.
Please, anyone, point me in the direction of a good site or good person that can walk me through setting up users and a prompt that will verify them with a username and password.
I have tried to teach myself this aspect of Access and I am ready to pull all the rest of my hair out.
This looks like it would work, BUT... I can't find the first step. There is no file in the SYSTEM folder like it said.
Could there be a problem because I am on a network?
Let me know. Thanks,
Take a backup of your database and then proceed to stage 2.
Backups are the key!!
I'm also on a network. I found system.mdw in the following folder:
C:\Documents and Settings\"your initials"\Application Data\Microsoft\Access
I am running Access 2007... None of these options on the website given are located on Access 2007.
I have a copy of a database open, and use the securty level wizard. Is that right?
Access 2007 seems to have drastically changed the built in security. I have not used 2007, but a google search for 'Access 2007 security' turned up several hits.
Your other option would be to create a user table in your db.
If I made a table in Access that had usernames and passwords, how will that then verify who is logging in and how will it be able to disable tables and such?
My end result is to have them use a single form and not be able to enter anything else or edit anything (including LINKED tables)