Allow Users Different Editing Rights

Feb 24, 2006

Can someone please help me out? I have a login form which asks for the users name and password and that all works fine. However, I then want to open a form giving them different editing rights depending on the access level I have assigned them. I have copied the code below. The intAccessLevel is being read in properly but when the form "Sample" opens it ignores the Me.Allow.... statements which corresponds to the different access levels. Does anyone have any ideas why this is the case?

Many thanks,
CC


intAccessLevel = DLookup("AccessLevel", "tblUsers", "[UserID]=" & Me.cboUserName)

If intAccessLevel = 1 Then
DoCmd.OpenForm ("Sample")
Me.AllowAdditions = True
Me.AllowDeletions = True
Me.AllowEdits = True
ElseIf intAccessLevel = 2 Then
DoCmd.OpenForm ("Sample")
Me.AllowAdditions = True
Me.AllowDeletions = False
Me.AllowEdits = True
ElseIf intAccessLevel = 3 Then
DoCmd.OpenForm ("Sample")
Me.AllowAdditions = True
Me.AllowDeletions = False
Me.AllowEdits = False
ElseIf intAccessLevel = 4 Then
DoCmd.OpenForm ("Sample")
Me.AllowAdditions = False
Me.AllowDeletions = False
Me.AllowEdits = False
End If

View Replies


ADVERTISEMENT

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

Modules & VBA :: Restrict Printing Rights To Users - Print Blank Pages

Feb 10, 2014

I've been asked to make sure only certain users in my database are able to print anything (i.e. Administrators). Is there any option/property to do this?

I have already built in User Access controls using the ctl.Tag property. The only way I can think off the top of my head is when a 'general user' uses it, to ensure that every control is displayed 'on screen only'. This of course doesn't stop them printing - just makes them print blank pages!

View 12 Replies View Related

Preventing Users From Editing Code For A Database

Feb 25, 2014

I have an access database which was created in 2003. I opened a blank database and imported the definition and data in access 2010 and made the file an accde file. Now this file has a lock symbol next to the access symbol. I am also unable to edit the main form.

View 7 Replies View Related

Access Rights

Aug 11, 2005

I dont know if this is possible, but i need to add different access rights to a database.
I finish my summer placement in 2 weeks and need to set the database up so that all employees can look at the database but only one can modify it. I know how to do it in excel but i cant seem to get it to work in access. Any suggestions. :p

View 12 Replies View Related

User Rights

Jan 24, 2006

Has anyone got an idea on how to issue user rights i.e. one person can write to a certain table whilst another can only read the same table. Ive had a good search but unable to find anything! If anyone has a good thread or website I would be most grateful!

View 1 Replies View Related

Exclusive Rights To DB

Aug 13, 2007

I have a BE DB on a network server at work. I was making changes to the database and closed it, but it still says that I have exclusive rights (when I try to compact and repair, it shows that my network log-in ID has rights to the DB).

How can I resolve this?

View 1 Replies View Related

User Rights, Need Help

Aug 30, 2005

Hi,

I have designed a database in my station under my server login (I am admin). I want another user in company's server to have limited access but not 100% read only (some read and right access). It is always read only for other users in the server. And also the database can not be opened on more than one station simeltaneously.
Can you help me there.

Thanks,
Greg

View 2 Replies View Related

Intellectual Property Rights

May 12, 2005

I have designed a software package based around an Access Database at my company (based in the UK). There is a good chance that the company will be able to sell the software and potentially make a handsome profit.

My boss wants me to sign an Intellectual Property Rights agreement. Does anybody know what this means? Which of my rights does it effect? Would it prevent me from developing the same software if I left the company?

Any help would be much appreciated. I've found some resources on the web but they seem to apply mainly to music. Just wondered if anyone had had a similar experience.

Cheers.

View 7 Replies View Related

User Rights And Privileges

Apr 11, 2005

Hi! How do I create a user to have modify privileges and all other user to just have read-only access?

Any help is greaty appreciated.

Filipina

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

Cannot Update. Database Or Object Is Read-only - User Rights?!

May 7, 2007

Hi together.

I have a problem getting this error message "Cannot update. Database or object is read-only" in my Access form application.

The funny thing is, when i run this program under a Administrator account, it's working...but its not working with the User account.

Of course the User hast permission to this folder, it's just a folder on the "C:" drive.

Is there a special right i have to modify that the user can work on it?

thanks

thomas

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

File Already In Use With No Ldb File And No Rights Issue

Aug 9, 2005

I have a web based application that loads data from Access97. From the application, I choose the database and it uploads data from the chosen db.

However, after the upload is done, I am not able to open the db again till I shut down my system and start it again. The db is on my local hard disk drive and so there are no rights issues (maybe I am wrong). I also do not see any hanging *.ldb files. I even checked to see if there were any hidden *.ldb files but found none.

Could someone please help me with this issue?

View 1 Replies View Related

Editing When Used By Others

Jan 23, 2007

Hello,

I've got a somewhat urgent question;

When i'm editing in my database other users can't open the database and when they have the database open i can't edit it.

Is there a possability where i can make it possible to enable me to edit while others are viewing, something like a developers database and a user database that update eachother?

View 2 Replies View Related

More On Editing Db And VSS?

Jan 26, 2005

