Threads Replies Last Post 58 Pages: <<  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  31  32  33  >>   user level security in access across a Network I have finally managed to set up user security on my main Computer and would like to know if I have to do exactly the same on each remote that is linked to this data base? I have linked the Main Data base on a remote to the network, but when I start the data base, it goes straight into it without any security. I was wondering if I copy the security MDW file onto the remote will this wo... 8 12.06.2006 13:57:38 Installing on other Computers I have designed a data base which will be distributed to local Community Groups. Do I need to set up User Security levels at each Community Group, or can I build this into the data base at point of design? Thank You William... 2 12.06.2006 13:40:21 How do i know who is logged into my database I have set up security on my database, with permissions to various users, but I now need to know who is logged in, and when. any ideas how i can do that?... 3 12.06.2006 10:30:01 How to disable opening of database window by pressing SHIFT key Could anybody pls help me out with the above issue: While opening an Access database, if we press and hold down the SHIFT key, the database window will open irrespective of the Startup settings. Is there a way to bypass the SHIFT key? ie if I dont want the database window to be opened and the application form should open whatever the user presses. Thanks in advance -- Gopi... 3 12.06.2006 07:41:01 Access 2000 J Wild security procedure I am attempting to set up security using Joan Wild's procedure. I have run into a snag from the get-go. When I Start/Run and type in wrkgadm.exe I get a message saying "Windows cannot find ........" Help anyone ??... 12 11.06.2006 14:07:47 In Access, can you restrict users to view/edit specific records? Is it possible to retrict users to only view/edit a specific subset of records within a database. Example: Saleman Bob can only see orders associated with his customers - he cannot see Saleman Terry's orders and Terry cannot see his.... 2 11.06.2006 12:06:21 Linking the value of a feild to CurrentUser() I have a table with fields [usernm] and [password] and a form with corresponding text boxes (txtusernm and txtpassword) which allow the user to enter the database if the password and user name match up with corresponding values in the table. However. I would like the user name that is selected to correspond to the currentuser(). That is if "John Doe" is selected in the form I would lik... 2 11.06.2006 11:14:30 Linking with Excel to database with ULS I recently created a database with ULS adminstered through a seperate ..mdw file. Now I need to create some linked spreadsheets to that database. When I try to link to the database is throws an error and then asks for my login, which it doesn't recogonize. I'm guessing it is using my default system.mdw. How do I specificy which .mdw to use to connect to a database with Excel? ... 2 11.06.2006 00:32:58 security.mdw I have copied an app from one machine to another. On the source, the app was on the desktop and so was security.mdw. Where (folder) do I need to copy security.mdw in order to regain access to the app on the new machine? Environ: Acc 2003 WinXP Thanks LDN... 5 10.06.2006 19:04:02 User Permissions I have been working on creating a database for work. I have all the designstuff done that I wanted. Now I am trying to set the security features. I have created the User groups, users, and set the permissions. However when I set the Admin password my database had a hissyfit. However when I removed the Admin password the login popup disappeared? How can I get the login back and set passwo... 10 10.06.2006 13:52:38 FDA CFR 21 Part 11 - Require password to make a data entry How can I prompt a user to type in their password before accepting data? The FDA requires that for electronic recordkeeping, all entries must be accompanied by a password ("Electronic Signature"). Thanks in advance, Michelle... 1 10.06.2006 02:14:01 Tracking users I have a database used by 4 different people. We keep backups but everytime I make a change someone keeps updating with an old version. Is there anyway to track the users and/or last time db was opened/modified?... 1 09.06.2006 21:58:10 Error opening database with shortcut I've converted about 15 Access 97 databases to Access 2003. The databases are split with the FE on the workstation and BE on the server. The workgroup file is also located on the server. I created shortcuts with the following /wrkgrp command lines: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Documents and Settings\All Users\Databases\Database.mdb" /wrkgrp "\\Server... 8 09.06.2006 15:59:33 secured database with Access 2002 or greater on network I used the wizard to secure the database on one given computer. there are three users. I set it up on someone who has full permissions to the database. The other 2 users will only be able to add and edit DATA. I know to get into it only from the desktop shortcut but am LOST and CONFUSED as to how to set up shortcuts on the other two computers. Access is on the Harddrive of each co... 2 09.06.2006 13:37:34 Security-warning when downloading a file I have a nasty problem here. A user here tries to download a .swf-file from the internet and save it to local harddisk. When finished downloading, windows comes up with a security-warning: 'Windows has detected this file maybe unsafe. For better protection, access to this file has been blocked.' (Sorry for the bad English, but I'm translating from Dutch.) The funny part is, the file... 2 09.06.2006 12:25:21 setting a password When I click on File, then Open to access the list of databases in order to set a password, I keep getting the My Documents window instead. Can anyone help, please? Many thanks. Richard... 8 09.06.2006 12:24:13 Tracking changes Is there a way to track who last modified a record? I have a last modified date and time, but I also want to know who performed the modification.... 2 08.06.2006 23:54:34 Creating a Temporary Table/RecordSet in Multi-User Database I have a secure database on a network drive with user access control, etc. There is some VBA code which uses a temporary table (dbOpenTable) which is populated with a unique set of records which the user then works with that data, generates reports and such. The problem is that when another user logs in and does the same thing, it overwrites the table so the first user is suddenly using ... 5 08.06.2006 20:00:02 Setting Deny Delete via the command line Hi Folks, To protect a directory with Junction Points in it I want to set 'deny delete' and 'deny Delete subfolders and files' for everyone, but for the life of me I can't figure out how to do this via the command line. This MS article says to protect the folder: http://support.microsoft.com/?kbid=205524 but it does not say how. The junctions are to be created on our user's machines... 2 08.06.2006 19:36:09 Cannot open in exclusive mode...... ....continuing from this thread that is more than a month old. http://groups.google.com.au/group/microsoft.public.access.security/browse_thread/thread/571375a4541ea917/a048d2b9e437af77?q=31+times#a048d2b9e437af77 I am going through these same issues right now! The message is an Office system message from memory" Cannot open in exclusive mode - any design changes may not be saved...etc" ... 2 08.06.2006 14:03:10 Delete LDB file I have a persistent ldb file I need to get rid of. I am the only user, the LDBViewer shows it's ME logged in but I have cold booted my system, resynced folders, there's no one using the .mdb and yet the ldb file won't go away. How can I get rid of it?... 7 07.06.2006 22:23:02 Prevent users from deleting database file in shared drive Access to the database is controlled through user groups and permissions accessed through shortcuts...but the actual database file sits in a folder on a shared drive. How can I protect the file to stop people deleting it - which incidentally has happened - although we take backups so not a total disaster! I made the file read only but this only provides a warning before deletion is all... 4 07.06.2006 12:45:55 Link to a RW database from a RO database? For security purposes I would like to create an Access database in a directory defined as read-only for a certain class of users. However, I need to programmatically record their access to the database when they open the database. I was thinking a possible solution is to provide a table link to another access database for which they have read/write access. When they log in my autoex... 12 07.06.2006 10:41:56 How do U set permissions to see report, but not entire database? We are trying to put a shortcut for a report to each user, but we do not want them to have access to the entire database. For them to see report, I need to give them permission to read the entire database, but we do not want this. We only want them to see a portion of the data. How can we set permissions to let them print their reports each day without having access to the entire data... 4 07.06.2006 05:06:46 Where do I get user LOG IN software for MS Access on the web? I... 1. have developed an Access 2003 db on my PC 2. will load it onto a MS Exchange Server for web access by the public 3. need to include a LOG IN feature for users who will use an ID and PW to get into the db I don't see any literature explaining how such applications can be developed or implemented. Which is the easiest way to incorporate this Logging On security feature?... 1 07.06.2006 01:01:01 58 Pages: <<  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  31  32  33  >>