Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Setting conditional compilation constants (Access 03)

    I have a database application that exists in two variants - a full version, and a cut-down "read-only" version for "guests". Currently there are two versions of the front end, but for ease of maintenance I'd like to move to a single front-end application. I am considering using conditional compilation to remove unwanted functionality from the "guest" version. In Access 97, you could set a conditional compilation constant in the Advanced pane/tab of the Options dialog box and thus be sure it was set globally across all code in the database. This facility doesn't seem to exist in A03 - you have to assign a value to the constant in each code module. Can anyone think of an efficient and reliable way to implement this kind of thing? (I'll also need to enable/disable controls and menu items.)

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Setting conditional compilation constants (Access 03)

    Why not use User Level Security ?
    Francois

  3. #3
    New Lounger
    Join Date
    Nov 2001
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Setting conditional compilation constants (Access 03)

    That's an idea. I use user-level security now to do things like preventing guests changing the data, but I could use it to disable certain modules and forms that guests aren't allowed to use. However, I would like to alter the user interface in a more user-friendly way too, instead of leaving controls enabled for guests to try, and letting the User Level Security send its unfriendly messages.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Setting conditional compilation constants (Access 03)

    If you are using User Level Security, you can use the CurrentUser to see who has logged in and if you want, load different forms (like you say "more user-friendly") if the user is a guest.
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •