New Access User Needs Some Help

Aug 22, 2006

I'd like to first thank you for any help you can offer on any of the following issues.

Situation: I've been tasked to streamline our in-processing requirements for new employees and told that the Access program can help tremendously. In order for this program to work I need to make it as easy to use as possible for some of my more computer illiterate bosses.

Tasker: Design a one-stop-shop program that is in-depth and both easy to input data and easy to show multiple outputs if we want. For example: If Jon Doe is coming into our business then I might need his prior work experience, social security number, date of birth, name, address, phone number, supervisor name etc. I know how to do some of this but I don’t know how to:
1. Make a drop down menu in a specific field to allow only the pre placed answers to work.

2. Allow a supervisor to see a 90 day forecast of only the employees who will require an evaluation. (this would require an easy to navigate program that allows the supervisor to click on the desired output and time frame to see the info)

3. Make it a clean and professional tool that will be relatively simple to maintain for future employees.

Thank you again for any help or reference material you can offer. Have a great day.

AFEric

View Replies


ADVERTISEMENT

General :: Access Multi User Database - Error On Only One User

Apr 24, 2013

I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .

All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.

View 1 Replies View Related

Using Access's User And Group Accounts Or Using A Login Form To Access Database?

Sep 9, 2005

Using Access's User and Group Accounts or Using a Login Form to access database?

I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself.

I also saw some sites where they give an example of a Login Form and how to create one.

My question is do you need to create both. First create the users and groups to permit or deny access to certain forms and then have a login form?

But would that mean that they'd have to login twice? Once when the database opens because it activates the db security that was created and then login again in the login form that was created?

Also when the user logins in and clicks on the cmd button on the form which opens up another from, frmWorkLog, I have an Employee field. This field I want it to have the user's name entered automatically and "locked". So that info, employee name, is extracted from the user's login. So then the user can only see his or her records only and no one elses.

How would I go about creating that. Hope I made my explanation clear.

Thanks in advance.

View 3 Replies View Related

Locking User Access To Database Objects (MS Access 2000 And 2003)

Apr 15, 2007

I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.

the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).

the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.

but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.

The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.

I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.

View 1 Replies View Related

User Access Denied In Access 2000 Runtime

Mar 11, 2006

We have two computers in a work group. On computer1 I have the back-end and front-end database files in the shared folder and 2 users out of 4 can access the database no problem. When the other users try to access the database they receive the error message "Microsoft Access can't Find The Database 'C:Documents and SettingsAll UsersDocumentsdb.mdb' Make sure you entered the correct path and filename" On computer2 I have the front-end database files in the shared folder and pointing to the same back-end database on computer1. Again 2 users out of 4 can access the database no problem. When the other users try to access the database they receive the same error described above.

I expect that this is some sort of windows permissions issue?
There are some clues to this fact ..
The two users that can't access the database are limited accounts, but I tried making them administrators and this had no affect.
Their shared documents folder does not have a hand underneath it?

Any help on this appreciated as it's really starting to annoy me now!

Thanks.

View 3 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

New Access User

Feb 1, 2006

Hi all,

I am new to Access and also this forum.
I need to create a list for attandence. In other words, I have a data and it should be mannered in such a way that, it should include the leaves taken, number of absentees in a day, remaining leaves, etc.,
Some information I request are:
1> Is excel better to create this or Access
2> I am not good in VB. Is VB necessary for this?
3> Can anyone suggest how I can create this. (Any sites which can help me)
The help given in the access did least help to me.
4> How is access used for these types of applications.

Your help would be appreciated. Thanks in advance. :)

Praveen

View 1 Replies View Related

New Access User

Feb 1, 2006

Hi all,

I am new to Access and also this forum.
I need to create a list for attandence. In other words, I have a data and it should be mannered in such a way that, it should include the leaves taken, number of absentees in a day, remaining leaves, etc.,
Some information I request are:
1> Is excel better to create this or Access
2> I am not good in VB. Is VB necessary for this?
3> Can anyone suggest how I can create this. (Any sites which can help me)
The help given in the access did least help to me.
4> How is access used for these types of applications.

Your help would be appreciated. Thanks in advance. :)

Praveen

View 1 Replies View Related

How Do I Only Allow One User On Access At Once?

Aug 20, 2007

Hi,

I'm new to this forum so please help! I have created a db for my dad's office which will be stored on his fileserver. I want it so that only one person at a time can access the db otherwise i hate to think how messy it could get! I'm not 100% sure how to do this so can anyone help? So far i have put on exclusive access under the tools-options-advanced tab but am not sure if this is right or will it just stop people going on when only i am on.

