Restricting Access To One Form For Individual Users?

May 12, 2012

If i split my Data base into a front and back end how would i restrict certain users only to input data on certain forms. Also how would i prevent them from accessing certain information.

View Replies


ADVERTISEMENT

Restricting Users Ability To Read Only Version: 2003

Feb 22, 2006

I have a very simple Access database that contains a form where users enter sheduling information...I wish to limit a group of users to be able to read this information only and not modify or add to it.

The tables are in a back end mdb. The rest is in a front end mdb. And the users actually use the mde file when working with the schedule.

What in your opinion is the least complicated method for providing some users with the ability to add/modify and some with read only.

Thank you.
Suzanne

View 1 Replies View Related

Problem Restricting Users From Forms Via Security/Permissions

Jan 10, 2008

I am receiving an unexpected message when a user tries to launch a form that the user does not have permission for via the Access Security-Permissions setting that I have configured.

I am trying to set my Access db up so that Guest users can only access 2 Forms - the Switchboard and the Main form. There is a Maintenance Form and I don't want Guest users having access to it.

I have configured Security and created a Group named Guestgrp. I have also created a user named Guest that is assigned to the Users and Guestgrp groups.

The Users group is currently set up with NO permission for any form.


Here are the Guestgrp permissions for the forms, db and tables

The following forms have Open/Run and Read Design permission
Switchboard
MainForm

The following forms have NO Permissions selected
Maintenance Form

The database permission is set to Open/Run

Table permissions
The Guest group has Read Design and Read Data permission for all tables


so here is what happens...............
My Guest user can log in and launch the Switchboard form and can launch the Main Form from the switchboard.
BUT......................
When my Guest user clicks on the Switchboard button for the Maintenance Form, the following message pops up:
There was an error executing the command.

Is this the normal way for Access to indicate that the user does NOT have permission to access a form? I am guessing/hoping that it isn't and if configured properly there would be a message indicating that permission is denied or something of that nature.

If anyone has any comments, suggestions on the error in my ways, I appreciate any comments/suggestions/clarifications.

Thanks

View 4 Replies View Related

Forms :: Timesheet Database - Restricting Edits To Records By Other Users

Dec 27, 2013

I have a timesheet data base and I wanted to find a way to restrict employees from editing other employees timesheets only their own timesheet... .is it possible with access 2010?

View 4 Replies View Related

General :: Emailing From Access - Individual Records To Individual Emails

Jan 8, 2015

I have a database where I record grades for my students. I would like to create a macro so that every time I record a grade as an "F", the student will receive an email that will contain an attachment of their scores. A lot of the information I want to include in this email is in several different tables. So to make it easier, I have created a query that lists the following:

Students name (SName)
Student's email (SEmail)
ID# of the form I use to record their grades (ID)
ID# of the studen'ts work (WorkID)
Date of their work (CreatedDate)
Date I graded their work (AuditDate)
Grade="F" (Accuracy)

How can I create something that will automate emailing of this information--to the individual student with only their information? I am using Access 2010. If I can't automatically send the emails, I would like to create a button in my audit screen that will send a report containing that student's information to them.

View 1 Replies View Related

Restricting Access.

Nov 18, 2006

is there a way to pw or restrict access for ppl to a table, form / control page?

View 1 Replies View Related

Restricting Access To Informatino

Oct 24, 2006

Hi

I have made up an Access database form for our Sickness Administrators to fill in when someone is off ill. I want the form to only show (on the drop down list of names) the people that that particular SA deals with - for example, Jill would enter sickness records for the Democratic, Legal & Personnel section. I am not sure how to go about this:

a) if I have one table with all of the employees names on it, is there a way of restricting Jill from seeing any names other than the ones that she deals with?

b) if I have separate tables for each section, would that be easier? and if so, do I just make a "switchboard" for them to click on the appropriate list?

Thanks!

Maria

View 8 Replies View Related

Restricting Access Via Comand Buttons

Apr 20, 2006

I have created a db and would like to apply the format of the attached zip file

I cannot seem to work out how it was done cutting and pasting the code is not working either if someone could take a look and give me a simple method of creating the desired solution i would be very greatful

The button to access the password will be called DCC Log In.

This will then allow the Command Button DCC to be Clicked (Previously Hidden as in the example)

