Limit User's Security Permission With Code

Sep 15, 2005

My db is secured using Access security but now find myself needing to code a little security work around if possible.

I have a form that has a subform. On the subform is a field named "Comments". The subform security only lets a particular group write to the fields it contains (including "Comments"). I have a new user that I need to allow to write to "Comments" but not to any of the other fields on the subform. I could make another subform with "Comments" only field and redo my security so that the original group can write to both subforms and new user can only write to "Comments" subform but I think it might be easier to code in that the new user is only allowed to write to field "Comments" in the existing subform. Every user logs into the db so I can get the user ID.

Is it possible to do this?

View Replies


User Level Security Halts With Code

Jul 19, 2005

I have created a multi-user database and stepped through the security wizard to create accounts etc. The database also has VB code in it that calculates values for a text box based on values in the form.
The PROBLEM is that when I open the database which Auto Executes the form (with VB) to open, it halts with RunTime error 2147467259 which reads "You do not have necessary permissions to use the .mdb object".... then when I "Debug" this error it takes me to the VB code???? :confused:

The code works fine without security....

Thanks for any help


View 1 Replies View Related

Is It Wise To Change Security Permission .....

Mar 20, 2007

When users are active in DB

View 2 Replies View Related

Access 2003 Security Permission Problem

Oct 19, 2006

I have a database, which contains linked tables to another database. The information held in the tables are mostly open for every permitted user but some of the table informations are restricted to a few user only. To manage all of this different permissions I created a workgroup, changed all the necessary things to become an administrator and run the security wizard to secure my database. Finally I want to give every single group the access it belongs to. And there is my problem.
I have a form which has a VBA code underlying which selects data from a table and two queries and where the user can set individual criterias. For me as an admin user this form works perfect. When I log on as a user I can't find out how to set the permissions not to receive the error message: "You do not have the necessary permission to use the 'MSys Table' object...." The user should not be an admin user and I already set the modify, update, delete, read, read design permission to the group. Nothing helps.
Please if anybody has an idea what I can try I really would appreaciate this help!
Thanks very much :)

View 1 Replies View Related

2000 Security Issue 'Cannot Read Permission On MSysAccounts'

Jan 24, 2008

i have an unsecured database in 2000

i open up a blank db with a workgroup file and then pull everything in from the unsecured

ta da, a secured database

but if i go tools>security>users & accounts it gives me

'Cannot Read Permission on MSysAccounts'

which has stumped me

the workgroup file is OLD, like and mda old, and it might be that it needs converting to a 2000 mdw, but i don't have permissions to do it

am struggling for more things to try to solve the issue, any thoughts are welcome



View 1 Replies View Related

User Permission Problem

Jul 17, 2007


I was in the process of setting up a new user on our database, when I think I inadvertantly changed my own permissions. As the owner & creator of the database I am now unable to open it up - am getting th following messag:

"You do not have the necessary permissions to use the 'NDatabasesGAB Contacts.mdb' object. Have your system administrator or the person who creatd this objct establish the appropriat permissions for you."

After rading another thread on this subject I hav amendd the security options for the database, by right-clicking & selecting properties and the Security tab, then adding myself as the owner - but this has not resolved the problem.

Does anyone have any other suggestions to help me get back into my database?

View 6 Replies View Related

User And Group Permission

Feb 5, 2008

I have put my database in a package using MS Access extension but the user and Group Perssion is not included to the package. Does some one know how to include the permissions too.


View 1 Replies View Related

Modules & VBA :: Backup Code Getting Permission Denied Error

Aug 22, 2014

I got these three code routines for backing up an Access database file from two different forums. I installed them as is, on a test database, creating command buttons for each. The test database is not password protected. I intend (if I can get one of these working) to install it on simple, single file, password protected databases.The first two came from Access World Forums at: URL....


Function BACKUPS()
On Error GoTo Err_BACKUPS
Dim fso As Object
Dim sSourcePath As String
Dim sSourceFile As String
Dim sBackupPath As String
Dim sBackupFile As String


I got a compile error "Invalid use of property." on the button sub. Then there was a simple On Click sub:


Private Sub Backup_Click()
Dim fs
Set fs = CreateObject("Scripting.FileSystemObject")
fs.CopyFile CurrentProject.FullName, "C:", True
Set fs = Nothing
MsgBox "Database has been backed up successfully"
End Sub
Private Sub Command32_Click()
End Sub

On this one I got a "Permission denied." error on the CopyFile method. As I said before, my database is not password protected.I found this third bit of code on another forum: URL...

Public Function db_Backup()
On Error GoTo db_Backup_Err

Dim sourceFile As String, destinationFile As String
Dim aFSO As Variant
Dim path As String, name As String


