I have user security level setup with username and password.I have set forms and tables etc to security levels.what i am having trouble with is setting user security levels to command buttons on the switchboard.Example if you sign in Mary Jones and you click on the command button (open Tom Smith switchboard) button on the main switchboard and your not tom smith you get a message access denied.
Code:
Private Sub Form_Open(Cancel As Integer)
If Forms!frmLogin!cboUser.Column(4) <> 2 Then
MsgBox "you cant open this form"
[code]...
it is a switchboard page. and putting CoCmd.OpenSwitchboardPage that does not work either..when you look at the event on click of the command button a macro opens up but I dont see how you can edit it.
I have created a new database which i have split using the database splitter creating two files, the front end (.accdb) and the back end (.accdc)
The front end works find it allows me to input data and can be used my multiple users as once,however when i come to add a new table or new field within an existing table i get the following error when opening the .accdc:
currently the database in on my C drive however i have also tested it on the network and i am still having issues?
i have edited the access trust settings and trusted both the c drive and the network directory yet i am still having no luck?
I have a new staff member in my office that has informed me that she has a degree of dyslexia. To assist her I've trialled changing the textboxes on one form in my Access 2013 application to a light pink color & this has instantly worked for her to read/input text.
Is there a way to automatically change each textbox to light pink on every form in my application on startup based on user login (say using an IIF statement in the OnLoad event of the startup form).
I need to launch the database on the server as a multi user. Only one station can change the designs and major issues. But other stations have the right to add/edit/delete data. I tried that through security account and permission. It works on the admin, but not with other user login. How can I link the access user to my server user login?
As I'm sure many of you know, Access '07 no longer supports user level security.
My question to you all is, how do you secure your DB's in '07? I just built a DB that stores patient data, and it needs to have some type of user authentication to gain access to it.
I know I can assign a general password to it, but I need each user to have their own username and password.
Why the new format .accdb does not support user-level security? I know Access 2007 still supports the old format .mdb, but why is it deprecated in the new one? Does microsoft want us to buy SQL Server instead of Access to support user-level security?
Has anyone seen any good links to explain why Microsoft discontinued User Level Security in Access 2007? If so can you post the links. There is a debate at my work and I want to get all the infomation possible. It is my understanding that the beefed up the encryption on the standard password so the did away with ULS.
I have a question about user level security / access control.For my database I have a back-end containing the tables and a front-end with forms, queries and everything. I have set up the access user level security.Dependent from the access level of my users, some front-end options will be hidden and some queries retrieve only part of the data. For example: I have a form to calculate clients' end prices. A vendor can only see prices for his own clients, not for other vendor's clients.
BUT: to make the query work, all users need access to the tables and the back-end must be stored in a public place, right? Now all vendors can just open the back-end and see all information.Maybe protect the BE with a password and store this in the queries?
I have created a switchboard that has 8 more sub switchboards. They have got items from 1 to 8. My database is setup with users and their authorised access levels. Admin has level 1, Manager level 2, Users Level3. Now what i want is that when admin logs in all the items in the switchboard must be available, but when a Manager with leve 2 or a user with level 3 logs in to the database then certain items on a specific Switchboard must be diabled For example lets say Sub Switchboard No 3 and its item number 4 (SwitchboardID = 3 and Item Number 4) should be disabled. I tried searching it on the Forum but no use. All i request you is to help me in this issue.
I'm a SQL Server DBA and have a few Access 2010 Db's to look after and occasionally have to make amendments to (as is the case today). I've been asked to apply permissions to certain users of the Access database whereby users in a group we're calling 'Viewer' only have read permission and users in another group called 'Writer' (original I know!) have both read and write permission.
The database is form driven (i.e. no-one directly accesses and amends the tables in the database), the file is saved with a .mdb extension.
I've played around with the 'Manage Users & Permissions' in the File Menu however these don't seem to do what I need them to and only result in having to input a user and password to access the database on start-up.
I have a switchboard on which I have items which when clicked should bring up forms or other switchboards but do nothing. They just play dead. They did work in the past (i.e in the last hour) but don't anymore. I haven't edited anything on the switchboards or the forms beng called so am a touch puzzled
I have two versions of the switchboard items table. (A2003 switchboard). I have a login form, and I want to be able to change the switchboard items for different users
so I have code that does this
close the switchboard, copy the new switchboard items table reopen the switchboard
And every time, it says it cannot copy the table because the switchboard items table is in use. The code in the switchboard opens recordsets, and I have quadruple checked that they are closing correctly, after use. The switchboard itself is bound to the switchboard items table
I have just tried something different which is to manually close the switchboard - and then I CAN copy the tables.
Might the code be atomic in some way. The switchboard does not release the locks until the code completes?
I thought about it, and got round it now, by just copying the data from the new table to the master table, rather than trying to copy tables, but I am still curious.
Hi i have a question which i hope someone can answer.
I have a database which has a switchboard as the main navigation throughout the database. (no options of toolbars are visab;le within this database). Due to this i have to keep the administration area of the database on the switchboard which is far from ideal because at the moment anyone can click on the menu item for the administrators area and enter it.
What i want to know is, Is there anyway that i can add security to a command button on a switchboard, i.e add a password.
Thanks in advance for your help guys, look forward to hearing your responses
I have two options on the main switchboard page and when I click on the second option it goes to a secondary page that gives me 3 options with the third option being to return to the main screen. When I select that option it does go back to the main screen but then on the main screen it shows the return to main screen option as well and when I select it.... it says " There was an error reading the switchboard items table." But I want the main screen to only show the original two options only.
I have a switchboard that contains 3 reports to be accessed by the MD,4 reports to accessed by managers, 6 reports to be accessed by the sales people and 2 reports accessed by accountants.How do i set a password so that each group of users views its respective reports?.Am good in VB but i don't know how to implement this security setting in a switchboard using a code. Please help! I will really appreciate.
Hi all - I'd like to create a menu for 3 different users so the menus will pop up when each respective user opens the database. I'd use a switchboard but I want more freedom in my form. Is there a way to do this in access? For example, I'd like Menu 1 to automatically open when USER 1 logs on, Menu 2 to automatically open when USER 2 logs on, and so on. I've set up security already and know how to use the startup, Display Form/Page item under tools. I just need to open different menus depending on the user. Any ideas would be of great help. Thanks much.
I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.
Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.
I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)
I am trying to find out if there is a way to track the order in which items are selected from a list. I am a dabbler and any keyword searches that I can think of don't bring up what I am looking. So, here is what I am trying to do:
I have a table of symptoms with 3 fields (ID, Category, and Symptom).I have a combo box that will allows the user to pick a category (using select Distinct on category field). I then have a list box populated with all the symptoms that have a category of whatever the user selected. The problem I am having is that I need to somehow track the order in which the user selects symptoms and then save that order for future reference and to be printed on a report. The order is important because the most severe symptom needs to be listed first.
I am begining to create a IT support database for my company. I have never really needed to use secuirty for the other projects that i have completed but this one is a bit different. i have used the security wizard to create the users and groups but would like to get the basis of the security correct before i go any further.
My question is how do i configure it so that users can only update or change or delete thier own entries apart from me who could alter anything. Do i begin now when i am setting up the tables or is it a bit more complex and would require checks during accessing forms etc.
I am currently looking into some of the security aspects of Access, as I am still not yet sure how i'll be designing a new database program, (whether to use Delphi to link to the database or run the database through Access itself) however, I was wanting to look into the security aspect of Access itself as part of my education and decision making process. Now I have deduced (correctly?) that some of the user/group access rights are based on the NT/2k/XP User/Group permissions etc, yet I was wondering if there was a little more to it than that.
In some ways I would like the application (through access or otherwise) to initialize with a logon prompt, that would ask for username and password. The database would internally?? retain the password information for security rights. I'm not sure if i'm thinking this through correctly, so i decided to come here for a few pointers in the right direction. I'd like to set up internal to the database a set of groups and users with different levels of security. I don't want them based on the XP user account passwords and such, but just an internal database login. This would allow, to some degree, a specific master group to add / remove users from the database, as well as control user access rights to the database internally. More or less, I want the database itself to be self-contained with all security and access rights, instead of basing them off of some external NT based security information. So to my actual questions:
Is this possible? Where would I start looking to set this up?
When i implement user security on my access database at home with user ID's and passwords, i need to take this database and copy it into another computer at work. However, when i open my access database on other computers at work, there is no prompt for a login password or user ID.
Hey, when i set up user security at home on a database and save this database to my USB memory stick, i then take this memory stick to be open on another different computer at the internet cafe. However, when i open the database on another different computer there is no prompt for log in user names and passwords. This is not what i want.
I have created user security with limited access for specific groups to certain forms in my database.
However, when a user attempts to open one of the restricted forms a Generic Microsoft Access Message Box opens. Am I able to customise this box so that the box Heading is not "Microsoft Access" and so that the user is not offered the option of "Help"?
Really all I want is a box that says;
"You do not have the permission to open this form."
I only want an "Ok" box as an option (not the "Help" box as well)
Hi, I need to add a security feature to my database. Basically I want different users to access the database with different permissions. I want a "basic user" to be only able to access the the forms with their respective default settings. I want an "admin" to obviously be able to access all the content and edit the design. I know I can do this with User-Level Security somehow, but i've tried it and it isn't working like I want it to. DOes anyone know or have any experience with this security feature.
