Access 2007 Northwinds Employee Privileges
I saved the Nortwinds DB in the .accdb format. I can't understand how the empoyee privileges work. Is each employee on have certain privileges in the database, such as tables, forms etc.?
View Complete Forum Thread with Replies
Related Forum Messages:
Access Employee DB
Is anybody out there kind enough to post a good head start sample db for managing employees with photo included in form and in report. Would appreciate any help and thanks, cagay
View Replies !
Setting User Privileges
Hi, Does anyone know a good tutorial about setting user privileges in MS Access? I have googled it, but could not find any thing interesting! Thanks in advance.
View Replies !
[Security] Resetting To Default (admin) Privileges
Hi,I have a problem concerning the admin user privileges of my Microsoft Access database. I have developed an Access database that offers a graphical user interface to the end users. These end users need to log in to the database application, so I have created a workgroup file, some users and passwords and for each user I have set more or less database privileges (some users may only read data, whereas others may also insert new records etc.).However, I have also accidentally removed general database operation privileges from the the default admin account and now I cannot access the database to edit tables, forms, relations etc. anymore. In other words: as the admin user I can now only log in as the highest privileged end user (read an write data through the GUI).:eek: This is a serious problem, because the database application is not finished, yet. And since it will be a hell of a job to recreate the whole database application from scratch, I was wondering whether there are tools available that can 'crack' the security / privileges settings of users and set them to their defaults, so that I can have full database access (editing schemas, relations, forms etc.) again as the admin user.Thanks in advance and kind regards!
View Replies !
Employee Job Administrator
Hi There I've Been Asked For A Software That Manages Employee Where The Software Has To Assign Shifts For Employees Without Time Conflicts Or Duplicate Job For The Same Employee in One Shift Hope I Described My Problem Clearly Any Ideas Or Anyone Has Done This Previoulsy Thank In Advance
View Replies !
Employee Record
Hi all, I am looking for an employee record template for data including sickness, vacation, skills, CVs etc. I would have thought there would be loads available but alas, I can find none Can anybody point me in the right direction please. Thanks in advance Rob
View Replies !
Employee Compensation
Trying to setup a database to track employee compensation and need some advise on the setup. I was told in a previous post to normalize my tables which I think I've done. I would just like some other input on this to know if I've done it right. I created a table called Employees with the following fields: autonumber id field, firstname, lastname, department, position, hiredate. Next I am creating a new table for each year which will contain the following tables: autonumber id, base, bonus, addbonus, overtimecomm, car, 401kcon. The autonumber ID fields in each table have been set as the primary keys and I've setup a relationship between Employees and each of the compensation tables. Does this sound like it will work? Or do I need to go back and rethink some of the process?
View Replies !
Employee Quit?
I have a form which has a drop down box which links to a table with Employee names. One employee quit and I want to delete her name from the table. But... if I do that, I will delete her entirely from all previous records. Is there a way to keep all previous records, but take her out of the drop down choices?
View Replies !
Employee Payroll
I'm trying to use a query to calculate the payroll for all the employees but it won't work. The two tables I have are 'Employees' and 'Employee Payroll'. In the 'Employee Payroll' table there are three fields- Employee ID, Days worked and Earnings. I need to calculate the sum of the earnings field but it just displays a blank list of records when I try it. Can anyone help? Thanks
View Replies !
Employee Database
I'm trying to create a database in Access to track various employee data for the company I work for. We have about 44 employees. There are about 7 different groups of data our poor secretary now has to keep up with. These include: a list of the employees, with name, address, phone, etc. A handmade form with salary information like current wage, raises and when they were given, etc. A bonus section, how much and when. A list with attendance information including tracking missed days and tardies. A list of temporary employees and when their incremental reviews are due. There are other lists we use and others we are thinking of starting having to do with training, etc. It’s too much to keep up with manually now. One of my questions is: can there be one table with the basic employee information that other tables can access without having to enter the same names again into other tables? (Why enter all those names more than once)? My other question has to do with linking tables together, I just can’t seem to grasp the concept even after reading two Access training books on the subject. I made a simpler database for another project and gave up on linking tables and the database seems to work just fine. Any help is appreciated and sorry for the long post.
View Replies !
Add Employee Form
I have an Employees table. I have a form to Add Employee and a form to Remove Employee. Remove Employee works great. It's a drop down box, they select the employee and click on remove. With Add Employee, I have a textbox where they enter the name and a button to add that employee to the database. I setup a VBA script to take the value in the textbox labled "empname" and insert it into the Employees table when the button is clicked through the onClick event. Is there an easy way to do this? I need the UI to be simple. I know you can bound the textbox to the employee name, but then when they open up the form it will show all the records and they have to click the new record button to add someone. I know this question was asked very recently, but it wasn't answered very well. I have the db attached. It's in Access 2003 format. The macro in there is the VBA script that I wrote, so don't worry, it's not harmful. I'm very good with SQL, and I would've chosen to use ASP for the user interface, but the people that need this don't want to run any servers (IIS). They just need a file they can double click on and work from there. Thanks
View Replies !
|
TRACKER
