Security Newsgroups: Access Security

Access to personal forms

Specific User Form Access - 3 Mar 2007 5:27 PM - 4 messages

I have a DB that contains personal data for members of a rescue team. This infomation is everything from personal data to training data. I am attempting to add UN & PW for each person so that they can view training data ...

User permissions

fennellkevin - 3 Mar 2007 3:02 AM - 23 messages

When Users are assigned to specific User groups (ex: New Data Users), when the User and Group Permissions dialog box is viewed, only the permissions of the Groups are shown and not the individual users (ie: when the "Users" bullet is checked) ...

Recordset unupdateable

mhmaid - 2 Mar 2007 5:25 PM - 4 messages

hi all I am using access for about 3 years as a single user although I have already started using the user lever security. Now , I wanted share the db with other staff. so , I started this by sepletting db into BE and FE . the BE is on my ...

Change in Design while users are using the Database Access 2003

sarkar.sangeeta - 2 Mar 2007 4:22 PM - 2 messages

How do I change the design in reports and forms while users are using the database when i try to change it says database on use. ...

back end security

Rashid - 2 Mar 2007 9:22 AM - 6 messages

I have a front end/ back end data base in access 2003, I have secured the front end with password and convert to mde and disable shift bypass key, my question is how can I prevent back end from accidental or deliberate deletion. ...

Access 2000 Create your own password

geocoy - 1 Mar 2007 9:50 PM - 3 messages

I have a secure database and I would like to allow users to assign / change there own password. It looks like I have to allow them to use Full Menus to do this. Problem is, they can do and see to much with full menus. How can I ...

Creating a Date Stamp for each record

Martin - 1 Mar 2007 8:00 PM - 4 messages

Hi everyone :) I have a database and to which I have added a field called Date Stamp that automatically places todays date in the newly created record. This was done via the properties screen for the table - going to the Date Stamp field and ...

Users in Access 2007

Petterq - 1 Mar 2007 7:18 PM - 6 messages

We are currently running an Access 2003 database, that have access restrictions based on username and password. In Access 2003 the user and grup informations is stored in a file named secured.mdw. When opening the database from Access 2007, where can I set the parameter to ...

Access 2000 security issue

geocoy - 1 Mar 2007 4:37 PM - 3 messages

I managed to create a secure database, I made myself one of the Admins. But I decided to create a second logon for myself with the same Admins permissions. I mistakenly created a query with the second logon (I'm still ...

User w. Full Control sees file as Read Only if file is open

Todd - 1 Mar 2007 2:39 PM - 2 messages

I have a user who has Full Control over an .xls, but when someone else is viewing (who has Read Only access), he gets a read only copy of it. That means he has to get the viewer to close the file in order to work on it. ...

Renegade Form

NevilleT - 28 Feb 2007 11:34 PM - 7 messages

I have an application with a number of forms. I can control read only access to forms through a group in the workgroup file for all but one form. The form uses a query that includes 2 tables. ...

How to view user & group account info in printed format w/o printi

fry2 - 28 Feb 2007 7:57 PM - 2 messages

I find the printed summary of user and group account information a useful format. I wish there was a way to VIEW that information in that format without printing it. Is there a way to do that? ...

RWOP and Permissions Urgent help is required

Julius - 27 Feb 2007 10:38 PM - 2 messages

Ok this is getting more difficult than it should be. I used the User-Level Security Wizard and went step by step, then I went into my queries and open them in designed mode and applied the owners permission to every querie that ...

Access Logon Problems

david smith - 27 Feb 2007 10:22 PM - 2 messages

We have an access database that was created by an employee who is no longer here. THe database had tables that were linked to another database. The password for the linked database was changed, which caused problems. When I ...

Permissions on tables linked to SQLServer

Brian - 27 Feb 2007 9:50 PM - 7 messages

Hello, I've just noted some odd behaviour and I'm wondering how to fix it. In my SQLServer I have a public user called CUUser that only has select permissions only. I originally had created a file dsn to use to link the tables using the link ...

All DBs change to the same workgroup

R Pociopa - 27 Feb 2007 6:48 PM - 2 messages

I have set up a database and so far all of the permissions, groups, users etc. have been working fine. The only problem is, I have several databases and when I assign one to a workgroup, all the rest change to that workgroup! ...

Sticking with a defined Workgroup.

Finnie - 26 Feb 2007 11:14 PM - 10 messages

Hi all I want to be able to stick with a defined workgroup, or if Acces cant get it to send a message to that affect rather than create its own. Specifically - the workgroup is on a network drive. If the drive cant be connected to ...

security with networklogin username?

troubleD - 26 Feb 2007 12:29 AM - 12 messages

Hi! I would like to ask if it is possible to use the login of the user in the network as its security for ms access 2000? currently our user wants to synchronize their network account with the access account. ...