This opens the DCC Form (already achieved by =openForms("DCC")

View 2 Replies View Related

Access 2010 - Restricting User Access

Oct 15, 2015

I have Access 2010 database.

I have a Reporting Dashboard form that inturn has many buttons to open up different reports and forms.

Now I have been asked to extend the access to a few other users with restricted access. The new users cannot see all the form and report buttons in the Reporting dashboard form.

How can i restrict this? They also need to be given separate logins and passwords. How I can accomplish this?

View 2 Replies View Related

Password Protecting A Table Or Restricting Access?

Aug 17, 2006

Hi,

Basically i have a single database with several tables in it. I want certain tables such as Ireland, UK, US etc to only be accessable by employees from those countries. Is this possible and if so, how?

I have looked at user/group permissions but can't figure out how to assign passwords to users etc.

Any help is much appreciated

Thanks
Scott

View 2 Replies View Related

Modules & VBA :: Send Individual Pdf Attachment To Individual Recipients

Feb 3, 2014

I have created a database that generates a report with customer debts. I have a lot of customers and in a report each page is a different customer with individual debts info. What i would like to do is to create a button and distribute individual report page as pdf to individual customer by email. I'm using Lotus notes. I have searched the forums i found something but it was not what i was looking for.

View 1 Replies View Related

Restricting Certain Data When Opening A Form

Mar 24, 2006

What I have is a database that I am using for 3 different sites; NE, NCA, & SCA. What I want to do is have the form ONLY show information for the specific site that the Leader is a member of. I have a security table that contains the persons name, & site location. For example: John Smith works at the NE site; so when he goes to open a form to add/modify/delete members from his site I want him to only be able to see date for NE from the table. So in the listbox NCA & SCA would be filtered.

How can I go about doing this? The forms Record Source is set to the Security Table. Please help so I can do this without having to create a seperate form for each different location. :)

View 3 Replies View Related

Access To A Database Form For More Users At The Same Time

Nov 28, 2007

Hi, I created a database where everybody should insert his holiday plans and absence of business. the Database is linked and opens automatically the form when you click on the link on the pdf. But know it is not possible anymore that more than one person opens the file to insert the data. The mistake is: Could not lock file!
What do I have to do that more people can use the database at the same time (not only read-only) Thank you for the help

View 1 Replies View Related

Modules & VBA :: Automate Access 2007 Queries With Form For Users?

Oct 18, 2013

I've been using Access 2007 to run queries on a database where we eventually export results as separate Excel spreadsheets for individual clients. The process is quite involved, using queries to change fields from code letters to words and splitting the database up into different client tables, saving the tables under date order and with different client codes.

I now need to pass this role on to colleagues, so need to make everything as straightforward as possible.

I had thought to use a Form as the user interface, with a minimum number of buttons, however I need either the system or the user to amend the date for the initial table, then to use this new table and run a series of standard queries on it, then produce the separate tables.

I don't think I can just use macros behind the buttons, because the database name is changing each time.

I assume some parts will be too tricky to automate - it will be necessary for colleagues to follow instructions instead.....

View 2 Replies View Related

General :: Restricting User To View Specific Record After Logging Into Login Form

Mar 17, 2015

i am currently developing a database what i need to do is to restrict user to view selected record and change them. i have build a login form in which i have two areas as a user name in combobox and a password text box. i have another form in which i have a combo box named area what i need to do is to limit the area combo based on the selection of the user login form previously. for example if a user select LAS VEGAS in user combo and enters its password after clicking the button login the another form appears in which thier respective stores and sales are saved, their is a combo box named area in which i want to limit it by LAS VEGAS i mean it would only show LAS VEGAS in drop down based on the previous selection in login form.

View 4 Replies View Related

General :: Send Email To Individual Clients Via Access Database 2003

Sep 17, 2014

I have a requirement to send a email to individual clients via my access database 2003 . I am using the email address of the client in the current open form . I then created a query using the id to filter that particular client, this query then becomes my record set.The content for the email is held in a .txt file , On my c drive . Every things appears fine however the fonts that I select in the .txt file are not being use in the actual email body. I created a word document with my preferred fonts and copied and pasted them into the .txt file but on sending the email the selected fonts do not appear.

I have attached a demo of what I am trying to do . To test enter your own email in the email address field of the form . Note the .txt file is on the C:/ drive.

View 4 Replies View Related

Individual Emails And Attachments From Form

