Peter's Software
Helping you create better Microsoft Access applications

Table of Contents

General

I can't open the LASsie User Security form. It says I am not allowed.





How can I retrieve the LASsie user name used to sign in?





Will LASsie prevent a user from opening a form in design mode?





Installation

How do I setup the LASsie shareware version with my application in a multiple user environment?





Errors

When I have other code in the form OnOpen event procedure, I get error number 2467 "The expression you entered refers to an object that is closed or doesn't exist.".





(Version 3) When I try to add a new user via the form "frmUserSecurity", Access crashes. I'm using Access 2000 and Windows 2000. What do I do?

Answers

1. I can't open the LASsie User Security form. It says I am not allowed.
   
   Some users have reported a problem when opening the LASsie User Security form for the first time. If you see a message saying that you are not allowed to open the form, you will need to sign on to LASsie first. Open the LASsie Main Menu and click "Open Sign On Form".. Enter user name "Admin" and password "Admin" if it is your first time signing on. Then try opening LASsie User Security again.
   [Back to the top]
    
2. How can I retrieve the LASsie user name used to sign in?
   
   The function LAS_GetUserName() will return the current user name.
   [Back to the top]
    
3. Will LASsie prevent a user from opening a form in design mode?
   
   No. To prevent a user from opening a form in design mode, make an .mde (or .accde) version of your database, or use the /runtime switch when starting Access.
   [Back to the top]
    
4. How do I setup the LASsie shareware version with my application in a multiple user environment?
   
   (Shareware version 4 only)
   
   The data file "lasdata.mdb" is the only one you need on the server for a multiple user application. This file contains security data to be shared by all your users. Copy it from your local LASsie installation folder to a shared folder on your server.
   
   For each end-user computer, a LASsie installation is required.
   
   After installing LASsie on an end user's computer, click Tools > Add-Ins > LASsie User Security to see the registration prompt. Enter the provided Registration Code to register this copy of LASsie. This will also add a reference from your application to the local LASsie library.
   
   Next click the LASsie Properties button from the User Security form and then click the Relink Security Tables button. Find the file "lasdata.mdb" on your server, select it and click Open.
   
   The local application is now registered and connected to the shared LASsie security data.
   [Back to the top]
    
5. When I have other code in the form OnOpen event procedure, I get error number 2467 "The expression you entered refers to an object that is closed or doesn't exist.".
   
   This error occurs because the LAS_EnableSecurity function has closed the form, yet there are additional lines of code to process in the OnOpen event procedure. To resolve this, you can either trap for the 2467 error, put the LAS_EnableSecurity function call at the end of your OnOpen event procedure, or use the LAS_EnableSecurity funciton call in an "if" statement like so:
   

   Private Sub Form_Open(Cancel As Integer)
   If LAS_EnableSecurity(Me) Then
       '* Failed to pass security, form will be closed
       Exit Sub
   End If
   
   '* Other OnOpen statements could go here...
   
   End Sub
   

   
   [Back to the top]
    
6. (Version 3) When I try to add a new user via the form "frmUserSecurity", Access crashes. I'm using Access 2000 and Windows 2000. What do I do?
   
   This is an Access bug that is described here:
   
   http://support.microsoft.com/default.aspx?scid=kb;en-us;304084

   The resolution, as mentioned at the link above, is to install Jet 4.0 Service Pack 6 (SP6).
   [Back to the top]