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?
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.
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 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.
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
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!
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).
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.
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.
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?
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.
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.
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?
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?
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.
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
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!
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.
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?
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.
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
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