Hi there,

We have a 2003 ms access db that has multiple users 24 hours a day. There are two developers and changes being made all the time to the front end which is on a server.



The ONLY reason we need visual source safe (IF AT ALL...see below) is to be able to make changes even though not in it exclusively. We used to be able to do this with access 97 but not since we upgraded. We get the message: you do not have exclusive access to the database at this time. If you proceed to make chagnes, you may not be able to save them later"



And we never can even if someone is not even in that particular form.



It says: use microsoft visual sourcesafe add-in for microsoft office access"



Is this JUST an addin or do I need the software? I'm not sure what to do and I don't think we need all of the features of the full version.



Could someone advise the best way or where to get what we need?



thanks

View 3 Replies View Related

Problems Editing Mdb

May 11, 2005

Evening all,

I used to program access db's many years ago but it seems that I have forgotten my stuff and need some help.

I have 2 mdb's. One labelled client and one labelled server. They have been copied from an old workgroup network onto a new domain environment, but the problem was the plonker that moved the data did not think about the impact of the database.

Problem I have is when I open the client mdb now, I get the front form but none of the buttons work because it is looking for a network path for the server.mdb which doesn't exist. To add to this I don't know how I can edit the client mdb with the new network path as it removes the bar at the top so that I can't switch into desgin view etc.

Can anyone help?

Thanks in advance,
Abbos

View 8 Replies View Related

Editing Report

Aug 5, 2005

how do i edit a report

i'm new to access

i'm working with this database that will output a report(letter in word document) when the user clicks on a command button
i'd like to edit the letter but i don't know where it's stored.
could someone please show me how to access the report

thanks

View 4 Replies View Related

Editing After FE/BE Split

Nov 21, 2006

I created a database a while back. It was complete to my standards at the time. I split it FE and BE to protect the data.

Since then, I have made several changes on my machine to the user interface and some of the back end tables and queries.

How do I insure that these changes are seen on all the different computers on my network?

They only seem to exist on my personal machine.

View 2 Replies View Related

Problem Editing

Jun 17, 2005

i created a database to place in order my movies collection with 4 fields in a form. the problem is that when i use the form, and accidently change a record and after that i exit the database, it saves the changes. i would like to know what i can do so it won't keep the changes except if i press the save button on the form and also allow me to add more records ( i tried to lock the field but after that i couldn't add any records...). i am not much of access user so please be as descriptive as possible.thank you all!

View 5 Replies View Related

Editing A Calculation

Sep 28, 2005

I have a form that calculates the total cost. It also as an option to revoke the transaction. The code used is below:

=DSum("Cost","tblTransactions","OrderID = " & [ID] & " AND Revoked = False")

I have since added in the option to Discount a product. It writes back to the same table but I can not work out how to edit the code so it calculates the sum correctly.

New fields on table:

Discounted – Yes/No
Discount – Number

I have used this method before:

Cost*(100-[Discount])/100

But how do I put it all together so I get the correct calculation.

View 1 Replies View Related

Form For Editing Only

Mar 24, 2006

I set my form in Design view to Allow Edits but not Additions, and when I switch it to (or open it in) Form view, all the combo and text boxes and buttons disappear (the background color and header are all that's left).

All I want to do is edit existing records through the combo boxes. How can I correct this?

View 4 Replies View Related

Subforms Editing Help

Sep 6, 2006

Okay, I am ready to throw this database out the window but I am so close to being done that I want to see it through to the end so I guess I will continue plugging away at it.

I have a Contractors form and Contractors subform. I have made the allow edits, allow deletions and allow additions set to no for both forms. I made a command button for editing the forms. In the command button I made the onclick event to me.allowedits =False and it works great for my main form but it isn't working for my subform. I am still unable to edit my subform.

I have searched this forum too and found people with the same problem and have tried some of the suggestions but I am still not able to do it. I have attached my database for you to look at and hopefully you can shed some light on it for me.

Thanks

Tracy

View 3 Replies View Related

Editing Menus

Nov 16, 2004

hello everybody
I've created 2 menus using macros and everything works perfectly.
The 2nd menu has 2 commands and I want the second command of the menu to be "activated" only if a specific form is open.Otherwise the command must be in the menu, but not enabled. I also want to put a line between these 2 commands. Is it possible? Thanks in advance

View 3 Replies View Related

Editing A Table

Apr 2, 2008

I am using a form with command buttons to allow an administrator with limited Access knowledge to update certain tables. This is usually done by opening a form that is linked to the table and allow for changes. For one particular table, I would like the Administrator to be able to make the changes directly in the table. I would like for them to access the table with a command button. Here is the code I am using to update the table through the form. How do I need to change it to open the table and not the form. I tried changing the DoCmd to OpenTable and changed the stDocName to "tblStaff" but I received a compile error.

Your help is appreciated.

Private Sub cmdPermission_Click()
On Error GoTo Err_cmdPermission_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmStaff"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdPermission_Click:
Exit Sub

Err_cmdPermission_Click:
MsgBox Err.Description
Resume Exit_cmdPermission_Click

End Sub

View 5 Replies View Related

Editing Combo Boxes

Jul 27, 2005

Is there a way to edit combo boxes? I'm trying to add a null value to a combo box.

View 5 Replies View Related







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