Threads Replies Last Post 58 Pages: 1  2  3  4  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  >>   How do I remove permissions in a database? For some reason, I have put in place security restrictions (even though I don't need them) on my access database accidently. Even the Admin user has no permissions. So I am stuck. I can open the database, but nothing else. ... 2 15.09.2006 21:56:25 shortcut just to access All the examples of shortcuts using workgroup files I have seen involve an existing database. I thought though that to be the owner of a database you have to create it whilst logged on to the workgroup file you want to use to secure it, so is it possible to just open Access with no database, logging onto a workgroup, and then create a new database?... 4 15.09.2006 21:55:28 Multiple users I will be having multiple users entering data into my database. My question is how can I get the users to only have access to the forms and nothing else? ... 2 15.09.2006 21:54:20 Make mdb Read Only in code? Hi. I have not implemented full user security on my mdb, basically because of the number of problems it seems to cause and there is only a small number of users. Instead, I have a simple password checking form. Is there a way of making the mdb Read Only if a particular password is entered? Is there some code that I could add alongside the password checking code on the form that woul... 7 14.09.2006 20:45:02 The Microsoft Jet database engine cannot open the file. It is already opend exclusively by another user, or you need permission to view its data. Hi , We have access 2003 on Citrix Server. The MSACCESS.EXE file located in d: drive. The msaccess.mdb file located for individual user in their profile in "my document" folder. We give a shortcut of MSACCESS.exe file to each user profile so user can launch access. The problem is: If only one user launch msaccess and open the msaccess.mdb file it works fine. but if one user has ... 1 14.09.2006 15:10:18 How do I retrieve a User PID I have inherited a group of databases within a domain, where the users and groups were already set up (long ago, but added to). It appears that users were not deleted as they left due to a concern as to whether there might be undocumented databases "out there" which they had sole access to. I want to clean house, and have read that a user can be reinstated if given the same user name a... 3 14.09.2006 11:51:33 No User Level Security in the new Access 2007 file format - a possible replacement? Help needed. Hi folks, A couple of us (Brent Spaulding and I, Alan Cossey) have been trying to find a way of generating an equivalent of the old User Level Security (ULS) with the new Access 2007 file format. We've come up with a framework that we think is worthwhile. We've called it Virtual Password Protected Connection (vPPC) and it works by 1) Using a back end with database password and encryption. ... 1 14.09.2006 07:37:38 security, limit database access to 1 user Hi, I would like only 1 user to be able to use the database at once. How can i ensure this? If i go into Tools/Options/Advanced/and tick the exclusive box - this does not work. Please assist. Thanks George... 1 14.09.2006 05:40:02 Reset Security Utility? Greetings to all, Does anybody here know of a utility that can be purchased to reset all security for an entire Microsoft Access 2000 system? We have a somewhat complex system that uses a single mdb (user interface) to utilize around 78 mde's and 3 ade's via 18 mod's (mod = mdb dif name) all of this front end runs off of 3 SQL Server 2000 databases with around 745 tables... The p... 2 14.09.2006 00:16:42 User Permissions How would I go about not giving users permission to view any type of reports? ... 1 13.09.2006 21:42:02 Warning message When i open my database i get a warning message asking whether it is safe to open depending on the code I have Is there any way to get rid of this? Many Thanks, Matt... 6 13.09.2006 21:15:10 Shorcut with pointing to two ACCESS.EXE Hello all I am having a lil problem here. Is there a way to create just ONE shorcut that points to two (2) different folders where the ACCESS.EXE is located? e.g. "C:\Program Files\Microsoft Office2003\OFFICE11\MSACCESS.EXE" "\\Hou0602\Intranet\Expense Report Interface\Expense Report Interface ..MDB" /WRKGRP "\\Hou0602\Intranet\Expense Report Interface\Security.mdw" BUT what if the M... 3 13.09.2006 16:38:02 Default CurrentUser when not opening form Hi group, I found a peculiar situation with my database. When I first use CurrentDB and then show Workspaces(0).UserName in a MsgBox, I get the name of the logged in user. However, when I do not first access CurrentDB and ask for the value of Workspaces(0).UserName right away, I get "admin"... Further investigation reveals that "admin" really is the logged in user from then on, at ... 4 12.09.2006 16:54:01 Scandinavian Regional Settings I have a product written using Access 2003, the software is digitally signed and runs with all non Scandinavian regional settings. If i change the setting to one of the Scandinavian countries i get a message saying that the file cannot be opened due to security settings and that the file is not digitally signed. I used to have a code signing id by verisign and have just changed to Thawte... 1 11.09.2006 16:21:03 Security Having created a secured database and now have all the relevant passwords etc, it created a shortcut which i now run from. However, I need to distribute this file on to a shared drive and i cannot find the main file and can only run off the shortcut. ANy ideas?... 6 11.09.2006 14:56:44 Open Exclusive This is a multipart message in MIME format. --=_alternative 00742752852571E2_= Content-Type: text/plain; charset="US-ASCII" The open default on my database is set on exclusive. However, when I try to reset the password, I get the message that the database must be set on open exclusive in order to alter the password? Please help. --=_alternative 00742752852571E2_= Content-Type: text/h... 3 11.09.2006 11:32:30 小标宋体怎样设置 小标宋体怎样设置... 1 11.09.2006 02:25:02 User permissions validation text Within my database i have set up user groups with passwords and then have related user permissions. When a user tries to access something they aren't allowed to the error message comes up as "There was an error executing the command". Is there any chance of changing this text? Many Thanks, Matt... 2 10.09.2006 01:00:32 startup properties I want to prevent others from changing the startup properties using VBA in another access file. I don't use User level security because I am not in a position to prevent either the database file being copied onto another machine or a workgroup file from being over written. In either of these cases I find the owner becomes unknown. There is a password on the VBA code. ... 5 09.09.2006 15:44:54 Fox Sports not Authorized Message When i try to lonon to my fox sports fantasy team i get a not authorized message. How do i fix this?? Not Authorized You are not authorized to view the page you requested. It is likely you are not authorized to view this page because you are not the Commissioner or are not part of this league. Click here to return to the previous page. You can return to the FOXSports.com h... 2 09.09.2006 11:35:24 Locked Out, what did I do? My first try at Access security, I used the wizard, and setup the passwords, etc. Now, when I try to open the DB, I get a message saying I don't have permission, and to contact the Admin (me). Where did I go wrong? It never prompts me to enter a password, and I'm not so sure about the creat/join group function. On the snapshot it gave me, I am listed under Admin. Hope I didn't trash t... 3 08.09.2006 15:29:02 Admins Group Unique? Is the Admins group unique for each installation of Access? Not the Admin user, but the Admins Group itself? IOW: If I install Access on machineA and also on MachineB, would the groups be created with the same PID on each? I have always thought that the system.mdw file is identical across all installations of Access of the same version. So my system.mdw file for Access 2002 is exactly identic... 2 08.09.2006 15:05:51 Patch problem Access 2003 (SP2) Hi! We use Active Directory to publish our applications to users. I "patched" MSAccess2003 media with Office2003SP2-KB887616-FullFile-ENU (msiexec /p <path>\Mainsp2ff.msp /a <path>\Acc11.msi /qb /lv* <path>\logfile msiexec /p <path>\Owc11SP2ff.msp /a <path>\Owc11.msi /qb /lv* <path>\logfile) According to log everything look to have worked out alright.... 3 08.09.2006 08:19:02 Forgotten password for Access My daughter password protected a file on Access and forgot the password. Now, all of Access is password protected and I can not open any databases. Is there a way to get rid of this password. I have tried to uninstall and reload the program with no cahnge.... 2 08.09.2006 07:35:03 MDW deployment? Hi again! I have created a front-end and a secured backend. I have also created a synchronized (auto-update) platform where every user will get the latest front-end version on their local machines. However, I'm unsure whether I should also distribute the MDW (security) file. It was suggested to me to distribute copies of the front-end to avoid some data corruption. I think that makes se... 5 08.09.2006 06:31:31 58 Pages: 1  2  3  4  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  >>