Threads Replies Last Post 58 Pages: <<  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  >>   Default user-level security When creating a new database, the 'Users' group is defaulting to have Administer permissions for all objects. This is in Access 2003 using a workgroup file that has been converted from 97 (or older) to 2003. The 'Users' group in the old version of the workgroup file does NOT have any permissions to old or new databases. Is there a way to change it so the 'Users' group does not default... 2 06.06.2006 22:13:08 Security torture We had a clever employee (a nice man) who left our company with several important databases secured by him. He used workgroups, user level security etc. which means that to open the databases we have to use a shortcut, then the login dialog. We have all the the passwords (including the administrator one) but the databases open with a default form. We are then unable to access(!) the d... 2 06.06.2006 10:00:47 Passwords and alerting users if not authorized I have a database with levels of authorization for either "Admin" or "Users". Two questions: 1. If a user wants to open a form in edit mode, they are not allowed and receive an error message. So far so good. I would now like them to receive a MsgBox message, like "You are not authorized to use this form". I am not sure which event to attach the code on. Please advise. (OnError ... 2 05.06.2006 20:46:50 Database has been placed in a state by user My users are getting the following error when trying to open a mutli-user DB on CITRIX. I've tried to delete the LCK file but it will not let me. Does anyone know what might be causing this error? Error: The database has been placed in a state by user <ADMIN> on machine <computer name> that prevents it from being opened or locked. (Error 3734) Explanation: This error oc... 1 05.06.2006 20:08:02 Cleared 'Admin' Password now can't open database I have a user-level secured Access 2002-2003 database. I was able to access it this morning, but after clearing the 'Admin' user password can't access the database, receiving the following: "You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you. (Error ... 12 05.06.2006 20:00:57 You do not have necessary permissions error... "You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you. (Error 3033)" is the error i get when i try to access my database. I was using a table in this database in my Crystal Report. Since Crystal requested a login and password information, I tried to set... 9 05.06.2006 15:48:02 switchboard w/ 2007 beta? I'm kinda new to Access switchboards - and am trying it out on the Access 2007 beta #2. Basically - I just want this: Users (except me - developer) should see only Forms & Reports. NO tables / queries. If anyone has Access 2007 beta, can you explain how to do this, in Access-newbie terms :) Rgds Jason Shohet ... 11 04.06.2006 16:30:48 Macro security in runtime version I'm developing an ADP in 2003. I'm deploying this using the package and deployment wizard from the developer extensions. I'd like to set the macro security level to Low to prevent those pesky startup meesages. However, the client PC's don't have full Access 2003 installed (or any Office 2003 apps). Short of getting an Authenticode certificate, is there any way to set the macro security l... 5 04.06.2006 13:31:02 database password We have a database with a password assigned to it in order to open it. Is there a way to open the database without the password? (The person maintaining it left the job and no one has the password). This isn't user level security (with a login and password) - just a general password where the prompt comes up upon trying to open the db. Thanks for any help!... 2 04.06.2006 00:59:42 User Account Access to User-Level Secured Database I have a UL secured database (2002-2003), with two Groups (Admins, Users). After setting up security, I've printed out the "One-Step Security Wizard" report after completing the Wizard. This report has all information for re-constructing the WIF as necessary. However, if I modify the WIF through the Wizard again, I don't believe I get a comprehensive copy of all WIF information to com... 4 02.06.2006 22:36:19 Permissions Don't Seem to Be Working I have a database (2002 - 2003) with user-level security. When I login to an account that is a member of the Admins group, I am recognized as 'admin' by the system, which is not the username I logged in with. I've embedded "MsgBox Workspaces(0).UserName" in a VBA routine, and when executed displays 'admin' in the messagebox. Furthermore, the remainder of the code in the routine will n... 3 02.06.2006 14:13:02 My mdw file doesn't ask logins anymore !!! Help ! Hi all, I urgently need help with this one... For some reason the database opens without asking for logins anymore. It automatically opens as administrator on all Computers. Help Thanks in advance... -- Novice... 4 02.06.2006 12:22:02 Security not working on other comps I have setup the whole security thing on my pc (following those white papers etc) and everything works fine(logons/error msg when access mdb directly)... but when another user on the network clicks the mdb file, he can open it without logging it. When I checked the comp, they seem to be using the default system.mdw file. Anyone knows how I can fix this?... 2 02.06.2006 09:49:22 Help - Multi User Database HELP - I am not an avid Access user and I am in need to taking an Access database and allowing other people to use it the same time I am. Is this a possibility? I tried to go in and create workgroups, but ended up not being able to get back into my database. Can someone tell me how I can make my database available to other user at the same time. -- Sandi Gardner... 5 02.06.2006 03:00:06 HELP!!! Access 2007 and .mdw I need to open an Access 2003 secured database (with workgroup, users, etc) in Access 2007 but I can't find the join workgroup command to attach the database to the .mdw file on my computer! The pre-release version (Office 12) had it and I know microsoft's moving away from it in Office 2007 but how can I get around it and open previously secured files????? I receive the well known ms... 3 02.06.2006 00:03:47 Security Permission I have a dabase on a file server. When you give some full privileges and some read only access, the full privileged individuals can not make changes whenever a read only person is accessing the program. Would it be better to control the security permissions on the server or within access?... 4 01.06.2006 21:37:01 linked tables and network (not Access) security Can linked tables that reside in a network folder that is secured by network security (not Access security) be used by Access objects that reside in a non-secured network folder?... 3 01.06.2006 16:08:17 Read only table for users I am creating a secured database for users to access forms to submit information that inputs into a table. The information that is entered from the form identifies which user input the data from using the currentuser() function. However, this still allows users to edit the table. Is there a way that the table can still be viewed by users but not edited/deleted?? ... 2 31.05.2006 21:18:27 Users allow read only of tables I am creating a database for users to submit information from forms into tables. I have the information linked to each indivual user by utilizing the CurrentUser() function. I would like the users to be able to read the table but not be able to edit/add/delete information without going through the form- therefore each entry is secured to each individual. Is this possible? ... 2 31.05.2006 21:17:58 Changes To Group Permissions Don't Work Hi Folks, I have a secured Workgroup on the network that I setup a while ago based on the suggestions in the book, "Real World Microsoft Access Database Protection and Security" by Garry Robinson. Per his recommendation I removed the Admin from the Admin group and do not allow access to my database backends on the network to the User group. I created three groups when I made this workgroup... 5 31.05.2006 21:03:29 Read only table for users I am creating a secured database for users to access forms to submit information that inputs into a table. The information that is entered from the form identifies which user input the data from using the currentuser() function. However, this still allows users to edit the table. Is there a way that the table can still be viewed by users but not edited/deleted?? ... 1 31.05.2006 20:59:01 can I set property to round down in Access I have a text field with an expression to calculate a decmal number. I use this field in two places on a report. I would like one test box to produce the product without the decimal and to round down whenever the product implies a decimal, even if the answer returned is greater than .5... 1 31.05.2006 15:06:02 securing a database from home office computer and emailing to main Not very savy in the whole security area but read Joan Wilds, Lynn Trapps info and some other and got it to do what I needed from home office. Wondering if I can secure a database on my home computer - zip it up and email it - with the desktop shortcut(to the secure database) to our main office.( hard to travel to and would like to get it there sooner than later.) Not sure if this is... 2 31.05.2006 11:59:44 Secure multiuser applications w/out securing existing/new database My database is secure and password protected giving different access to different groups. I've created a new .mdw file in conjunction with this. I've joined this database with the new .mdw file. What I would like to do is to find a way to run this secured database without affecting the existing or new databases with this security. I understand the concept of joining a .mdw file and if... 3 30.05.2006 21:24:50 PASSWORD DUH CAN ANYONE HELP ME RECOVER ADMINISTRATOR PASSWORD ? I DON'T KNOW IF MY X HOUSEGUEST CHANGED IT OR IF HAVING AN OPEN MIND ENABLED TOO MANY THINGS TO FALL OUT.... 1 30.05.2006 05:51:01 58 Pages: <<  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  >>