I have a user that has to enable the security everytime he opens a database I have. What would cause this? No one else has any issues and this user has all the permissions he needs.
View RepliesI have a database with confidential data (to be used internally only). I do not want a person opening the database to get access to the tables or other elements.
All of the security setting on all computers are set to disable macros. So anyone who opens the application now has access to seeing the table eve though I have set all the ribbons, right click, etc so no user can get to them.
Is there a way to override the security alert so I can show it in a popup prior to load?
I have some Databases that were created back in Access 97 and have managed to upgrade these databases to work in Access 2013, fixing any modules and forms which broke when upgrading the databases.User access and permissions within the database were controlled by User Level Security (the Workgroup.mdw file) which is not secure anyway I guess, as someone could easily copy the entire database.
The database as it stands now works perfectly in Access 2013, however anyone can do anything with the database which is my main issue. Im wanting to limit access for certain forms / tables / reports to certain users, then out right deny other users from accessing the database.
Ive seen the SQL Server 2014 Migration Assistant for Access, which looks to store the tables on SQL server then map these to the Access database, so i guess i could deny certain users from accessing tables that way, or only allow them to read the tables. However I'm not sure how that would lock them out of certain forms / reports and queries in the databases?
I need securing an Access database. I am about to put the database on a shared drive. I want myself to be able to do anything (of course), my co-worker Paul to be able to ONLY enter information (along with being able to view everything like forms and reports), and my boss to ONLY be able to view everything (form/report wise).
I found this post [URL] .... about how to secure a database. I spent all day doing it, but it didn't work at all! I just got a bunch of errors whenever I tried to do anything, so I deleted the database and re-used an earlier version.
I have a database whereby users already have to sign in with a username and password, using a form which them allows them to view a front page. The front page allows them to access data and add/amend it.
I now have to adjust this setup as we have directors who want to view the system, but we don't want them to amend it.
Is there anyway to change the current setup that I already have or do I have to scrap it and start again?
I was wondering if it is possible to create custom security permissions in access. For example I have created an employee database, with security. I would like to have it when a manager logs on, it will only display his employee's information and no other departments. Is this possible?? In one of the tables is a field for the department the employee works on, can it based off of a table field?
View 1 Replies View RelatedI have created a database and made the steps to the user-level security and VBA protected the project but i lost the passwords and the MDW file.
is there any way to reset the VBA pass then reset the security level?
this is very important for my business it's a school database with lots of info and it's critical for me to update or at least export some reports and forms to a new project
Why does one have to enable all macros in the trust center in order for VBA to run? I'm making front end applications with Access and having to allow ALL macros to make them user friendly makes a huge hole in general security. I don't use any macros - it's all done by VBA.
Users are on a plethora of different platforms so changing reg keys is out of the question. Is there some way of self sign an Access accde? Is there some safe GENERAL approach (trusted sites is not good either) to allowing VBA from my applications ONLY?
I need an Access 2010 function to enable/disable screensaver on W8.1
View 1 Replies View RelatedI have a form. and it has three buttons. Such as Submit, Reject, Under Observation.
I want :
1) If i click SUBMIT button it will be disable and other two buttons REJECT and UNDER OBSERVATION will be enable
2) If i click REJECT button it will be disable and other two buttons SUBMIT and UNDER OBSERVATION will be enable
3) If i click UNDER OBSERVATION button it will be disable and other two buttons SUBMIT and REJECT will be enable
Hello,
I have a very basic Access Database that is a contact resource for vendors. I have a Switchboard manager form when you open the database with the option to take you to a Form for the supplier contact information or to 2 different reports.
I have set up security so that I have full access and then a Data Entry user is allowed to edit, add and delete data but no make changes to design of the database. I also have just the minimum toolbars showing.
I set up the security and work group file with no problems. It works great on my computer but when I try to transport it to another computer, I get an error stating:
"You do not have the necessary permissions to use H:/File Name.mdb. Have the system administrator or whoever created this object establish the appropriate permissions for you."
How do I set up the database security and still have the database be portable and be able to be used on any computer?
Also, is there a way to restrict the toolbars for the common users and have the full toolbars for the administrator?
Thanks for your help.
Lisa M
Hello.
Prior to MS Access 2003 a different workgroup information file (system.mdw) could not be joined unless the user had access to run the workgroup administrator utility with the file WRKGADM.exe to create a new or join another existing workgroup information file. With the 2003 version of Access there is now a command (Tools menu then Security then workgroup administrator) to run the workgroup administrator utility within the MS Access menus. This could allow any user, once they are able to log in to MS Access, to change the workgroup information file to one that doesn’t require them to log in and has no restriction on rights for users for any database. My question is: How can I make it so users can’t run the “workgroup administrator” utility from the menu? Note: If you remove it from the menu then any user can also customize the menu to bring it back so that is not a problem solver. Any suggestions would be greatly appreciated.
I have an old Database which someone had created and they stopped using it. Now they would like to get the information from it. The problem is whenever I try to open it, it says
'You do not have the necessary permission to use the c:SGSS Database.mdb object. Have your system administartor or the person who created this object establis hthe approprirate permissions for you'
I have the secure.mdw file. when I open it all it has is a few queries with the usernames and the groups.
Is there anyway I am able to get into this database? I have looked around in the forums here, but I didnt' really get a straight answer or the solution was for a different circumstance.
Thank You
Hi, I'm working on a piece of coursework which is due in pretty much tomorrow. I've finalized everything except security. I need my database to prompt for a user name and password when a user loads up the database. If a user name and password is given that is correct, then it'll open up the database with that user's permissions. But if an incorrect username/password is given then it should deny access.The help files weren't very helpful on this, I'd be very grateful if anyone could tell me how to set up this security.[Edit] Also, I dont know how to make the database automatically open up an input form (in this case, the main menu form) when the database is opened. How do I do this?
View 4 Replies View RelatedThanks to all the folks in this forum who helped me to develop my fist access database application. Access is a great product and I really enjoy working.
I need to put this db for full scale production use and I would like to brainstorm some of your experiences on the security issues I need to address. I have like 12-15 users and everyone has a standalone version of MS Access 2003 full edition installed on their local hard drive. We do have a shared network drive (s :). I have few questions as follows:
1. Is it a good idea to split the database into front end and back end and install only the FE on individual user machines or just run the .mdb file from shared ‘s’ drive? I don’t have any experience with how the BE and FE works.
2. Currently I don’t have any user workgroup and permissions set to run on the database. Anyone can just open the .mdb file like any MS office suite applications(.xls, .doc) and start using (navigate, input data into the table through forms, search database, print reports, access to DB window, etc). Can some one advise what kind of security level should I incorporate as a minimum?
3. Under Tools-Option-Advanced TAB, I have selected No Locks under Default Record Locking and also checked “Open databases using record level locking” option box. Is it safe to keep it this way? Is it possible to lock only few records on a table? I have a situation that on a particular project (this is a decision supporting db application) after the project (project here refers to a record) is done, I want to lock these data so that no one can modify the existing data. At the same time, if they are working on a current project (record) then the user should have add/edit/delete access to that particular record. I am not sure if this (record level locking on a table) can be done.
4.In future I know that I need to modify the table design, forms, reports, modules. Is it good idea still to consider creating MDE file?
Your input is greatly appreciated and thanks a lot for your support.
Shan.
Help, please.
I have built a database for my employer which is held on a server and accessed by 8 terminals. This arrangement has been in place and worked well for 3 years. The database is secured and is accessed by users using individual user id's and passwords. Recently I have had to replace a faulty terminal. The new terminal has access to the main server but seems to bypass the security element as it gives access to the database without asking for user id and password. What do I need to do to correct this position? All the other terminals are working as they always have done.
How can I keep a user from accessing a database file from the directory? I've seen it before where if a user tries to open the database from the directory without being attached to the workgroup file it gives them a permissions error. I've set the users up with shortcuts to the database with the workgroup parameter but some users still go through the directory to open the file. When they do this, the currentUser property isn't captured. It logs them as the Admin. I want to keep this from happening. What can I do?
View 12 Replies View RelatedGood Morning,
I have been searching your wonderful forum and I have found the answers to all my questions - or so I thought.
I have 5 people who need to use the database and I need to know who signed on and added/changed data etc etc etc.
So I looked up workgroup security and hey presto :) I have security when I open the database I need to put in my username and password.
However..... when I asked my co-workers to sign on to the database they can just open it :eek: - no questions no "hows the family" no nothing!!!!
So here I am the poor administrator having to put in passwords when the rest of the world can reek havoc on my defenceless database:D
Any help greatfully appreciated
My husband and children keep telling me humour is not my strong point and having read some of the other threads about how to ask etc etc I may well have fallen in the ignore category.
However I think I have found the answer to my question (for anyone interested) I used the User level security wizard - which has given me a shortcut to the database and identifies each user by virtue of their sign ons. (I had been warned off using this wizard previously).
So I can recommend to anyone who want to do control access to try this - make a backup copy of your db youself but the real beauty of this is it makes another copy for you as well.
Suzy
If I make my database a MDE file, will it allow me to do maintenance? As I have a date query that removes records that are passed a curtain date and appends them to another table, which will be ok for this year but will need to modify the query next year. If the file is locked totally then I won't be able to modify when it is running.
So I need a way that the database design is locked off to normal users allowing them to use it but will need a password for design so they can't mess with it. The password which will allow me into the workings to modify queries ect. Is that posible?
Dear All:
I have created a database using Access 2000. I wish to put some security on it through a login screen.
Here are the users and permissions: 1-Jim, administrator , 2-Mary, read only and print, make queries, 3-Joe, same as Mary.
I have searched the "Security area of the forum, but I am competely lost.
Any help is most welome.
Dion
Hi,
I have just upgraded the works network and software. INstead of using Access 97 i am now using 2003. I hav lost all of my security setting whilst converting it from 97 to 2003. I hav used the Security Wizzard to re-create the permissions. On my PC all usernames and permissions work fine 'But' when i go to another work station it doesnt ask me for any username / password. I hav got the database set to 'Shared' on a shared drive. The last time i did this i created it all myself and didnt use the wizzard and it worked fine.
ne ideas would b very appreciated.
i just created a simple access db with table, query, form, report. i want to distribute this database to different users at different location. i do not want to create workgroup.
i don't want to view/modify any of my object's design. i just want them to add new records in the form, view and print report only.
how can i do this? thanks
Hi there,
I recently used the access security wizard to setup user accounts etc.. and now I want to reset and go back to opening all databases without having to use a username & password.
I cant seem to find out how to do this!!
Can anyone help?? :)
Hi all i'm really confused. I have tried to use the user-level security wizard to set my database security which works fine from my computer. However, when someone else logs into the database through my shared area where it is kept, they do not encounter any of my security settings that I set up for them. From this it looks to me that the security settings only apply when someone opens the database directly from my computer and not when they open it over the network from my shared area.
Could someone please explain to me why this is happening and offer a solution to it please. Your help will be greatly appriciated.
I am attempting to move a secure database location. How do you change the location of the security since it is still trying to read off the old location. The database opens up fine with the passwords. Then I deleted the old folder it was in and try to log back in and give me the security upon startup error. So my problem is how to I change the security upon startup. I see you can change the location of the unsecure through a wizard but how about the other way??? I think I am trying to change the Workgroup information file but how do i do that??
View 1 Replies View RelatedHi everyone,
I am going to be implemeting security on my split database but have a question? The database will have the back end on a shared drive and I will copy the front end to the desktops of the people who will use the database. My question is such that when I use the Access security wizard it creates a shortcut on my personal PC. Can I simply create security access levels, then create the shortcut on my computer, and then copy the shortcut from my PC to every user that will use the front end? Will I just need the shortcut on the associates desktop or do I need a copy of the entire database? I will have a max of 30 users but probably no more than 5 logged on at a time. I have read and searched and couldnt find anything that actually answers that question? Thanks for all your assistance.
Scott