Restrictions For Different Users

Dec 6, 2011

I have my data base splitted in to front/end. There's login form implemented retrieving username and password from a table. There're couple of restrictions like: admin - can delete records; non admin - can't delete records. But my main purpose is to have such restriction that each front user will see the data entered by him only and back end should reflect all data entered by different front end users.

View Replies


ADVERTISEMENT

Combo Box Restrictions

Feb 12, 2007

Background:
I'm doing a database for a camp
They can only have 96 children for any given week of camp
I have a combo box that the data entry clerk uses to assign weeks (1, 2, 3, etc)

Question:
Is it possible to make it so that I can limit how many entries (campers) are selected to attend a week of camp? So that only 96 entries can have week 3 selected?


Hope this makes sense!

Ron

View 2 Replies View Related

Decimal Place Restrictions

Sep 27, 2004

I am building a database from a detailed Excel file which has upwards of 22 decimal places. Access restricts the decimal usage to 15 characters. Even when selecting the 15 characters, Access rounds the entry. The only way it will work so far is as text, but it is a calculated field. Any suggestions?

View 3 Replies View Related

General :: How To Calculate Fields With Restrictions

Apr 10, 2015

Here is an explanation of my database and what I am trying to accomplish. The tables and their fields I have in the database are as follows .....

EmployeeT
EmployeeID - Primary Key - Number (not an autonumber because they are county assigned)
LastName - Text
FirstName - Text
EmailAddress - Text
JobTitle - Text
MobilePhoneNumber - Text
Notes - Memo

[Code] .....

All users will interface with a form that will fill in data on the TransactionT table. I would like the data that is being input into the TransactionT.Quantity field to change the data ItemT.ESBuildingQty or ItemT.D3Qty based on which is chosen from StockLocation (they will only be able to choose either "ES Building" or "D3" when inputting the data).

For example, if the stock amount at the ES building of a particular item is 3 and the stock amount of that same item at D3 is 1 and a user inputs that a quantity of 3 of a specific item are taken from ES Building and Added to D3, I want the new values of ESBuildingQty to be 0 and D3Qty to be 4.

View 11 Replies View Related

Question About: A Table Of Users Who Have Relationships To Other Users??

Feb 21, 2006

Hi,

I have a table of users somthing like this:

User_ID
Name
Hobby
Favorite_Food
Blah
Blah
Blah

Users can be friends with one another and I need some way of logging this.

My 2 options (that i can see) are:

1) Putting a friends entry in the main user table then comma delimiting the User_ID's in the friend entry like so:

User_ID: 001
Name: John
Hobby: Frizbee
Favorite_Food: Cake
Friends: 002,004,010

2) Making a seperate table with multiple entries for each user like so:

User: 001
Friend 002
---
User: 001
Friend: 004
---
User: 001
Friend: 010
---
User: 002
Friend: 001
---
User: 004
Friend: 001
---
User: 010
Friend: 001
---

The database has to be handled by a web service and/or a web appliction making the comma delimited option occupy more server time breaking down the string into usable user_ID's.
But (and this is probably my actual problem) if i was to impliment my second idea, I'm not sure what I should make the tables primary key or the best way to relate it to the main user table.

My initial thought is to just have a, technicaly useless, ID be the primary key and impliment a one(User) to many(friends entries) relationship... but im a bit of an access n00b so thought i better come ask for some advice.

Thanks.

View 1 Replies View Related

Multiple Users

May 9, 2005

All,

I have database with user level security that works fine, but I have asked to place this database onto our secured network which means multiple users could have it open at any given time.

How can I setup this database to allow multiple users? I am very, very green at Access. Please don't say split the database...please! :eek:

debo

View 3 Replies View Related

Number Of Users

May 16, 2005

If I place the program on a server, how can I tell which users are using the program? Also, is it possible for me to kick someone off the program without going to their computer?

View 1 Replies View Related

Multiple Users

May 26, 2005

Please refresh my memory on how i can set up a database having about 10 users possibly making entrie at the same time. I am trying to make a small database for containing employee surveys.

View 3 Replies View Related

Control Users.

Jun 23, 2005

When the application starts up I need to control the user of the system, I will have to accounts which I will define one will act as an admin and the second will act as a user the differences is that the user acts is “read only” cannot add, delete and edit.

I would appreciate your comments and ideas regarding this part?

Thanks.

View 4 Replies View Related

MDE And Multiple Users

Jun 29, 2005

I want to create and mde file in order for the users not to change any thing on my design, I will be uploading the file into my server and give them the path to access:

1.3 people (max) will be accessing the database, is that a problem or not?
2. I cant create an mde file I have to convert my db but I have read as well if I covert it to 2000 people who have lower or higher version wont be able to access it, how can I fix that?

Thanks.

View 6 Replies View Related

Groups And Users!

Jun 30, 2005

I think I am missing sth here, after I set my new group then I create my new user, then what! How can I specify which user to login with? Will the user be promoted for a username and a password?

View 3 Replies View Related

Multiple Users?

Aug 18, 2005

Hi,

I am trying to create a database that MULTIPLE users can log on and view the data.

Eg. I have a client list and have employed 5 ppl to call each one of my clients and confirm their details.

I have imported all the details into a table and just want users to simulataneously log on and click a "next record" button that will bring up the next "new" record with the details displayed on a form. of course the database will flag this record as "old" and which user called them.