On this one I got another "Permission denied." error on the CopyFile method. Again, my database is not password protected. This code had appeared to me to be the most promising of the three.

View 14 Replies View Related

Modules & VBA :: Hide 5 Buttons Depending If User Has Permission Which Works Fine

May 14, 2014

i have the following code that hides 5 buttons depending if the user has permission which works trying to incorporate an IF statement if there is only 1 of the buttons visible then to automatically click the button. but if there is more than 1 do noting?


Private Sub Form_Open(Cancel As Integer)
Dim rsO As DAO.Recordset
Set rsO = CurrentDb.OpenRecordset("SELECT tblUserPermission.UserFK, tblUserPermission.CompanyFK, tblUserPermission.Permission " & _
"FROM tblUserPermission INNER JOIN tblUser ON tblUserPermission.UserFK = tblUser.UserPK " & _
"WHERE Username = '" & Me.txtName.Value & "'")


View 3 Replies View Related

Limit To 2 Records Of Identification Code

May 12, 2006

I am attempting to right program for work and here is my problem. Every Unit in the Army has a Unit Identification Code and my boss wants two records of each UIC stored. But when you add a new record for that UIC he wants the oldest one purged, so he only wants 2 records on file in order to maintain some sort of volume problems. Any ideas would be greatly appreciated

SPC Joshua Ramsay
HHC 2/104th AVN FTIG

View 10 Replies View Related

Maximum User Limit?

Jan 10, 2006

What is the maximum number of users who can be connected to one single database at one time? Is there a web site that has info on this?
Thanx for the info

View 1 Replies View Related

Limit User From Accessing A Specific Form

Jan 11, 2008

I am having a problem restricting a user from a certain form.
I have a module that detects if a user or admin based on the roles entered in the employees table.

If their windows login is not listed in the employees table, they will not be able to view any of the forms.

Here's my problem, I want the users to access the switchboard, but they should not be able to get into the reporting button.

here's my code:
If LOAStatusbtn.Caption = "View Report" _
And Not admin _
'useraccess denied because not an admin
error_text = "You do not have privileges to access this screen." & vbCr & "Please contact an administrator"
MsgBox error_text, , "No Privileges"

End If

If they click on LOAStatusbtn and their role is not admin, then a message should pop up.

I searched the forum and could not find anything similar to this.

Thank you,

View 4 Replies View Related

" Error - "The Current User Account Doesn't Have Permission To ......"

Jul 31, 2006

I have a very important access database running on a Windows 98SE laptop with Access 97 on the laptop. I wish to have that database backep up and opened on an XP machine running Access 2003. The problem is that the laptop is a corporate laptop with lots of security features and the database can only be opened by that laptop. The laptop only has permissions to read the file, so cannot remove the protection. I have tried to copy the system.mdw file across to the xp machine (in the correct directory), but I still get the below error.

The current user account doesn't have permission to convert or enable this database.

To convert or enable a database, ensure the following:
* You must join the workgroup that defines the user accounts used to access the database.
* Your user account must have Open/Run and Open Exclusive permissions for the database object.
* Your user account must have Modify Design or Administer permissions for all the tables in the database, or it must be the owner of all tables in the database.
* Your user account must have Read Design permission for all objects in the database.
* Request that other users close the database.

I have tried to create a new database on the xp machine and import all the data into a new database, but again I get an error (but only when importing certain forms and macros) below:

"You don't have permission to import, export or link to 'item name'"

I have also tried to create a blank database and import data from the database into it on the laptop, with the same error message above.

Does anybody have any ideas about this one? For example is there a piece of software to remove the protection (not a password remover)? - help appreciated.

View 4 Replies View Related

On Load Property VB Code To Limit Records In Main File.

May 3, 2005

I have an Access application for which I would like to provide potential customers with a fully functional application but with a limit to the number of records that can be stored in the main file.

I would like to have a message displayed to say "The maximum number of records have been reached for this application."

Could you help with the VB code required to do this? The module will become active at the "On Open" property when the main Form is opened.

Thank you.


Clive Shakespeare

View 2 Replies View Related

Forms :: Limit User Access In Form And Report

Jun 19, 2015

what is the best way and good practice in limiting user's access in form or report.For example, i have 2 users in my UserTable, one is Administrator and the other is just ordinary user.In case i want the ordinary user to open the form in "Read Only" mode, and the Administrator in "Edit" mode.

Do I need to make a code for each form to be opened or there's another easy way to handle this? (I am thinking for additional fields in UserTable to store their individual rights, but after that i don't know what to do next)

View 1 Replies View Related

Security Code

Aug 31, 2005

How do you get rid of the security warning when loading my database.. it says that it might contain some code that can harm my computer.

Cheers every1

View 2 Replies View Related

