Logins And Permissions
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 Replies
ADVERTISEMENT
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
Oct 20, 2006
This attachment is an example of a loginID and Password system. Users DONT like to enter a loginID and a password. This example will get the user's loginID from windows and all you need to do is add their loginID to the admin table (or any other table for allowing users to have certain capabilities.) You can expand this to allow user's to certain forms or the ability to delete records, add records, etc. Just expand on the example with tables to do certain things.
It is much better to have a table which automatically determines if the user is in a Delete table or Admin table, etc...
I have a 2000 and XP version but I can't upload it due to limitations on upload size.
I use this technique quite often and find users like it very much as they don't want to re-enter their loginID or a password. I hope you also find it usefull. If so, please let me know.
View 2 Replies
View Related
Oct 3, 2005
Hi,
I thought this was posted here in the past, but I can't find it. I need a way to track when users log into an access database (username and time).
Is there an easy way to do this?
Thanks,
Keith
View 1 Replies
View Related
Jun 5, 2006
I am messing with the user logins and groups. I got it to work on my computer but...It only works on my computer and with every database I open. No other computers get a request for a login and password and the file just opens up.
How can I get a nice login for people at our work?
View 9 Replies
View Related
Apr 1, 2004
I would like to create user logins for my Access database that I would use not to prevent opening or modifying various objects (tables, forms, report) but to use for identifying the user so that when changes are made the username and time can be logged for an audit trail. Is this something I should be able to do it Access 2000. If so, how would I get the current user's name to use in my logging process.
Thanks ahead of time for any help provided!
Paul
View 14 Replies
View Related
Nov 17, 2007
Hello,
I apologize if this is already a thread, but I tried my best to search for it and nothing helped. Alright, I set up low-level security for my database using the security wizard and I was wondering if there is a way to track information (username, date/time, etc.) from the auto-generated logon window. I started out making my own login window, but I couldn't get my permissions set up properly, so I figured the given security measures would be best. Everything works fine, I just need a way to track the logins. Any help would be appreciated, thanks!!
View 3 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
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
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
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 2 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
Mar 28, 2005
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.
View 3 Replies
View Related
Nov 15, 2005
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.
View 1 Replies
View Related
Jul 10, 2014
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.
View 1 Replies
View Related
Jul 16, 2013
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.
View 5 Replies
View Related