Jul 10, 2005

I'm sure this is here somewhere but I just can't find it.

I have a form where a selection of suppliers are selected, I then want to email each supplier a report attachment - headed up with their particular details - for them to complete and return.

I can use the SendObject to send one email with all reports attached, how do I split it up? Can I split it up?

View 1 Replies View Related

Locking Individual Controls On A Form

Oct 12, 2006

Hi

I want to set the On Click Event of a button to unlock the current control a user is on. I know the code to set the property of a named control, but I don't want a button for every control I want to unlock. Is there a 'Me' option for controls?

Regards

David:)

View 2 Replies View Related

General :: Import JPG Format Picture Size Into ACCESS Individual Input Cells

Sep 3, 2013

I saw a demo that the user could copy and paste a JPG format file physically to ACCESS, and then something happened, and ACCESS could read the JPG length and width size (e.g. 1.3 meter length and 1.15 meter width) into 2 individual ACCESS cells which is acted the same as user input to that 2 clells.

View 14 Replies View Related

Opening A Form Based On Individual Record

Oct 6, 2004

All my records are displayed on a form. Upon clicking on their respective 'View' button, I would like to open that particular record. How can I do that? I have attached a screenshot for better clarity. Thanks in advance for the help!

Regards,
Swee

View 3 Replies View Related

Forms :: Can't Move Individual Fields When Formatting Form

Oct 15, 2014

I've just created a form and I'm trying to move and size the fields but they seem to be grouped together and whatever I do to one happens to all of them. I select one field and just that field has the orange outline but when I move it they all move.

View 5 Replies View Related

Reports :: Multiple Prints Form Single Report For Individual Accounts

May 11, 2015

I have a report , which i print every month and it consist of of more than 500 pages. This report is based on a Query called L_Inv2. i want to filter and loop this report based on the filed AccountReference with in the query. And save as PDF for individual accounts.

i have also created another query based on the L_Inv2, Called L_Inv4 which only got the record of account numbers as a AccountReference

i am trying to use below code but some how this is not working.

Code:
Private Sub Command43_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset

[Code]....

View 6 Replies View Related

Forms :: Link To Open Form With Certain Record Related To Individual In Query

Dec 5, 2013

I created a query that shows everyone who has a specific date field blank. Now want to make those names clickable so that it opens a specific form with a certain record related to that individual in the query. Each line with a different individual should open a different person on the form and their corresponding record.

View 3 Replies View Related

Restricting Display Of Information

Jan 16, 2007

I have built a database to be used by several users. One of the tables contains some fields which I don't want some of the users to be able to see.

All users log in to the database with their own username and password.

How can I hide the fields to everyone except a specific group of users?

Thanks,

Gary

View 7 Replies View Related

Restricting Records Per Date

Aug 15, 2007

Hi, a newbie needed help here.

I just wanted to ask whether it is possible to restrict records/rows in a table that has the same values (same date to be exact).

For example, I have an order form and wanted to restrict to only 20 orders per day (could be of any date; not restricted to the current date only). Therefore, if more than that, a message box will appear and no more record will be allowed to be saved.

Whether is it possible or not please justify.

Thank you in advance.

View 2 Replies View Related

Restricting Fields On Import?

Aug 29, 2007

Hey guys-
New here, and fairly new to Access as well (although I can stumble my way around). I am building a database in which I have to import the data on a daily basis (there won't be much, if any, data entry- just manipulating/Queries of the imported data). One of the fields I am importing is a 'category' type field. There's no way to restrict the data entry aspect of it before I import it into my DB- so I have to work with what I got.

The users type in the categories themselves- many all match the same name/spellings, some do not. So I assume I'm going to have a Category table with all the acceptable categories already entered into it. What I need is some way for the ones that don't fit the acceptable Category names to be flagged- once flagged I need to be prompted for each record if I want to ADD the category to the Category Table, or, if I want to match it to an existing category in the category table. If I choose to match it to an existing category, it will always keep that new category name so that queries and whatnot are consistent.

An Example-
The acceptable Category name might be 'Fruits'.
Upon importing the file- there might be entries that match that exactly, or- some might be entered as-

The Fruits
Fruits II
The Fruity Ones

If these three were to be in the import file- I want to be prompted to change the field entry to 'Fruits' or create a new category name, and associate that with the new name.

How would I go about doing this?
Thanks!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved