What is the simplest way to allow one user write access and everyone else read-only access to a MS Access database on a local network?
Active4 years, 10 months ago
I trust my users, but unfortunately Access saves changes to data as soon as the row of a table is deselected. Accidental keystrokes are saved without the user asking for the changes to be saved.
I have a problem when i type gpresult on a computer i get a message 'user does not have RSOP data' when some of the computers get the data, and even if I login as administrator i get the same message, what should I do.
Liam
- May 30, 2012 'The user 'xxx xxx' does not have RSOP data'. If I disable the setting 'Enable Profile Management' in the GPO, the gpresult works fine. I have this problem with the.
- Feb 01, 2013 gpresult - INFO: The user does not have RSoP data. Discussion in '. INFO: The user does not have RSoP data. User can access company.local SYSVOL and proceed to company.local SYSVOL company.local Policies. I looked up the GUID of one group policy in question (at the time of writing) for not working like it should, so I thought 'hmm.
- INFO: the user does not have RSOP data - posted in Windows Server: I can apply gpupdate /force on my client, but Im getting this error message when i typed in.
- The User Does Not Have RSoP Data When the UAC is enabled and GPResult is used in non-elevated mode, only the user settings section of the group policies is shown. If you need both sections (USER SETTINGS and COMPUTER SETTINGS) to be displayed, the command must be running in the command prompt with the administrator privileges.
10.6k20 gold badges74 silver badges102 bronze badges
6 Answers
The easiest way would be to use share permissions. Grant write access to a group and put the users who must write to the database in that group. Put everyone else in a read group. This assumes you have a Windows domain, of course.
Here is a site that has some information on securing Access databases. It deals with Access 2000, there may be more options for newer versions.
Dave SwerskyDave Swersky
31.9k7 gold badges68 silver badges110 bronze badges
Some thoughts on controlling user rights to a Jet data store:
-
if you really want to lock things down, you'll never manage it with Jet, as it's inherently vulnerable because the user has to have WRITE access to the MDB file.
-
if you are content with controlling rights to the data in your front-end application, you could provide different front ends (one for WRITE users and one for READ-ONLY).
-
if you're not using ACCDB format, you can use Jet user-level security. It's a surprisingly complicated technology if you really want to lock down access to the data -- you have to follow all the instructions in the Jet Security White Paper to the letter, or your data will be open to anyone with the standard Jet workgroup file. And even once you're done, it is crackable (though not without spending $$$ to buy cracking software). BTW, database passwords before Access 2007 were completely useless and easily cracked. Access 2007 enhances the security by raising the level of data encryption, but a database password causes lots of issues and doesn't allow you to have more than one level of access (unless you provide two different front ends with different passwords -- cf. #2).
-
if you just want to use Jet ULS to control access in your front end, you can add your users to groups and then check the group membership in your front-end UI objects (i.e., forms), and give WRITE permission to the users who are in the user group that provides that level of access. The easiest way to do this, assuming you have more READ-ONLY users than those with WRITE permission is to have the READ-ONLY users log on as the default admin user (i.e., you do nothing for their setup), and have the WRITE users log on as a user in the group with WRITE permission. In other words, if they aren't logged on as user 'admin', they have full WRITE access.
-
another alternative is to use NTFS security groups. API code for that is found on the Access Web, but it does require a Windows administrator to implement for you. Again, you would be limiting access in your front end application, rather than actually restricting user rights in the back-end MDB.
Only Jet ULS actually allows you to prevent a READ-ONLY user (who hasn't cracked your workgroup file) from editing your data. All users have to have network access to your back-end MDB, but you can make it hard for them to get to the data even without jumping through the hoops in implementing Jet ULS. Here are some steps to do that (and yes, all of these are a form of 'security by obscurity' and will only slow down a READ-ONLY user determined to hack your back end):
-
Right click each table in your back end and turn on the HIDDEN attribute. This can also be done in code (see SetHiddenAttribute in Help). Naturally, if the end user sets their Access options to display hidden tables, this won't do anything. But most end users don't know about that, and if your users are running your app in the runtime, they won't have the option.
-
Change the back-end database's Startup Properties to not display the database window and to not use special keys. You can find code for setting the startup properties in the Help topic for 'AllowBypassKey'.
-
In your back-end, create a macro named AutoExec with one command, Quit. With special keys disabled, there is no way to prevent the execution of this macro, and as soon as the user attempts to open the back end (even if they hold down the SHIFT key, i.e., the standard keystroke for bypassing all startup routines), the database (and the instance of Access) will close.
Now, all of these things can be undone by someone who knows what they are doing. If you gave me a back end with these things implemented, I'd be in it in about 5 minutes, simply by running code in another Access database to change all these startup properties to give me access.
But your end users likely don't have that level of expertise. Any such user who does probably ought to be a WRITE user, no? :)
Yes, of course -- all of these things are easily hackable by anyone who knows how. But it's also easy to break into your house in seconds for the person with the right tools. That doesn't mean you don't lock the doors, even though it's not bulletproof protection from burglary.
Another consideration is that if you provide your users only the Access runtime instead of full Access, they won't be able to undo any of these settings in your back-end MDB.
Last of all:
Security is not solely a technical issue -- most of it is, in fact, a people problem. In order for people to do their work, you have to trust them to a certain extent in giving them access to your data. There is no technical solution to the problem of the untrustworthy system administrator, for instance, and the only way to fully protect your data is to not give them any access to it at all.
Marc Gravell♦
819k209 gold badges2220 silver badges2616 bronze badges
David-W-FentonDavid-W-Fenton
21.3k3 gold badges38 silver badges53 bronze badges
This is the cheeky answer, but if you need better security, seriously consider upgrading to a more robust RDBMS.
Christian OudardChristian Oudard
27.9k22 gold badges61 silver badges68 bronze badges
I think it is possible using an ODBC connection to use Access as an interface to almost any database. For example, I have successfully configured a SQL Server 2008 Express Edition database with 2 users, one read/write and one read-only. I have been able to connect to the database from Access by opening an ODBC data source. So a user can have the Office-based report-generating and mail-merging functionality they are familiar with. But with any database server you wish.
LiamLiam
10.6k20 gold badges74 silver badges102 bronze badges
This conversation may be a little old, but for some reasons I got the same problem recently. It will not suit to everyone, cause it relies not on M$ SQL Server but on MySQL. Use the MySQL ODBC connector (available here: http://dev.mysql.com/downloads/connector/odbc/), and store your tables on a MySQL server. The Access user's rights on tables will inherit from the MySQL user's rights. Pretty easy to customize...
GregGreg
Fact is, there is NO functional security for an access database.
The link below sells software that will 'recover' your access database Even if it has a a password.
It is a good thing they exist. Their program saved one of my customer's butts once when their previous programmer died and no one else had the password. Thanks to this program we could not get in and no data was lost.
And before you even think it, No, I do not work for them.
CurtTampaCurtTampa
protected by Community♦Oct 14 '14 at 14:13
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged ms-accesspermissions or ask your own question.
Similar Messages:
Modules & VBA :: Backup Code Getting Permission Denied Error
Rsop Data Missing
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....
Code:
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
[code]....
I got a compile error 'Invalid use of property.' on the button sub. Then there was a simple On Click sub:
Code:
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...
Code:
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
[code]....
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.
Code:
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
[code]....
I got a compile error 'Invalid use of property.' on the button sub. Then there was a simple On Click sub:
Code:
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...
Code:
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
[code]....
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.
General :: No Permission To Open Database Object Error
Jan 20, 2015
I have a 2003 .mdb file and the associated Workgroup Information File which normally resides on a network in a folder V:V-Base-DatabaseDATA. I have the Workgroup Information File.
The database is unsupported and we need to migrate the data to a new web based database.
When I try to open the database with the shift key down I get the following message :
You do not have the necessary permission to use the V:V-Base-DatabaseDATAV-Basebe.mdb object.
What is the best way to access the data and do I need to do this on the server instead of a local drive off site?
The database is unsupported and we need to migrate the data to a new web based database.
When I try to open the database with the shift key down I get the following message :
You do not have the necessary permission to use the V:V-Base-DatabaseDATAV-Basebe.mdb object.
What is the best way to access the data and do I need to do this on the server instead of a local drive off site?
The User Does Not Have Rsop Data Microsoft Access 2017
' Error - 'The Current User Account Doesn't Have Permission To ......'
Jul 31, 2006
Hello
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.
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.
MSysTable Permission....
Dec 14, 2005
The programmer who built this access program is no longer here...Everytime I create a new Report, it works great for me...but the person I made it for ALWAYS gets the MSystable permission error....I have gone through the wizard to give them every permission available on the report and the query it is using...AND went and made sure permission was given on the SQL side of things as well...YET I still get this incredibly annoying error...that seems there is no real answer to...CAN ANYONE help?!!! even compacted and repaired the program...still no good....I know it will be something small, but I can not see it.
Access Permission
Jan 17, 2007
Hi there
Can i set permission on a single button in a access database form for specific number of users. And rest of the database is available for everybody ?
Thanks
Danny
Can i set permission on a single button in a access database form for specific number of users. And rest of the database is available for everybody ?
Thanks
Danny
Permission Problem??
Feb 7, 2005
hi, when i tried to use 'update' i got this error, no problem with 'select' . it is got something to do with the permission setting?? using winxp pro, ms acccess 2003.
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/okl/topics/DC/Basic/VD_Q1_Result.asp, line 72
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/okl/topics/DC/Basic/VD_Q1_Result.asp, line 72
Permission Problem
hi,
i have this problem if anyone can help me please,
i have some databases in my server(dc) + the Microsoft Office Access Workgroup Information(secured.mdw) ...
when i open the database i get this error message
('You do not have the necessary permission s to use
the 'dcdatabases$systemsdecdec sharedec_wahab.mdb'
Gas Supplier.mdb' object. Have your system administor or
the person who created the object establish the
appropriate permissions for you.')
then how can i open the database?
i have this problem if anyone can help me please,
i have some databases in my server(dc) + the Microsoft Office Access Workgroup Information(secured.mdw) ...
when i open the database i get this error message
('You do not have the necessary permission s to use
the 'dcdatabases$systemsdecdec sharedec_wahab.mdb'
Gas Supplier.mdb' object. Have your system administor or
the person who created the object establish the
appropriate permissions for you.')
then how can i open the database?
You Do Not Have Permission To Enter This Database
Oct 5, 2005
Hello,
I get the above message when I try to open a database created by someone that no longer works here. I tried to create a new version of the workgroup information file and assume the permissions of the administrator, but I still cannot access the database. Any leads?
Thanks
I get the above message when I try to open a database created by someone that no longer works here. I tried to create a new version of the workgroup information file and assume the permissions of the administrator, but I still cannot access the database. Any leads?
Thanks
User Permission Problem
Jul 17, 2007
Hi,
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?
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?
Access97 Permission Problem
Dec 19, 2007
I bought a database about 10 years ago and still uses it. Since then we changed our address and need to update all the forms as the address is hard coded into the forms. When I tried to modify any thing it tells me I don't have the Permission. I tried to contact the programmer, but he's been out of business years ago and was unable to contact him.
How do I reset the permission on MDB? I tried Tools->Security->User/GroupPremissions and it only shows Admin user with 'Read Design' checked on all object names. And if I check on any other permission it says I need administer permission.
I tried upvmsa2k.zip 'Users' passwords viewer v3.2' and it shows admin user with garbled up password. Also tried MDWRecovery, but it says there's no user or password.
Your help would be greatly appreciated.
How do I reset the permission on MDB? I tried Tools->Security->User/GroupPremissions and it only shows Admin user with 'Read Design' checked on all object names. And if I check on any other permission it says I need administer permission.
I tried upvmsa2k.zip 'Users' passwords viewer v3.2' and it shows admin user with garbled up password. Also tried MDWRecovery, but it says there's no user or password.
Your help would be greatly appreciated.
User And Group Permission
Feb 5, 2008
Hi,
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.
regards,
SF
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.
regards,
SF
ODBC Read Permission
Aug 17, 2007
Hi,
I am using MS Access which has a ODBC link to a sql database. I find that the linked table can be edited in Access.
I would like to prevent editing in this Linked table. IS there a way?
Thanks
I am using MS Access which has a ODBC link to a sql database. I find that the linked table can be edited in Access.
I would like to prevent editing in this Linked table. IS there a way?
Thanks
Access 200 Permission Lockup
Feb 20, 2008
Either when copying from one db to another on my machine or running a db produced on that machine on a network, I get the message 'the database has been placed in a state by user (my machine is called 'Rat') that prevents it from being opened or locked'. =Error 3734.
The security data says I am 'Admin' and permission is set for Admin and Users. It has been doing this intermittently for a while and now does it all the time.
Follow up data
All databases are created, revised and run on home machine (Rat) and run on the office network.
The offending DB will permit internal design, editing , copying and will accept pasting IN of tables etc. from other DBs. But it will not allow copying OUT of files such as a table to other DBs even on the machine that created them. However it will allow copying and pasting of objects such as forms in visual form or individual query cells to other DBs.
I’ve carefully compared the Tools/Security/User & Group Permissions with a good running version of the DB and can see no difference.
Permission settings on good and bad DBs are:-
Permissions: Admin Object: Current DB
Checked: Open/Run, Open Exclusive, Administer.
I’ve also checked each individual files’ Permissions. The .ldb file, viewed with Word with the offending DB running on my office machine (Weasil), reads:-
WEASIL_ Admin_
The creating machine “Rat” uses the Account “Richard”: but I have had few similar problems before. While revising the DB, I made 30 copies of at each stage along the way but saved carefully each design change and certainly did not deboot the computer without doing so.
I’ve tried the above procedure on my computer (Weasil) at the office, but got the same result. So it’s not the computers or MS Access 2000 program. Somewhere along the line, perhaps, the DB got corrupted. It Repaired and Compacted OK but still has the problem.
The security data says I am 'Admin' and permission is set for Admin and Users. It has been doing this intermittently for a while and now does it all the time.
Follow up data
All databases are created, revised and run on home machine (Rat) and run on the office network.
The offending DB will permit internal design, editing , copying and will accept pasting IN of tables etc. from other DBs. But it will not allow copying OUT of files such as a table to other DBs even on the machine that created them. However it will allow copying and pasting of objects such as forms in visual form or individual query cells to other DBs.
I’ve carefully compared the Tools/Security/User & Group Permissions with a good running version of the DB and can see no difference.
Permission settings on good and bad DBs are:-
Permissions: Admin Object: Current DB
Checked: Open/Run, Open Exclusive, Administer.
I’ve also checked each individual files’ Permissions. The .ldb file, viewed with Word with the offending DB running on my office machine (Weasil), reads:-
WEASIL_ Admin_
The creating machine “Rat” uses the Account “Richard”: but I have had few similar problems before. While revising the DB, I made 30 copies of at each stage along the way but saved carefully each design change and certainly did not deboot the computer without doing so.
I’ve tried the above procedure on my computer (Weasil) at the office, but got the same result. So it’s not the computers or MS Access 2000 program. Somewhere along the line, perhaps, the DB got corrupted. It Repaired and Compacted OK but still has the problem.
Why Those Permission Differences Btw Access Files ??
Sep 1, 2005
Hi accessors,
I have 1 permissions related Q.
If I create msaccess db by calling the app through its icon, i get a db with following permission items :
Administrators(compNameAdministrators)
System
user(compNameuser)
but if I create it through rightclick> new> ms_office_access_application, I get a db with:
Administrators(compNameAdministrators)
Everyone
System
user(compNameuser)
Users(compNameUsers)
VS Developers(compNameVS Developers)
Why /the hell/ those differences btw the same kind of files ? :mad:
greets
I have 1 permissions related Q.
If I create msaccess db by calling the app through its icon, i get a db with following permission items :
Administrators(compNameAdministrators)
System
user(compNameuser)
but if I create it through rightclick> new> ms_office_access_application, I get a db with:
Administrators(compNameAdministrators)
Everyone
System
user(compNameuser)
Users(compNameUsers)
VS Developers(compNameVS Developers)
Why /the hell/ those differences btw the same kind of files ? :mad:
greets
Is It Wise To Change Security Permission .....
Mar 20, 2007
When users are active in DB
Column Permission In Access Table
Jan 4, 2005
Hi,
I have a table in Access database. I would like to set read only permissions to some of the fields/columns in the table. I do not want user to alter or edit some fields/columns in a table. Could someone give a solution for this?
thanks in adavance
Jayashankar
I have a table in Access database. I would like to set read only permissions to some of the fields/columns in the table. I do not want user to alter or edit some fields/columns in a table. Could someone give a solution for this?
thanks in adavance
Jayashankar
Modules & VBA :: Permission Denied On Own Profile
Sep 12, 2014
I have a backup procedure that is giving me a 'Permission Denied' on my own profile.
Code:
Public Function BackupFE()
On Error GoTo BackupFE_Err
Dim SourceFile As String, DestinationFile As String
Dim aFSO As Variant
Dim Path As String, Name As String
[Code] .....
I've been over this and over it again.
Code:
Public Function BackupFE()
On Error GoTo BackupFE_Err
Dim SourceFile As String, DestinationFile As String
Dim aFSO As Variant
Dim Path As String, Name As String
[Code] .....
I've been over this and over it again.
Access 2003 Security Permission Problem
Oct 19, 2006
Hi,
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 :)
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 :)
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?
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?
Forms :: Access Permission On Tabs For Some Users
Jul 23, 2013
I have a form with several tabs and I don't want to give permission for some users on some tabs. How can I do it?
How To Create Users And Permission In MS Access 2010
Apr 29, 2013
how to add security features into My Access database. i.e create users with permissions/login.
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
thanks
:confused:
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
thanks
:confused:
General :: Table Opening With Permission Denied Message
Jan 14, 2013
I have a simple log table that I am opening from a button on a form and adding a new record to the table.The table opens bu I get 'Permission Denied' as a message - however I can then enter the form and enter data with no problem.why the VBA code cant do the same? what does Permission Denied usually mean?
How To Get Full Permission:Add, Delete, Update, Edit In The SQL Server Database
Jul 26, 2007
I wrote the following statements to update a SQL server database:
Dim MyDb As Database
Dim MyRs As Recordset
Set MyDb = DBEngine.Workspaces(0).OpenDatabase('AMD', dbDriverPrompt, False, 'ODBC;DATABASE=AMD;DSN=Remote')
Set MyRs = MyDb.OpenRecordset('SELECT AllAttendanceEvents.* FROM AllAttendanceEvents ORDER BY AllAttendanceEvents.EntryTime DESC')
MyRs.MoveFirst
While Not MyRs.EOF
MyVal = MyRs!EntryTime
Debug.Print MyVal
MyRs.Edit
MyRs!Ix = 50099
MyRs.Update
MyRs.MoveNext
Wend
When it execute the red line statement, it generates the error:Cannot update. Database or object is read-only.
This error is generated isnpite that I already checked the boxes: SELECT, INSERT, UPDATE, DELETE in the Permissions page of the tables?
Please advise.
Dim MyDb As Database
Dim MyRs As Recordset
Set MyDb = DBEngine.Workspaces(0).OpenDatabase('AMD', dbDriverPrompt, False, 'ODBC;DATABASE=AMD;DSN=Remote')
Set MyRs = MyDb.OpenRecordset('SELECT AllAttendanceEvents.* FROM AllAttendanceEvents ORDER BY AllAttendanceEvents.EntryTime DESC')
MyRs.MoveFirst
While Not MyRs.EOF
MyVal = MyRs!EntryTime
Debug.Print MyVal
MyRs.Edit
MyRs!Ix = 50099
MyRs.Update
MyRs.MoveNext
Wend
When it execute the red line statement, it generates the error:Cannot update. Database or object is read-only.
This error is generated isnpite that I already checked the boxes: SELECT, INSERT, UPDATE, DELETE in the Permissions page of the tables?
Please advise.
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 fine.im 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?
Code:
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 & '')
[code]...
Code:
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 & '')
[code]...