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  >>   Access 2002 I have a user that cannot open an access .MDB if someone else is already in it. If the user opens it first everyone else can open it. So I need to have everyone get out then I have her open it and then everyone else gets back in. Brian ... 2 08.09.2006 00:16:55 Securing the Back-End I recently secured the front-end of a split database, creating a new workgroup file. I would like to allow no rights at all for the back-end, other than for members of the Admins group. Today I opened the backend file and attempted to reset permissions. Access told me that I must have Administer rights to do so. I'm a member of the Admins group in the workgroup file, which has such p... 3 08.09.2006 00:14:51 Windows Messenger Can anyone explain how an instant message was sent from my account whilst I was logged on without my knowledge... 2 07.09.2006 15:46:25 from mdb how to openForm a form in a referenced mde file From an mdb file I can call procedures and functions from a referenced mde file, but I cannot figure out how to open forms or reports that are in the mde file. my mdb file Code: docmd.openForm "Form1" The Form1 is in the mde file, yet I get the error, "the form name Form1 is mispelled or referes to an object that does not exist" Is prefixing required, or am I missing simething else?... 4 07.09.2006 13:02:17 Prevent all Access files from connecting to the same Workgroup? I am trying to post an Access database to a common drive and have only it join to a Microsoft Office Access Workgroup Information file. Unfortunately all of my other Access databases are also joining with this same workgroup information file. How do I prevent this issue?... 3 07.09.2006 12:52:04 Can I improve my setup? Following plenty of excellent advice in these forums I have finally developed and launched my app at work. I split the database, putting the backend on the server and the frontend on the user workstation as well as making my own mdw file to stop unwanted visitors! I made a custom desktop shortcut pointing to the location of MSACCESS.EXE, the mde fe file and the mdw file and this all work... 9 06.09.2006 15:10:03 Drop Down on Table I am working on a table that was created by somebody who is not with the company. I am trying to redesign the tables by including Employee ID, Last Name, First Name and Training ID. On the design part of the table, he put Employee Name but when you go to the table, this shows a drop down with Last Name and First Name. I would like to separate these two and have the names correspond to the ... 5 06.09.2006 14:47:26 database properties I cannot seem to edit the database properties, it keeps saying cannot save Why? Can someone else help - I inherited the db but have made larges changes to it... 1 06.09.2006 13:56:02 How can I lock based on certain field? I have created a database that has a form with subforms to enter data, all based on an Incident_Number field. Incident_Number being the link for all data tables. In the main table to store all this data, I have a field for Status, either Active, or Closed. How can I make ALL rows with the same Incident_Number that have a Status of "Closed" become read only for everyone except Adminis... 2 06.09.2006 00:12:32 Security restrictions and table linking Hi all! I have a backend that is secured and a frontend (mde) that has some vba code that re-links the tables to the backend. My question: Is there any way I can stop a read-only users to open the backend directly? I tried removing the "Open/Run" permission to the database object for this user in the backend, but doing that does not allow the user to do the re-linking when he/she logs on... 7 06.09.2006 00:07:24 Necessary Permissions I have a db that is located on a secure server. The db itself is not secured with usernames and/or passwords. This db will be used in a multi-user environment. Each user will access this using a shortcut on their desktop. For most of the users, this has not been a problem. However, a few receive a message "You do not have the necessary permissions to use this {path name} object." ... 11 05.09.2006 23:37:07 Users I have created a database and applied the necessary passwords and permissions for the relevant users. However, I have one problem in that my lowest scale users can still see the main database window and can create therefore play around with new forms. Is it possible to hide this window from them? Many Thanks, Matt... 4 05.09.2006 18:34:25 Lost My Permissions I recently implemented Security for the first time, following detailed instructions. This afternoon I added a new user to the BFUsers group, our lowest level group that has read and modify data permissions. I also accidentally pressed the Clear Password button, thinking I was setting no password for the new user. Now I can't get back into the database, with it saying that I do not hav... 3 05.09.2006 14:13:02 A03: Password question (mdw) Is it possible to have the Carriage Return (x0d) in a password for a workgroup? If yes, how i can get in the textfield? Thank you Thom. ... 1 05.09.2006 10:13:46 how do i use passport to my benefit? i am trying to download spreadsheet from the internet. it will go into word and excel but i cant make changed to the document even with the passport. what am i doing wrong?... 2 05.09.2006 01:06:29 Workgroup locks database even when all users are shut down. Every morning I turn on my computer and try to do my updates in the database I designed and am the administrator for. I can not run these updates due to the workgroup locking out the database as if someone has it open. I go and either check all the user that have it and close the file or I shut down thier computer completely and it still shows the database in use. I know you can open the... 16 04.09.2006 07:00:58 secured database I have created a secure database that will prompt for passwords from users if clicking on the shortcut. And if users trys to access database on the shared drive without going through the shortcut, the database will not open. All that is perfect. I will email this link to the users to enable them to access this database. The problem is, all users MS Access is not in the same directory... 4 04.09.2006 04:31:58 Using Access 2003 security on users with 2002 Access Hello, I just got Access 2003 for my PC, previously I was using Access 2002. All of my databases and security settings was created using Access 2002. All of my databases are using Access 2000 format the default setting. Many of my users are still using Access 2002. My questions is if I have to change the security level or add a new user or update the security will using Access 200... 3 03.09.2006 18:19:27 Prevent 'Edit... Delete Record...' capability? Hello, I have gone into the 'Startup...' menu and de-selected showing the Database window, 'Allow Full Menus', 'Allow Default Shortcut Menus', and 'Allow Built-in Toolbars', but users, while entry data into a form, can still go to the 'Edit..' menu and select 'Delete Record'. I do not want them to be able to do this. How can I disable this capability? Thanks. -- Pat Dools... 7 02.09.2006 13:52:33 Security-Is there a better way? Does anyone know of a better way to secure an Access database than Microsoft's built-in security system? Although the Microsoft Access Database Security system works, it is cumbersome. If one is trying to open a secure database and is not set up for the right ‘mdw’, then all he/she gets is a message saying that he can’t open the file. If he sets the mdw to the one for the secur... 13 02.09.2006 06:32:44 Login in dynamically Hi all! I'm playing with this security stuff (kinda kool), however I'm already facing problems. I would like my Access db program to open always in read-only mode for everything (so nobody can change the data). So I have made the default "Admin" and its group to read-only permissions. However, when the person needs to edit some data in any form I would like them to log on as another u... 5 02.09.2006 04:23:32 Windows Defender My Defender seems not to recognise the setting to check the PC every day although the directive is clearly saved and accepted. Checked the updates but it says I have the latest version. Can anyone advise what I should do other than scan manually? Thanks, Ann Jayne... 2 01.09.2006 16:50:00 Access security removing user I have an old copie an an mdw that my databases use. I added a user and now when I doubleclick on any access application it wants that user id and password. I want to remove that user I added. Thanks... 2 31.08.2006 20:49:37 Please help I inherited an oold mdw file that is used by our applications. The admin password is unknown. I added a user. Now when i open any access mdb it will only work with that users login. How can I remove that user. some3how this user automatically got added to al copies of my mdw's. I want to remove the user i added. Thanks ... 3 31.08.2006 20:49:23 Remove Security from Access Dear All I used User-level Security wizard. It maked a caos and I decided to remove it. I deleted system.mdw files on my pc and finally uninstalled MS-Access. Reinstalled MS-Access and I still can't get access to design mode on forms. When I look at Users and Groups Permissions, it shows that Current Owner for all DB elements is <Unknown>. This project is critical for me, please h... 4 31.08.2006 20:46:10 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  >>