HALLOGRAM PUBLISHING
SHOPPING CARTSITE MAPCONTACT USPRODUCTS
HOMEBARCODESDEVELOPER TOOLSUSER TOOLSTRAINING
Access Project Security Manager

group.jpg

apsmbox.jpg

As a developer, you know that user security is a common requirement for applications you build. However, if you are using Access 2000 Projects with the new MSDE or SQL Server 7, 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 2000 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 your application(s) based on the license you purchase

What You Get

The Access Project Security Manager includes the following:
  • Access Project Security Manager software on CD with all source code
  • 90 days free technical support
  • Example files to help you get started
  • Printed user guide

Overview

Below is a brief overview of the Access Project Security Manager. This product includes a 30-day money back guarantee and 90 days of free technical support.

What Do You Need to Know to Use the APSM?

To use the APSM you must know the basics of Microsoft Access 2000 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 2000 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.

apsm1.jpg

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.

apsm2.jpg

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.

apsm3.jpg

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.

apsm4.jpg

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).

apsm5.jpg

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.

apsm6.jpg

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.


System Requirements:
Access 2000 • Runs on Windows 95 and higher, Windows NT 4 with service packs

Access Project Security Manager
Single Dev/Single App $299
Single Dev/Multi App $499
Unlimited Developers and Apps $999


Home || Shopping Cart || Site Map || Newsletter/Blog
Search HALLoGRAM || Request More Information
CALL TOLL FREE 1-866-340-3404

SEARCH
14,500+ PRODUCTS:

Order Access Project Security Manager

SIMILAR PRODUCTS
  • Security Components

  • OTHER PRODUCTS
  • Picture Builder Add-On Pak
  • User Interface Construction Kit
  • Yes! I Can Run My Business
  • TabMaster Pro Wizard
  • Calendar Construction Kit
  • Database Creations Check Writer
  • General Ledger
  • Inventory Manager
  • The Generator
  • User Interface Developer's Suite
  • EZ Application Manager
  • EZ Support Interface
  • EZ File Manager
  • EZ Report Manager
  • EZ Controls
  • EZ Search Manager
  • EZ Security Manager
  • EZ Extensions
  • EZ Developers Suite
  • PC Payroll
  • PaperBridge
  • POSitively Business!
  • US Shipping System
  • Button Designer Pro
  • Business Forms Library

  • PRODUCTS FOR
  • MS-Access
  • ActiveX/OCX Controls
  • C/C++
  • Clipper
  • dBASE
  • Delphi
  • FoxPro/VFP
  • Java
  • Macintosh
  • Oracle
  • Paradox
  • PowerBuilder
  • Visual Basic
  • Visual Objects

  • Keystone Training Videos

  • Copyright �2000 HALLoGRAM Publishing, Aurora CO. All Rights Reserved
    All products mentioned in this site are trademarks of their respective owners
    Prices are subject to change without notice
    dmcakegrim