Security Newsgroups: Access Security

User Permissions

MaggieMay - 9 Jun 2006 1:20 PM - 10 messages

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 ...

secured database with Access 2002 or greater on network

babs - 9 Jun 2006 1:07 PM - 2 messages

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 ...

Security-warning when downloading a file

GenieonWork - 9 Jun 2006 11:48 AM - 2 messages

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. ...

Data encryption on a split Access DB

Gino - 9 Jun 2006 5:06 AM - 5 messages

We have a split Access database. The front end is on the individual stations while the data tables are in the back end database on a server. I would like to protect the data on the back end so that, if stolen, the ...

Tracking changes

Eleanor of Aquitaine - 8 Jun 2006 10:58 PM - 2 messages

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. ...

Access 2000 J Wild security procedure

JoAnne - 8 Jun 2006 9:18 PM - 12 messages

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 ........" ...

security.mdw

roccogrand - 8 Jun 2006 7:46 PM - 5 messages

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 ...

Setting Deny Delete via the command line

Winter - 8 Jun 2006 7:13 PM - 2 messages

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 ...

Creating a Temporary Table/RecordSet in Multi-User Database

Chuck W - 8 Jun 2006 6:25 PM - 5 messages

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 ...

Error opening database with shortcut

Lucinda - 8 Jun 2006 4:02 PM - 8 messages

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 ...

setting a password

RichardCP - 8 Jun 2006 3:15 PM - 8 messages

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 ...

Cannot open in exclusive mode......

karlroes - 8 Jun 2006 4:10 AM - 2 messages

....continuing from this thread that is more than a month old. [link] I am going through these same issues right now! ...

Prevent users from deleting database file in shared drive

Debra - 7 Jun 2006 8:32 AM - 4 messages

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 ...

Default user-level security

SQ - 6 Jun 2006 10:05 PM - 2 messages

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 ...

Security torture

Ian Digby - 6 Jun 2006 8:24 AM - 2 messages

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 ...

Passwords and alerting users if not authorized

Ken Cobler - 5 Jun 2006 6:06 PM - 2 messages

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. ...

How do i know who is logged into my database

Sarella - 5 Jun 2006 3:08 PM - 3 messages

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? ...

Delete LDB file

John - 5 Jun 2006 2:33 PM - 7 messages

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. ...