Please help!

Sam

View 6 Replies View Related

Multi User Access

Sep 5, 2005

Hi
If I want several users to access a database from their network pc's, should I place the access database .mdb file on the server and set the Sharing properties, then install the access application on each of their stations.

They need to each be able to use the database when they need to and read or add data, reports etc.

I am using access 2003.

Thanks

Dave

View 14 Replies View Related

More Than A User To Access The Db At The Same Time

Mar 14, 2007

Hi all
How are you?
I have a small problem...
I have an access db called MainDB, which has tables, queries, data entry form. This db (MainDB) is located in the network server.
I have another access db called BranchDB. This db (BranchDB) has no tables, it has linked tables to those tables from the MainDB, and it has the forms for view only (No Data Entry).
The problem is that users from there local machines can not access the BranchDB at the same time.
What can I do?
Your help will be highly appreciated.

View 8 Replies View Related

Here Goes - New Access User With Silly Q

Nov 10, 2006

I have read as much as I can about using access and have decided it's time to have a play - so please forgive me if this is a silly question. Here goes.

I have a single table - it lists staff by name and staff number and shows 3 qualifications that they may or may not need (yes/no columns).

I have managed to produce queries/reports that show, for each of the 3 qualifications whcih personnel that require that qualification have not achieved it.

I now want to produce a query/report that lists any personnel that are outstanding any of their required qualifications and if so which qualification they are outstanding.

Any hints or tips would be very much appreciated.

View 3 Replies View Related

Question From New Access User

Aug 24, 2004

This is a real beginner question.

I'm creating my first Access database and have it looking the way I want, however, when I look at it in Forms view, I can't add new contacts. The buttons to skip to the first and last records look active, but the "add new" and "move to next record" buttons are de-activated.

From what I've read in Access Help, if I'd created it in Page view instead of in Form's Design View, I could add this function quickly with the toolbox. But the toolbox in Design View doesn't have that button.

There has to be an easier solution than scrapping everything and starting over in Pages.

Thank you for any suggestions.

ps. appologies if I'm not using the correct terminology.

View 5 Replies View Related

New Access User Needing Direction

Aug 24, 2005

I am a novice user trying to set up a db for small business and am needing a little direction. Most of the company's sales come from the contracted work for remodeling homes; however a small amount of sales are over the counter sales within their showroom.
How do I set up the db to track the following: customer info, contract sales amount & date & payments & balance due, labor costs by employee and sub contractor, materials costs, and net profit from contracted amount vs deductions of costs?
Payments made are directly related to contracted sale and not labor or material costs; with the exception of the over the counter sales. My boss currently tracks the above info in an spreedsheet ... please advise. Any help will be greatly appreciated.

View 1 Replies View Related

Security, User Access Rights ...Please Help

Aug 29, 2005

I need to launch the database on the server as a multi user. Only one station can change the designs and major issues. But other stations have the right to add/edit/delete data. I tried that through security account and permission. It works on the admin, but not with other user login.
How can I link the access user to my server user login?

Tanks a million. :(

View 1 Replies View Related

How To Link An Access Databse With A Mac User

Jan 17, 2006

I thought I new enought about access databases. I've used the Time & Billing database as a template for my sister to use, but her partner uses a MAC. How can I get the MAC to access the database? I believe the MAC can use Excel but how can I link these two, if at all.

View 4 Replies View Related

How To Edit User Passwords In Access

May 31, 2006

I have finished my database and I have started getting the user level security all setup. I have all the permissions and users working fine except that as I was creating the accounts I entered phony passwords thinking that once i had everything worked out, it would be easy to edit them or change them to real ones, but I cannot figure out how to do that.

Does anyone know how to do this?

Thanks

mafhobb

View 1 Replies View Related

Access Front End User Permissions

Dec 8, 2006

Hi,

I have an Access front end that has linked tables to a SQL Server back end database. The connection to the back end is a via a read only user because the front end is a reporting tool for querying, viewing and reporting on the data. I am able to view the data in the front end and set up new queries. However my user has the new query icon greyed out. I have not set up any kind of permissions or security levels to my knowledge so am a little mystified as to why their permissions should be different to mine! Does anyone have any ideas please?

View 1 Replies View Related

New Access User Questions About Our Library DB

Feb 8, 2007

Hello,
I'm new to Access. I've recently started helping here at a non-profit literacy org. They have a small library and they were keeping track of it in an Excel spreadsheet. I moved it over to an Access database which seems much more appropriate and better in a lot of ways... Anyway, I'm not sure where to look or even exactly what I need to ask but here goes.

I think what we want to do is something like an invoice. The current database has one record for every book in the library and each record has fields like: book name, checked out (yes/no), date due, and borrower name.

It was nice and easy to write a little query with "<date()" on the due date field to generate a list of overdue books, then we used Word to merge the data and generate letters to send to the people with the overdue books. The problem is that most people have checked out more than one book so our simple merge ends up making one letter for every overdue book.

The first thing we'd like to accomplish is: how do we make a table? querry? report? which makes a new table with one record per borrower then each of the books that borrower has checked out?

It doesn't matter to me which way we do it, just so long as we can end up making just one letter per borrower, with that letter having each of the books listed. This seems kind of like an invoice to me, so maybe if I looked at invoice examples that would help? But that might just be more complicated and confusing?

If it's not too hard, there's a 2nd thing we'd like to do, and that is to, either from a 2nd database, or from data in the same database, but in a different "table"(?) get the person's address and merge that into the letter too, based on the borrower name.

Sorry if I'm being an annoying NOOB ~ if you think there are some things I should read first before asking these sorts of questions, perhaps you can point me too them? I'm at the stage where I don't even know enough to know what I don't know yet.

Just for reference, I do have tons of general PC & software experience, and have learned the C/C++, BASIC, Pascal, FORTRAN (77), 65816 assembly/machine code, and even a little LISP.

:)

Christopher

View 10 Replies View Related

Multi User Problem In Access 97

Aug 20, 2007

hi..

i have used one globle variable ...which gives me a new batch refrence numbers.. but when two users are working same time then ...it gives same number to both of them...i want different number as a result to both of them..
like it will give 37679...to both of them as new batch refrence numbr but i want 37679 and next number 37680 .....

plese help me how i can do this.... i really appreciate your help..
if need more information please let me know...

many thanks...

Nitesha

View 14 Replies View Related

How Can I Have A Mutiple User That Use 1 Access File?

Aug 30, 2007

I have 3 staffs
how can i make it possible for them to work in a same access file
with same form , query ???

View 2 Replies View Related

Access Runtime - User Log In Problem

Nov 23, 2007

We have a split db with the BE on a server and the FEs on the client pcs which are all running Access Runtime

I set up users on the database with different access permissions but when I open the FE in Access Runtime it doesnt ask for login credentials and just allows full read/write access to any user.

Can Access Runtime be set up for different logins/passwords?

Thanks

Paul
(No coding knowledge at all)

View 3 Replies View Related

First Time Access User Needing Help

Jan 18, 2008

Hi
I am a teacher using Access 2007 for the first time.
I have downloaded and created a Student Info database which contains details of nationality, guardian's contact info, etc.
I also have an Attendance Excel Sheet which calculates daily / monthly attendance in its most basic form.
How do I link the cells that show the current attendance of each student to the Access db? Can I link it so that it appears on the db forms / tables / individual student page?
Please advise.
I'd appreciate the coming to me in painfully simple steps.
I teach English and Humanities and am not well versed in computer language ... although I enjoy its challenges and use a lot of it for teaching and administratie purposes.
Thanking you in advance,
Kscape.

View 1 Replies View Related

Multiple User Access Problem!!

Mar 7, 2008

Hi there, wondering if anyone can help.

im trying to create a multiple user access database, but i am experincing problems when more then one person is trying to access the same entry fields and this is causing conflicts, the database is stored on a server and is not localised to the network machines. what i would like, is when a form is opened by user 1 (record no 10), user 2 should be able to use the same database form and go to a new record (record no 11) that isnt already in use by user 1.

any advice on enabling the database for multiple user access is welcome.

View 3 Replies View Related

Setting Default Value To Access User ID

Jan 6, 2005

I am having some problems setting the default value of a field to the user name of the person logging on to the database.

I have created a *.mdw for my individual database and would like to include the current user id of the user creating a new record.

Anyone out there have any ideas how i would go about doing this?

:confused:

View 3 Replies View Related

Please Help- Need ACCESS Multi User Info

Sep 2, 2004

Hello,

Great forum

I am a virtual assistant and I have a client that wants to "share" their ACCESS database with me so that I can do data entry. How do we go about doing this? Is there a program that allows me to use the same database as my client and their office people? I would be working from a remote location.

Thanks in advance!

View 3 Replies View Related







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