Main thing is 5+ computers can connect to this database simultaneously and no record gets displayed more than once.

Can MS Access do this?

if it cant, would a vb front end located on each computer help?

Thanks for any suggestions!

Jon Cheah

View 1 Replies View Related

DAPs For Users

Oct 6, 2005

What the user front-ends required in order to run/view my DAPs that put on the web?
Do they really need to have Access installed (any versions is OK?) ....
or anything else?

Thanks

View 1 Replies View Related

Track Changes By Users

Mar 8, 2006

What is the simplest way to track who is making a change to a record and when they made the change? I've tried searching for help but I'm not quite grasping how to do this. Any ideas?

View 13 Replies View Related

Kick Users Out Of DB

Feb 19, 2007

Hey guys,

I'm curious to know if it is possible to kick users off your db so you can make changes. Is it possible to send them a message to save and close within 30 seconds, or just send them a messgae. I guess I want to know whether I can
1) Kick a user off
2) Send them a message
3) Send a user a message and then kick them off

View 2 Replies View Related

Multiple Users

Mar 12, 2007

i have a database which is shared on the network. i have one problem right one. when one is using the database, another person cannot access it. what can i do to enable multer user access it at the same time.
Any help will be highly appreciated.

View 9 Replies View Related

View Users

Aug 17, 2007

Hi

Just a quick question

Is there any way that I can view which users are logged onto the database?

Thanks

View 6 Replies View Related

Chat To Users

Aug 23, 2007

Hello

Has anyone ever made a code to enable users to chat to each other in real time to help with transfering calls etc within the organisation?

Many thanks

Paul S

View 3 Replies View Related

Users And Passwords

Feb 12, 2008

This is probably a really easy thing to do but I need to set up users and passwords to access a database that will contain sensitive information so cannot be accessible to everyone.

Can someone please tell me an easy step-by-step way on how to do this, with multiple users allowed to add and edit information (but not the workings of tables, queries etc)?

I am pretty much self taught so nothing too technical if possible!!

Also, the user's name needs to be input into an "Entered By" field in a form automatically depending on who has logged in when a new record is created.

Thanks in advance for your help with this.

Emma

View 5 Replies View Related

Too Many Active Users

Mar 9, 2008

Hi Again guys,

I have a database application, front end on the local machines, back end on a server (it happens to be a mac server, but still works). Recently we upgraded to Access2007 on all systems, but left the backend in 2000 format. Ever since then we have been having issues with our users getting told "Too Many Active Users" when they try and access the backend. If all users disconnect and the reconnect it seems to be fine for a while, then after sometime it does it again. I assume it has something to do with the ldb file on the backend. It worked fine in 2003, now I am stumped. It possibly has something to do with permissions but I have no idea what.

Thanks for any help.

View 10 Replies View Related

Multiple Users

Mar 21, 2008

Hi all, o.k prior to a previous message i have been back to my manager and informed him that there is no way of updating effectivly via email.

o.k first i will tell you what we will have:
Three networked pc's running xp prof, and access 2003.
Now what i want is to be able to have my database running as a server on one machine and have the two other machines running the same database simultaniously all of them updating.

Now what i need, i dont want to have the work done for me, just if someone could point me in the right direction, maybe one or two tutorials, any pitfalls i may find etc.

thanks in advance..

Rob

View 3 Replies View Related

Multiple Users

Oct 10, 2006

I am building a database which will be used by around 30 people at the same time. When telephone calls come in they will log the details.
I dont need anything to explicit.
I have one table, around six queries and 3 reports.
I will be using one form with a save button and next record button and a switchboard.
The users will log on at the same time and will log all telephone calls thoughout the day.
Will the database work with so many people using it at the same time or do I have to change the properties.

View 8 Replies View Related

Allow End Users To Access QBE?

Aug 30, 2006

I searched and doesn't seem to find anything about that question.

I am aware that there are forms that help with building dynamic queries for end users who need to juggle their data, but wondered if allowing them to access QBE would make everything easier (why reinvent the wheel?), and whether it is possible to restrict QBE from doing action queries or using dynaset to restrict end users from updating via queries which may circumvent the rules written in forms for the given data.

Have anyone had designed database with users having access to QBE? If not, how do you provide as much functionality without practically having to re-invent the wheel?

Thanks.

View 3 Replies View Related

Form With 3 Users

Mar 24, 2005

Hello,

Question 1:
Is it possible to use the same form, from the access database on the
server, working with 3 users on 3 different pc's?


Question 2:
How can I send data, wich is in the cells of an Excel file, to an Access
database in a table?
I have a machine that put data in an Excel-file without opening.
Because I want put the data in Access I want automatically, done by
VBA, send the data from Excel to Access without opening Excel.
Is this possible?

greetings,

mulderm

View 4 Replies View Related

Different Rights For Different Users

Feb 18, 2006

Hi All,

It's me again!!

I have another question.

I'm designing this system in which each end user should has a password, and each user has different rights, some can just read, some can add, some can update and some can delete.

how can I achieve that?

I also want to know how can I disable the auto save in MS access, as we know access does auto save. I want access to save only when a save button is clicked.

Any help will be very much appreciated.

Many thanks and regards,
CS.

View 5 Replies View Related

Track Users

Aug 22, 2004

hello all... i tried to search an answer for my questions but i couldn't...

what is the easiest way to track users and their login time???

View 3 Replies View Related







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