Home Contact Us Consulting

Menu
About Us
Download Demos
Business Products
Developer Tools
Developer Partners / Resellers
Third Party Software
Training Courses
Hardware
Support
Related Links
Special Upgrade Offer

 

EZ Tools
Surgical Strike
Report Manager Pro
Picture Builder
Search Manager Pro
Access Project Security
appBuilder

 

Consulting

Technical Support
Training
Custom Programming
Data Conversion


Access Project Security

 

As a developer, you know that user security is a common requirement for applications you build. However, if you are using Access 2000/2002/2003 Projects with MSDE or SQL Server, you are limited to data security only. 

Now, you can secure forms, reports and their controls with the Access Project Security Manager (APSM). The APSM integrates within your application and provides much needed user level security for your Access Project databases (.adp/.ade). Limit what each user can see and do based on your custom security needs. 

 

Features
  • Integration with the User ID associated with the Microsoft Database Engine (MSDE) or your SQL Server connection
  • Provides for user and group management
  • Can apply security for controls on forms and reports
  • Set permissions for objects including forms and reports. Give each user no access, read only, edit, append, delete, etc.
  • Tables are used extensively to drive the interfaces to make customization easy and flexible
  • No knowledge of VBA coding is required
  • All source code included
  • Set permissions for controls on forms and reports - no access 
  • Include royalty free in one or more applications based on the license you purchase
 
What You Get

The Access Project Security Manager includes the following:
  • APSM software on CD-ROM or via electronic download
  • 30 days free technical support
  • Electronic user guide in Adobe Acrobat .PDF format
  • Example files to help you get started
 
Product Overview


What Do You Need to Know to Use the APSM?

To use the APSM you must know the basics of Microsoft Access Projects. This includes understanding Access objects and how they are used. You also need to know the basics about MSDE/SQL Server security. You do not need to know how to program in VBA (Visual Basic for Applications), but it is helpful if you know how to add VBA code on the OnOpen event of a form or report.

Components

The Access Project Security Manager consists of a set of tables, forms, reports, and a module that you include in your application. The tables are stored in the MSDE/SQL Server database, while the forms, reports and module are stored within your Access Project.

Overview

The Security Manager is a stand alone form that administrators can use to maintain user memberships, groups, group permissions, object permissions, monitor security system status, and print security reports. There are several tabs on the form that are used to select the various functions. On the Users tab, as shown below, there is a combo box that contains a list of users for the current database. This list of users comes from the user system table within MSDE/SQL Server.  You can choose a user from MSDE/SQL Server security, or add a new user by just typing in the name and then assigning a group to the user. The new user must then be added to MSDE/SQL Server Security. The user must be setup in MSDE/SQL Server security for the APSM to work for that user.  Deleting a user from the APSM is done by simply removing all groups for a user. 

Users belong to groups, and the Groups tab provides the interface to add new groups, and delete groups (see the following figure). In addition, a list of groups is shown and selecting a group will show a list of users that belong to that group.

Once a group has been established, the administrator can set the permissions for the group.  This includes setting permissions for forms, form controls, reports, and report controls.  This is where the APSM goes beyond MSDE and SQL Server security.  Imagine, using the same form or report for all users.  You can limit who can open the form or report.  Control what each user can do on the form, and what data fields they have access to.  Use the same report for all users, restricting sensitive data based on who is running the report.

Permissions for forms include: No Access, Read Only, Add Only, Edit Only, Edit and Add, Edit and Delete, Edit/Add/Delete.  Permissions for form controls vary depending on the control and include such types as: No Access, Read Only – Enable, Read Only - Disable, Read/Write, Not Visible, and Visible.  Reports and report controls have the same types of permissions: No Access, and Print.  Even the permissions are table driven so the above lists can be modified to suit an application’s specific needs.

The checkbox Auto add code to objects when checked, will add the security VBA code to the appropriate form or report if it is not there.  There are a few lines of code needed on the form open and report open event to check for security when they are opened.  If the security function determines a user does not have permission to open a form or report, then that object is prevented from loading with a message displayed that the object cannot be opened due to security.

Once group permissions have been established, you can view the permissions for reports and forms on the Object Permissions tab.  Just choose the type of object and select the object by name from the pull-down list.  The control name and type is displayed along with the group names and permissions assigned.

The security system status, listing of security tables, and various buttons to perform other functions is available on the Status tab of the Security Manager (see the following figure).

Pressing the Database Security button pops up the SQL Server security dialog box. The Change Connection button, when pressed, displays the Data Link Properties dialog window so you can change the server, database, as well as the logon user id. The Update Status button will refresh the tab on the form with the system status and security tables. The Check Code button will go through all the forms and reports that have security permissions established and make sure that the appropriate VBA code is in place to call the security functions when the object is opened.

These reports provide documentation for the security system groups, users and permissions. Sample reports are included with the Access Project Security Manager. You can modify these reports or create your own based on your needs.

 

Pricing

APSM - Single  Developer/Single Application

 

$299

APSM - Single Developer/Multiple Applications

 

$499

APSM - Unlimited Developers/Applications

 

$999

APSM - Printed User Guide

 

$12


 

APSM:

  • Works with Access 2003, 2002 and 2000

  • Includes 30 days free support

 

System Requirements:

  • Access 2000 or higher

  • Windows Operating System

  • 15MB Free hard disk space

Back Home Up Next


Database Creations
Sales: 800-277-3117 - Support: 860-644-5891
Fax: 800-277-3117 - Email: sales@databasecreations.com

©2012 Database Creations LLC. All Rights Reserved. Privacy Statement