Users and Groups Listing from Workgroup Information File
Posted On 24 Oct 2011 By a.p.r.pillai. Under MS-Access Security.
How about taking a print out of Users and Groups from the active Workgroup Information File (Microsoft Access Security File)? This is only for users of Microsoft Access 2003 ... Continue Reading
No Comments
Access Security Key Diagram
Posted On 17 Oct 2011 By a.p.r.pillai. Under MS-Access Security.
As you are aware implementing Microsoft Access Security is serious business. Even though this has been deprecated from Access2007 and later versions, thousands of Access Developers are still using this ... Continue Reading
No Comments
Running Workgroup Admin in Access2007
Posted On 16 Aug 2011 By a.p.r.pillai. Under MS-Access Security.
If you are serious about Microsoft Access User-level Security in earlier versions (.mdb files) of Access Databases and would like to continue using them in Access2007, with the security settings ... Continue Reading
No Comments
User-level Access Security and Access2007
Posted On 14 Apr 2011 By a.p.r.pillai. Under MS-Access Security.
User-level/Object-level Access Security concepts remains with Access versions earlier than Access2007. All my Microsoft Access Applications were secured with User-level/Group-level Security and it is so effective when applications are shared ... Continue Reading
No Comments
User and Group Check
Posted On 26 Aug 2010 By a.p.r.pillai. Under MS-Access Security.
In a secured Database; basic access rights to Objects like Tables, Forms, Queries and Reports are defined for specific Workgroups/Users as a one time exercise. This takes effect automatically ... Continue Reading
No Comments
Change Secure DB to Unsecured
Posted On 25 Jul 2010 By a.p.r.pillai. Under MS-Access Security.
It is very unlikely that you want to change the status of a Secured Database (implemented with Microsoft Access Security) to an unsecured one. This exercise become necessary when you ... Continue Reading
8 Comments
Group Account Permissions with VBA
Posted On 17 Mar 2010 By a.p.r.pillai. Under MS-Access Security.
We have learned how to remove all permissions from all Objects for Users Group Account as all Users belongs to this default Group Account and inherits permissions, if available, besides other Group Accounts each user belongs to. If you have not gone through the earlier Articles on Microsoft Access Security with VBA, you may take a look at the following links before continuing:
Create Security Group Account with VBA
Users Group and Permissions
Creating User-Account with VBA
Create Security Group Account with VBA
Users Group and Permissions
1 Comments
Users Group and Permissions
Posted On 07 Mar 2010 By a.p.r.pillai. Under MS-Access Security.
When you create a new Workgroup Information File, as part of the Microsoft Access Security implementation, it is important that the following two steps you follow immediately after creating the new Workgroup Information File (.mdw) file on priority basis:
No Comments
Create Security Group Account with VBA
Posted On 01 Mar 2010 By a.p.r.pillai. Under MS-Access Security.
Last week we have learned how to create a Microsoft Access Security User Account(SMITHJOHN) with VBA and learned how to join him as a member of the default Group Account Users. The Users and Admins Group Accounts are already present in the default Workgroup Information File (Sytem.mdw) or in the new Workgroup Information File that you create separately.
1 Comments
Creating User-Account with VBA
Posted On 22 Feb 2010 By a.p.r.pillai. Under MS-Access Security.
For creating a Microsoft Access User-Account manually in the Workgroup Information File (.mdw) we go through Tools - -> Security - -> User and Group Accounts - ->User Name Option. ... Continue Reading
3 Comments
SHARE PREVIOUS VERSION DATABASE
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Share a previous-version secured database across several versions of Microsoft Access.
With one exception, the issues involved when sharing a secured database across more than one version of Microsoft Access are ... Continue Reading
No Comments
CONVERT OLDVERSION WORKGROUP FILE
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Convert a workgroup information file from a previous version of Microsoft Access.
To take advantage of security and performance improvements, you should re-create the Workgroup Information File as described below:
Create a ... Continue Reading
1 Comments
CONVERT MSACCESS OLD VERSIONS
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Convert a Microsoft Access 95 or 97 secured database.
When upgrading from Microsoft Access 95 or 97, you need to convert your secured database, but you don't need to convert the ... Continue Reading
No Comments
RUNPERMISSIONS PROPERTY
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
RunPermissions Property
You can use the RunPermissions property in a multi-user environment with a secure workgroup to override the existing user permissions. This allows you to view a query or run ... Continue Reading
No Comments
DEFAULT PERMISSIONS FOR NEW QUERY
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Change default permissions for all new queries.
You can change the default permissions that allow others to view data returned from queries or in the case of action queries, to run ... Continue Reading
No Comments
PERMIT TO VIEW RUN QUERY
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Permit others to view or run my query but not change data or query design.
In a secure workgroup, you can assign others permission to view the data your query returns, ... Continue Reading
No Comments
TRANSFER OWNERSHIP OF DATABASE
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Transfer ownership of an entire database to another administrator
Start Microsoft Access by using a secure workgroup that contains the user account that you want to own the database and its ... Continue Reading
No Comments
VIEW OR TRANSFER OWNERSHIP
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
View or transfer ownership of individual Tables, Queries, Forms, Reports and Macros in a secure database.
If you have Administer permission for a Table, Query, Form, Report or Macro, you can ... Continue Reading
No Comments
ASSIGN DEFAULT PERMISSIONS
Posted On 29 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Assign default permissions for new Tables, Queries, Forms, Reports and Macros.
Open the database that contains the Tables, Queries, Forms, Reports and Macros. On the Tools menu, click Security and then click ... Continue Reading
No Comments
ASSIGN OR REMOVE PERMISSIONS
Posted On 28 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Assign or remove permissions for a database and existing Tables, Queries, Forms, Reports and Macros
Open the database that contains the Tables, Queries, Forms, Reports and Macros that you want to ... Continue Reading
1 Comments
CLEAR SECURITY PASSWORD
Posted On 28 Nov 2006 By a.p.r.pillai. Under MS-Access Security.
Clear a security account password
To complete this procedure, you must be logged on as a member of the Admins group.
Start Microsoft Access by using the workgroup information file in which ... Continue Reading
No Comments
