Home All Groups Group Topic Archive Search About

Access Security

microsoft.public.access.security
Score why a group permission passward will effects all my access databas
Crystal - 17 Jun 2006 9:43 AM - 5 messages
After I set up "user and group passward" for only one of my access database, I found that new setup workgroup information file will effect to all the rest of my access database. ...
Score Secure app against network card serial number.
Robin Donald - 16 Jun 2006 5:32 PM - 8 messages
I have a security problem where I am worried that an employee will copy (i.e. steal) our app and run it on another machine. I would like to prevent this by putting some code on the "on open" event of the welcome menu which looks for the serial number of the ...
Score Admin Privileges
Bolstaf - 16 Jun 2006 4:05 PM - 6 messages
If a form has VBA code attached it seems that VBA wants to run as Admin instead of the current logged in user.    I had to grant Admin some permissions on a secure DB and that then allows users to bypass the security. ...
Score Developing the database after splitting
scubadiver - 16 Jun 2006 3:01 PM - 4 messages
I'm not sure if this comes under security or design (maybe both) I have confidentiality/security issues with hourly pay rates so it has been recommended to me that I split the database (I have just found out that is ...
Score Personal information may been compromised
1983280zx - 16 Jun 2006 2:46 PM - 2 messages
I am going thru a divorce and my ex has intercepted an e-mail from my lawer and then wrote my atty a response to that e-mail. I changed my password, but I fear that she maight be able to monitor my e-mails. In fact the one she ...
Score 2 users using secure database residing on network
babs - 15 Jun 2006 9:14 PM - 3 messages
We have a database that is on the network set up for secured for 2 different user.  Can both users be in the database just adding records at the same time? Thanks, Barb ...
Score unable to set macro security to low
JCLusk - 15 Jun 2006 6:39 PM - 3 messages
We have Access 2003 sp1. I can't set macro security to low and net admin did not create a restrictive work group. ...
Score Unsecure a database
babs - 15 Jun 2006 2:41 PM - 5 messages
I have secured a database using Access 2003 security wizard and it works great.  Now I would like to unsecure it so that I can email it to be modified in the design view.  How can I do this?? ...
Score how to change user
James - 15 Jun 2006 1:50 PM - 5 messages
Ok... I'm following the SECFAQ.doc trying to secure one database while still allowing access to it in another database. On step 5 it says to "quit microsoft access and log back on as the new user"... well I can't ...
Score building a shortcut by coding: is it possible?
rocco - 15 Jun 2006 1:07 PM - 3 messages
Hello, I have built a database to collect data for a clinical trial. I need to deploy this database up to 8 different users which will work on very different environments. Some has Access 2003, few has Access 2000 and ...
Score Want to password protect one mdb but still access it from another mdb.
jamesburkett - 14 Jun 2006 4:18 PM - 2 messages
I'm pretty inexperienced with access/vb... so bare with me... I've got two mdb files one with user forms and then another with all the data PLUS some admin forms... I want to secure the admin/data mdb so no user ...
Score After my aol update, Access will not let me open the Access file.
Dawn - 14 Jun 2006 4:13 PM - 2 messages
After my aol update, my computer restarted.  Now, I cannot get into my access file.  It says "Microsoft Access cannot open this file.  The file is located outside your intranet or on an untrusted site.  Microsoft Access will not ...
Score Access not asking for login
SFC Traver - 14 Jun 2006 2:17 PM - 5 messages
I tried to remove the security as discussed in multiple threads here and must have jacked it up. My username account is still there, but when I open the database, it no longer asks for a login. It just opens up, but now I can't ...
Score Who is using the database?
RC - 14 Jun 2006 7:47 AM - 3 messages
I have a database on a shared server and users have an entry window to that database on their own PC. It enables users to create their own queries etc without cluttering up the server where just the raw data is stored. ...
Score Determining programmatically if an Access DB is password protected?
mike.michelle - 14 Jun 2006 5:02 AM - 5 messages
Is there a way programmatically to determine if an Access database is password protected, so that the login/password dialog isn't shown? I'm writing an application that scans Office documents, and I want it to skip Access databases that are password protected.  Unfortunately, ...
Score disable record selecting in access
Bill_M - 13 Jun 2006 10:56 PM - 3 messages
I have a table with sensitive information - Social security, address, phone numbers, etc. I also have a data entry form that many users will use to enter their information, and I am trying to eliminate the user from seeing other ...
Score need help opening a protective database
awd - 13 Jun 2006 6:40 PM - 8 messages
I have Microsoft Access version 2002 and I have MDB files from another party. The problem I have is when I attempt to open the MDB files I get an Error message, which reads “The current user doesn’t have permissions to convert or ...
Score Cant Open Database -- Missing Security.mdw file
Jeff - 13 Jun 2006 3:39 PM - 4 messages
When I try to open my database, I get a Microsoft Access Error that says "Microsoft Access can not find the security.mdw This file is needed for startup.  Any Suggestions? ...
Score Access ULS?
NeoDude0 - 13 Jun 2006 2:54 PM - 2 messages
I was referred to this newsgroup from microsoft.public.access, where I started this topic: I got this response: Can I get help with this feature for an Access database?  (I don't think my Office XP MOS certs covered this...) ...
Score Need Help on Table Deletes!
John Lane - 13 Jun 2006 1:12 PM - 2 messages
Is there any kind of tracking tool I can put in an mdb to log when someone deletes a row from a table, short of trapping the delete event in a form? Thanks. ...
Score Connect tables from a password protected mdb
Mikek - 13 Jun 2006 12:46 PM - 2 messages
I am trying to link tables programatically from a password protected database. Assuming the password is "fred" the connect fails with an "Invalid Password Message" when I use any of the following: tdf.Connect = ";DATABASE=" & strFileName tdf.Connect = ";DATABASE=" & strFileName & ";Password=fred" ...
Score Renaming User
Roger Bell - 13 Jun 2006 2:31 AM - 2 messages
I have set up User Security and wish to rename the user.  Can I do this without having to remove the User and then adding again? Thanks ...
Score Transferring MDW file
Roger Bell - 13 Jun 2006 1:26 AM - 2 messages
When I have verified User level security on a Main Computer and set the data base up for networking on remotes, how do I get the remotes to point to the new MDW file on these remotes? Thanks for any wonderful assistance as is evident in the Newsgroup. ...
Score emailing a secure database
babs - 12 Jun 2006 10:30 PM - 6 messages
I am sending a database that has been set up with users and permissions using the Security wizard from the office to my home office.  I know not to send the shortcut from the desktop but the actual mdb file.  when I zip it up and ...
Score startup option confusion w/ 2007 beta
jasonshohet - 12 Jun 2006 2:49 PM - 2 messages
I'm trying to figure out how to tell my Access database  "For me - I wanna access all objects.  For anyone else who opens it up - only forms & reports". I don't know how to create macros - so that way is out.  I think ...
Score Installing on other Computers
Roger Bell - 12 Jun 2006 9:33 AM - 2 messages
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? ...
Score user level security in access across a Network
Roger Bell - 12 Jun 2006 7:30 AM - 8 messages
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 ...
Score How to disable opening of database window by pressing SHIFT key
Gopi - 12 Jun 2006 4:27 AM - 3 messages
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 ...
Score mdw user permissions
inbreda - 11 Jun 2006 4:25 PM - 6 messages
I have two databases, one is a copy of the other. One database works fine. The other, at a particular stage of use, gives the error message "The expression On Dbl Click you entered as the event property setting produced ...
Score In Access, can you restrict users to view/edit specific records?
itllfly - 11 Jun 2006 4:08 AM - 2 messages
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. ...
Score Linking the value of a feild to CurrentUser()
eileenjess - 11 Jun 2006 3:41 AM - 2 messages
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 ...
Score Temporary login
Carol Giannini - 11 Jun 2006 1:17 AM - 11 messages
Is it possible, for the purposes of one function that requires administrative permissions, to reset the current user to Admin, execute the function, and then require the user to log in again?  Many thanks in advance -- I don't post much but read a lot and the help on ...
Next »