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 RepliesHi,
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
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
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. :(
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
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
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?
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.
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.
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
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!
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?
I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.
View 3 Replies View RelatedHi guys,
I've seen different log in forms and tips on multi-user use but can't seem to find info on the following...
We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer...
Best ideas anyone?
dazza61
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.
I have two tables. The first contains details of a budget holders money allocation for a given period, and the other tracks their spend on products over that period. How can I generate a query to calculate the total running spend for each user from the "budget spend table" that will be written into the users record in the "budget allocation table".
My aim is to show details of budget allocation, total spend to date and remaining budget for each user in an Order form / report.
Can anyone please advise me on how to do this or suggest another way of doing it. Any help would be greatly appreciated.
Thanks in advance.
Regards Peter
I have a database for mutli users which is split. Front end is available separately for 3 users. These users make data entry in the same form from their front end form. This particular form has combo box that retrieves data based on selection in combo box and the use starts filling the data in the subform. Upto this, form is Ok, no problems seen.
But when the second user opens the same form from the split database front end stored in his computer, and once the second user selects another record from the combo box, first user's record also changes immediately to the record of Second user. Both users now have the same record even though the form is separately accessed from front end.
Will like to check, i have a access database which can be open up by a few users.
How can i only allow the first user who open up the database to read and write the database and the follow users who open up the access have only read access?
I need some help building what I believe is called a user end. I'm done building the tables and forms and all that jazz, now I need an interface that my boss, who knows nothing about access, can easly access and manipulate data. Of course it would be nice if I'd look nice. Is there anybody who can help or can give me link to a decent tutorial.
I already searched these forums and googled for help.
i plan to use the Group security feature for my DB.... using the user ID and password... i also want to make use of the user ID in the autopopulating of some of the field in my forms.... if for an instance the person logged in is akshal... then the a particular field named "filled in by" is to be autopopulated by the user ID (i.e. akshal)
View 2 Replies View RelatedCan someone direct me to help with setting up User rights? I've always been the only user, but now I have multiple people working from my database and want to limit there authorizations. Also, is it possible to have someone actively using the database while I continue to make changes for forms and reports?
Thanks in advance for the help.
hi. i just wanted to know how to get a litle yellow box to appear saying enter text here when the user puts the cursor over a field where hey enter text on a form. thanks
View 2 Replies View RelatedHi I am new to Access and just need some advise.
I currently have 5 different excel spreadsheets that record sales for 4 different state's then another to hold stock items.
I want to make an access database to hold all this info.
Should I make one table to record all information from the 5 spreadsheets or have a seperate table for each.
Any advise would be most appreciated.
Tks
Hi all
Well ive been using this forum for about a month now, and as an inexperianced user of Access D/B I find this forum is a wealth of information from the cream of Access programers. I have bought DVD courses of ebay in the past but has no comparison to the knowledge on this forum.
Thank you all.
Chris
Hi guys,
im a new user of Access and don't really know what im doing.
i need to make a database that will keep track of technical drawings. I need the database to be able to search for a drawing number, we might have a few of these types of equipment, so if i am adding a drawing of a different piece of the same equipment i need it to automatically generate the next number in the sequence.
This is hard to explain...
Ok, i have a load of Drawings, say they are numbered
0010-020-A-001
0020-020-A-001
0030-020-A-001
Right the first part is the type of equipment, the second is the sub-group, the thirs is the drawing type....this will all be entered by the person whois entering it into the register, the 001 at the end means it is the 001 revision of the drawing. If i have made a new revision of the drawing, say 002, i want to be able to use a form to enter the first bit of the serial number, then it will automatically tell me the next number in the sequence, and will let me fill in the other details, then i can click a button "add" or register or something and it will automatically update all the details...
....i would be so grateful if anyone knows a solution to this, or if this is even possible
thanks in advance
Cokes
I would like to welcome the users at login on my db,
I have a table that list user details which has the following fields
tblUserDetails
UserID
UserName
Password (encrypted)
UserLevelID
FirstName
LastName
EmailAddress
What I am trying to achieve is after logging in, I would have a welcome $User$ on the splash form/switchboard
So to re-cap, I would like some kinda vba coded example that will ref [FirstName]
Thanks in advance