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...
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.
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?
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?
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.
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?
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.
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.?
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.
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.
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.
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?
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?????
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?
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.....?
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?
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?
I'm running a split DB over the network, and all of the users in past un-split DB's have to have permissions granted or they can't open the DB. My question is, if I'm running the BE and FE on the server, do permissions have to be assigned to both the FE and BE or is it enough to give permissions for just the FE? The only reason that the FE is on the server is so that the user can copy it and paste it to their desktop, then refresh the links to the tables.
Hi there, I was wondering if anyone could please help me? I created a database last year for a pharmaceutical company in Access 97. I am now trying to open or convert it to Access 2003 and it says that the current user account doesn't have permission to convert or enable this database. I have tried opening the database in Access 97 so I can change the permissions on the account and it says that I need administer permissions for it. Also I can only open the sections that I allowed users to open when securing the database, I can't edit or delete anything. Is there any way I can change the user so that I have access to everything again or just delete the security settings altogether? It is impossible to go back to the original computer and change it there as I no longer have access to it. Thank you very much in advance, any help would be much appreciated.
I have created 10 User Group Accounts, and have set Permissions for the first 7 successfully. However, no Permission settings are being saved for any subsequent Groups. (Access 2010 managing a 2003 mdb file, Front and Back client)
After having experimented a little, I found that while Access allows you to create a Group name with 20 characters, any Group with 20 characters in the name does not save Permissions.19 Characters seems to be the maximum characters a Group can actually be named with.
Now there is only one set of permissions Admin, and Admin has no permissions at all. When I try to check admin rights or even read rights back to the Admin it says I need to be logged in as admin, which I am.
Is there anyway at all I can either copy some information from 2 tables and put it in my back up?? I'm really stuck here and need to fix this or I'll have lost considerable amounts of work.
i was told i could use statements like GRANT SELECT ON Accounts TO Web_User, only i dont know WHERE to write the statement and how to write it so it grants read only permission to all web users.......im using Microsoft Access 2013.
I have an Access front end that has linked tables to a SQL Server back end database. The connection to the back end is a via a read only user because the front end is a reporting tool for querying, viewing and reporting on the data. I am able to view the data in the front end and set up new queries. However my user has the new query icon greyed out. I have not set up any kind of permissions or security levels to my knowledge so am a little mystified as to why their permissions should be different to mine! Does anyone have any ideas please?
I've created a duplicate of our database in order to be able to work on the design of it from several locations. At present the database which is being used has been split into FE (on local machines) & BE (on server), with a .mdw file for the workgroup settings.
For the duplicate I have created a new database with all the Tables, Queries, Reports, Forms, Macros and code copied from the FE & BE files into a single file. My question is, to be able to work on this from remote machines / pass it on to others to work on the design, do I need to have a copy of the MDW present with the duplicate, or is it possible to remove the workgroup and security permission settings?
