Users And Group Permissions
Jun 12, 2006
We use an Oracle base software called Trapeze and Microsoft Access sometime used as a front hand to access the Trapeze oracle tables.
Since a user has to be created in Oracle, with update, delete, read, write, append rights, for Trapeze to work correctly
Is there a way for me (, even though the user has update, delete, read, write and append rights via oracle) to limit them to "read" only on the table and not update when they access the database through MS Access to create raports? I would like to allow them to create reports by linking to Oracle tables, but I don't want them to be able to update or delete or change the data in those tables.
They only way I want them to change the data has to be through the Trapeze GUI front hand application.
Any suggestions is greatly appreciated.
Thank you.
View Replies
ADVERTISEMENT
Feb 28, 2005
Hi, I have just made my maiden voyage on the good ship "Security Wizard" and the water has been a little rough but as yet I still have my sea-legs intact!
Slight problem though... I want users to be able to add data to a table but not to be able to view the whole table if they try and open it in the database window. Now I know reasonable measures would just hide the DB window but I have the threat of Data Protection Auditors looming over me becuase management "forgot" to tell me security was required and it has already been breached before I used the wizard.
Anyway, I did some research on here and I found a method whereby I can set the table so only I have permission to view/add data, then I can get users to add data via a query with permissions set to Owners.
I'm really hoping that someone will come to my rescue and tell me that there's a much easier way than that...
Please....
Anyone....
Thanks, Tom.
View 1 Replies
View Related
Mar 30, 2014
I have been searching for info with users & permission levels. I have ready a lot about ULS (User Level Security) which doesnt seem to be my answer as I do not have admin rights and I believe it is not suitable with Access 2010.
Basically I have an 2010 Access database which is used by my department as a project management tool. It has various tables, forms, queries & reports, I have created a table with user names & passwords and a login form. So when the databases opens the login form is launched & the users selects their user name & enters their password, then the main menu is shown.
Everything works really well, but as the moment there is no difference between all the users. All I want to do is to be able to make one of the Logins read only, ie if the Reviewer is logged in they can see & read every form and run every report but they can not make any edits.
View 5 Replies
View Related
Jan 25, 2007
Basically I have a secured split database. Each user has a copy of the FE on their local drive and the BE is on the server. I have 2 main user groups: FinanceUsers and purchasingUsers
Both groups of users edit data directly in the invoice table ( believe me it was not my idea - I am slowly improving it - enforcing relational integrity and fixing the table and field names and creating forms).
When a Finance user edits data in the Invoice table and tries to close it they get a message asking if they wish to save the design changes if they have changed col widths or anything. They just click no and the table closes. (Is there any way to prevent this message coming up? They do not have modify design permission in any case.)
The main problem is that when a purchasing user edits data in the Invoice table a dialog pops up asking if they wish to save the table as a form, data access page or query. (They do not get the message box asking if they wish to save design changes at all)
If the user clicks cancel the window does not close. If they choose 'form' and type a name for the new form for instance it will not save it (presumable because they do not have 'Open Exclusive' permission). So they cannot close the Invoice table at all.
Both groups have the same permissions on the Invoice table: Read Definition, Read Data, Insert Data, Update Data, Delete Data.
The only difference between their permissions is that Finance users have 'Open Exclusive' permission on the database and Purchasing users do not. This is the same in the BE and FE. I would prefer that no-one had open-exclusive permission really.
It is really odd - It only happens with the tables. Any ideas what is causing it?
View 4 Replies
View Related
Jan 10, 2008
I am receiving an unexpected message when a user tries to launch a form that the user does not have permission for via the Access Security-Permissions setting that I have configured.
I am trying to set my Access db up so that Guest users can only access 2 Forms - the Switchboard and the Main form. There is a Maintenance Form and I don't want Guest users having access to it.
I have configured Security and created a Group named Guestgrp. I have also created a user named Guest that is assigned to the Users and Guestgrp groups.
The Users group is currently set up with NO permission for any form.
Here are the Guestgrp permissions for the forms, db and tables
The following forms have Open/Run and Read Design permission
Switchboard
MainForm
The following forms have NO Permissions selected
Maintenance Form
The database permission is set to Open/Run
Table permissions
The Guest group has Read Design and Read Data permission for all tables
so here is what happens...............
My Guest user can log in and launch the Switchboard form and can launch the Main Form from the switchboard.
BUT......................
When my Guest user clicks on the Switchboard button for the Maintenance Form, the following message pops up:
There was an error executing the command.
Is this the normal way for Access to indicate that the user does NOT have permission to access a form? I am guessing/hoping that it isn't and if configured properly there would be a message indicating that permission is denied or something of that nature.
If anyone has any comments, suggestions on the error in my ways, I appreciate any comments/suggestions/clarifications.
Thanks
View 4 Replies
View Related
Nov 22, 2013
I have been using a A2003 file through A2007 to be able to use user security.We are now in A2010 and the users and permissions component is not showing in the Administrator area as it did in A2007, although the security is still functioning. How do I get access to Users and Permissions in A2010?
View 1 Replies
View Related
Aug 11, 2015
I have my application split, BE and FE. This is a form with a subform.For both I have the properties set to
Data Entry NO
Allow additions NO
Allow Deletions NO
Allow Edits NO
anyone person can open the form, but when a second person tries to open the same form we get the standard, locked by user or user does not have permission.If user 1 logs out then user 2 can get in. So it seems not a permission issue but some setting I have wrong. maybe at the query or table level?
View 6 Replies
View Related
Aug 27, 2014
Access 2003. Job booking data base with up to group of 10 different users. At the end of the month, I need to count the total amount each user has checked a particular check box and then automatically calculate the total of the whole group.I have only a basic working knowledge of Access 2003....
View 1 Replies
View Related
Aug 13, 2007
Can anyone tell me what the ideal NTFS persmissions should be for users who are only inputting data to an Access database?
Would Read, Write, & Execute on the networked folder where the BE resides be enough for the users to update the database?
Thanks!
Michael
View 2 Replies
View Related
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
May 29, 2015
Despite Google I can't seem to figure this out.
I have some data in a format similar to:
Name / Style / description / speed / distance
john / driver / careful / 80 / 5500
mary / driver / careful / 70 / 7000
pat / racer / reckless / 100 / 6000
anne / driver / careful / 75 / 1000
peter / racer / reckless / 110 / 6500
don / snail / slow / 60 / 6000
I want my report to total by style, without details and to look like:
driver careful 13500
racer reckless 12500
snail slow 6000
How do you get a report to sum the group items by a specific item and to hide the details of that group summing?
View 2 Replies
View Related
Mar 28, 2013
Is there a way to have an expression in the control source of a text box in a report, that re-starts or is exclusive for every group within the report?
View 5 Replies
View Related
Jun 11, 2006
I'm changong computers and at prestne (for a few days) I am using a borrowed computer. When I edit any of my db's I now get a message telling me that I haven't got permission do carry out what I am doing & the permissions will be erased (can't remember exact message cause I'm on another computer). The edits I have made work ok but I really don't know anything about permissions:confused: It's something I have not been bothered with because this is the first time I've changed computers with all my db's. I use acess 2003. The computer I'm seeing the mesages on is using the version of jet that came with it, my old one had an updated version of Jet (probably not the latest though). Any suggestions?
View 2 Replies
View Related
Oct 12, 2006
Hi - I wonder if anyone can help. In my haste today I ran the security wizard on an Access DB and I've locked myself out. Using Win XP home and Access 2003. Now when I try to open the DN it tells me I don't have the necessary permissions. I've hunted through the forum and there seems to be tons of postings on this, and I have tried creating a new .mdw file etc, but just can't get into it. Can anyone help me please in giving the exact steps I need to take to unsecure the DB again, as there is dozens of manhours work in it, and I desparately need to get it opened again. Thanks.
View 2 Replies
View Related
Jul 22, 2005
Hi,
I have secured a DB and everything is tickety boo except for the fact that I want to be able to administer permissions from the FE (MDE) and the modify permissions button that i have put on a custom toolbar is greyed out when I log in?
I have full admin rights on my group and own all the objects and Access lets me assign all the permissions if I enable the shift bypass and enter the development MDB that way but that's quite a bit of hassle if I want to just change a permission or two.
Can anyone tell me why it won't let me change them?
Thanks, Tom
View 1 Replies
View Related
Aug 12, 2005
Is there a way in which to assign user permissions to vba code?
I have some command buttons which run vba code but i only want to allow certain users to use these.
View 7 Replies
View Related
Oct 30, 2004
Ok so my program is nearly complete...
Now I want to add permissions. So far I've gone through the very confusing security wizard and added myself and my boss to the list, but I have no idea what a workgroup is or anything. Also, how do I do permissions, like give myself full permissions, my boss almost full permissions, the secretary access to only certain forms and reports, etc.
And is there any easy way to log when someone logs in and out and what they did, etc.?
Thanks,
-Jason
View 4 Replies
View Related
Nov 9, 2005
My access DB is split into a front and back end - the application runs fine as an MDB file for all user groups.
If I then generate an application MDE file - I get the following error :
'You don't have the necessary permissions to use the 'MSysModules2' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.'
(If I log in (as the same user) to the MDB version of the file - no error displays....????)
Why is this happening?
Ahy ideas would be gratefully received as this is the only thing stopping me from going live with the MDE. app.
Regards
View 8 Replies
View Related
Oct 19, 2006
I have copied a work database onto my flash drive and then onto my laptop to do some work in it.
Now I can not open the database because it has the error message.
You do not have the necessary permissions to use the database etc...
I have copied the Application file, the Data file and the Workgroup information file and the only one I can open is Workgroup information file. I have tried holding the shift key down as well.
Any suggestions as I have heaps of work to do and I have tomorrow away from work to do it.
View 1 Replies
View Related
Jan 18, 2007
This is not a question, but a short informational about a phenomenon I experienced at work. We had split a db and put the fe on each user's computer and the be on the server. After updating the permissions for the group, we were still getting "exclusive" issues (even though we knew we had the permissions set correctly). After a call to the main IT division, we were told just to wait a few days and the issue would resolve itself because it would take some time for the network to send the message to all the controlling machines, which would then notify their nodes and set the new permissions. Since the machines "talk" to each other constantly sharing many updates and such - apparently it can take a few days to get the "word" out to all the computers. Well, long story short, that seemed to be exactly what happened, and after two days - all of the systems were up and running and sharing without a glitch. Has anyone ever experienced something like that? I just found it to be a bit strange.
View 2 Replies
View Related
May 8, 2007
I have created an adp, and have created stored procedures for all of my forms. In the SQL Server database I have given my users permissions as db_datareader and db_datawriter, however they were unable to open any of my forms because they didn’t have execute permissions on my stored procedures. I finally had to give them permissions as db_owner so they could use my forms. Do I have to give them db_owner permissions to execute my stored procedures? I know I can go in and assign them execute permissions for my stored procedures, but there has to be a better way. Does anyone know how to give users execute permissions on stored procedures without having to give them db_owner permissions or having to grant execute permissions for each stored procedure individually?
I am still in the development phase of my project and having to assign users or groups with each stored procedure I create could really be a pain. Can someone please help me?
View 2 Replies
View Related
Jul 12, 2007
Hi
Not sure if you guys can help with this one but 6 years ago I used to run an internet marketing company and wrote a database to manage all the info.
I've been out of touch with access since then but recently wanted to get back into it by playing around with the one I wrote, so I searched it out from the deepest darkest folders on my hard drive and double clicked it.......only to find it says the following...
"You do not have the necessary permissions to use the c:database.mdb object" !!! :(
I have no idea why this might be so since it was only ever used on a simple network with no server involved and I am using it here at home on my standard PC.
Anyone got any ideas, or come across this before?????
All help much appreciated :)
View 14 Replies
View Related
Apr 20, 2005
I have built a login form which shows or hides all tool bars depending on the
user name and password. Can I also control the other permissons like being
able to edit forms and tables? I know I can do this using the MS Access
built in functionality, but can I do it programatically from my user login
screen.
I set the tool bar visibility, close the login form and open the main
switchboard using the "on click" button of my login form. Can the above
permissions controls be done here as well?
Thanks in advance.
Peter
View 1 Replies
View Related
Aug 20, 2005
Not sure where to post these questions...
Stupid question 1: Where are the Access program files stored? The Workgroup Administrator indicates the Workgroup administrator files are located in the following path on c:......
c:Documents and Settingsmy nameApplication DataMicrosoftAccessSystem.mdw
However, there is no Application Data folder in the folder with my name! In fact, I can't locate an Access folder anywhere on my computer...
Stupid question 2: I know I set myself as the Workgroup Administrator and I do know the password I created. This I did several days ago and it appeared to be transparent as far as accessing, updating, editing, etc.
Tonight I set permissions for another user, entered her name, indicated what forms, etc., she may access, etc.--as a user.
Now when I open the database it opens a logon box with my name. I enter my password and it says it is invalid! I can logon with the user I created, but as a user, she has no administrative permissions. Thus I have screwed myself out of managing my own database!
I have the database on a a jumpdrive drive so I copied it over the one that currently exists on my hard drive. Thinking this would solve the problem, it does not, it opens to display the same logon box!
Is there a way to delete all permissions?
Luckily, I bring the DB home to work on so my copy at work will be unaffected.
Sorry for the long winded stupidity. Any help.....?
View 1 Replies
View Related
Feb 27, 2006
Hiya
Have just created an access 2000 database which when a user logs on to the network as herself and tries to lookup any combo boxes or click a button to run a query from a form it shows or does nothing, yet when I log on I can.
Our IT Services have looked at folder/share permissions which appear to be OK and I've not set any permissions/workgroups in the database.
Can anyone shed any light as to why this is happening please?
Thanks
Dawn
View 2 Replies
View Related
Mar 1, 2005
I have a database that will be ran over a network. I want the freedom to add fields to the table if needed later, but I don't want anyone else to have the same permissions as me. I made an attempt at using the wizard to assign permissions, but it didn't turn out the way I needed it to. Can someone help me with this please?
View 1 Replies
View Related
