Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2002
    Location
    St Albans, Hertfordshire, England
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing External Notification (2000 sr1)

    Now here's a challenge for ya'!

    I have been using a modified version of a user manager form taken from the Access 2000 Developer's Handbook, (Volume II by Litwin, Getz, and Gilbert. - great book, would recommend it to any serious programmers) - code available if needed/wanted.

    When I bring up the form, it builds a list of all open connections to the database, and it also gives me the option of locking any new connections out of the database (great for closing down an app gently for routine maintenance).

    If a user tries to access the database, they get this message:

    'Database X has been placed in a state by user y that prevents it from being opened or locked'

    From a user perspective, this is an ugly, automatic message witihn the access system - is there anyway to capture this error message, and return back a nicer message along the lines of

    'This database is currently undergoing routine maintenance - please try again at 12:30pm. If you have any further questions, please contact your local team administrator. Thank you for your co-operation'

    I'm a nice guy ( <img src=/S/angel.gif border=0 alt=angel width=15 height=21>), and I think users react better when treated with kid gloves - it's hard enough to implement big changes, without the IT letting you down!

    Thanks folks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Changing External Notification (2000 sr1)

    You aren't asking for polite, you're asking for "cozy". The problem is that there's no database open when this message is returned, so where did you expect to trap the error?
    Charlotte

  3. #3
    Lounger
    Join Date
    Mar 2002
    Location
    St Albans, Hertfordshire, England
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing External Notification (2000 sr1)

    Charlotte,

    I realise that the DB wouldn't actually be opened, as it's status is effectively 'locked' - I was going for the longshot, that somebody else had implemented something along these lines, and had managed to trap the error using the Windows API?

    Another alternative is to have a two-step gateway - i.e. where the user selects one database, which automatically opens another as part of a function - would the function receive the returned errorcode? I would assume not, as it is not an access error, but a windows error.

    Thanks for getting back to me anyway

    Chris

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Changing External Notification (2000 sr1)

    Chris -
    Just an alternative we use - we have a small VB app that runs on each workstation and checks each time a database is opened (we don't use shortcuts or the Start Menu), and if a new version has been deployed, then we download the latest version to the workstation (or in the case of Terminal Services or Citrix to a specified location on the server). Using this technique the user is never really locked out of a database unless the wheels have totally fallen off. I should add that we are using SQL Server as the back-end (primarily via ODBC) so we don't have much in the way of maintenance issues. We actually deploy about 30 different front-end databases to various users at one client that way. If you are interested in more details, feel free to respond or send a private message.
    Wendell

Posting Permissions

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