General :: Setting Limit For User To View Specific Data

Aug 6, 2012

I am trying to limit what a user can see when accessing a database in access. I am only testing with this in access before taking it to SQL server. I have 3 databases and I combined the data into one set of tables and now what i am trying to do is a certain user can only view data from a particular database.

I have a table with the users id and password, as well as an ID number from each database that I am trying to tie to the users.

for example one user can view and add/edit data in databases 1 and 3 but not 2. while there might be a user that can view and add/edit on 1 and 2 but not 3.

View 2 Replies View Related

Forms :: Way To Limit The Number Of Entries A User Can Make To A Form Based On A Value

Jan 20, 2015

My problem is the following: when I receive say 5 computers in a purchase form, I want to register the serial number of each of them in another form, bound to another table.If I receive 2 units in the purchase form, my user should only be able to input 2 records in the serial form (a continuous form), if we receive 3, then only 3 records,I cannot quite figure out how to build this second (serial number registration form), so that it refuses input after the correct number has been reached.

View 14 Replies View Related

User Record Security

May 12, 2005

Hi Guys

I am begining to create a IT support database for my company. I have never really needed to use secuirty for the other projects that i have completed but this one is a bit different. i have used the security wizard to create the users and groups but would like to get the basis of the security correct before i go any further.

My question is how do i configure it so that users can only update or change or delete thier own entries apart from me who could alter anything. Do i begin now when i am setting up the tables or is it a bit more complex and would require checks during accessing forms etc.

Any help and advice would be great

Many Thanks


View 4 Replies View Related

Security - For Different User To Open

Dec 7, 2005


I setup a Security. And different user,

then it creates 2 files: Account.bak, and Secured.mdw

I can open it, but it cannot be opened on another computer, why??

I already setup.


View 2 Replies View Related

User / Group, Security Etc...

Oct 19, 2006


I am currently looking into some of the security aspects of Access, as I am still not yet sure how i'll be designing a new database program, (whether to use Delphi to link to the database or run the database through Access itself) however, I was wanting to look into the security aspect of Access itself as part of my education and decision making process. Now I have deduced (correctly?) that some of the user/group access rights are based on the NT/2k/XP User/Group permissions etc, yet I was wondering if there was a little more to it than that.

In some ways I would like the application (through access or otherwise) to initialize with a logon prompt, that would ask for username and password. The database would internally?? retain the password information for security rights. I'm not sure if i'm thinking this through correctly, so i decided to come here for a few pointers in the right direction.
I'd like to set up internal to the database a set of groups and users with different levels of security. I don't want them based on the XP user account passwords and such, but just an internal database login. This would allow, to some degree, a specific master group to add / remove users from the database, as well as control user access rights to the database internally.
More or less, I want the database itself to be self-contained with all security and access rights, instead of basing them off of some external NT based security information.
So to my actual questions:

Is this possible?
Where would I start looking to set this up?

Jaeden "Sifo Dyas" al'Raec Ruiner

View 7 Replies View Related

Problems With User Security

Nov 27, 2006


When i implement user security on my access database at home with user ID's and passwords, i need to take this database and copy it into another computer at work. However, when i open my access database on other computers at work, there is no prompt for a login password or user ID.

Why is this so?


View 1 Replies View Related

Problems With User Security

Nov 28, 2006

Hey, when i set up user security at home on a database and save this database to my USB memory stick, i then take this memory stick to be open on another different computer at the internet cafe. However, when i open the database on another different computer there is no prompt for log in user names and passwords. This is not what i want.

Why is this so?

Thanks for the help

View 6 Replies View Related

Customized Msg Box For User Security

Dec 20, 2006

Hello everyone.

Not sure if this is possible...but I hope it is!

I have created user security with limited access for specific groups to certain forms in my database.

However, when a user attempts to open one of the restricted forms a Generic Microsoft Access Message Box opens. Am I able to customise this box so that the box Heading is not "Microsoft Access" and so that the user is not offered the option of "Help"?

Really all I want is a box that says;

"You do not have the permission to open this form."

I only want an "Ok" box as an option (not the "Help" box as well)

Any help would be extremely grateful.

Thanks in advance,


View 2 Replies View Related

User-Level Security

Mar 12, 2007

Hi, I need to add a security feature to my database. Basically I want different users to access the database with different permissions. I want a "basic user" to be only able to access the the forms with their respective default settings. I want an "admin" to obviously be able to access all the content and edit the design. I know I can do this with User-Level Security somehow, but i've tried it and it isn't working like I want it to. DOes anyone know or have any experience with this security feature.

View 10 Replies View Related

User Level Security

Mar 26, 2008

How do you set up user level security for your database?

View 2 Replies View Related

Copyrights 2005-15, All rights reserved