Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking Unanswered: How to disallow closing Access thru IE browser

    Hi,

    I am trying to assist another dept. at my job with a seemingly small issue, that I don't know how to resolve. They are using A2K3 through IE6, making it a web based database. What they are having a problem with is people closing the program improperly. They SHOULD be using the CommandButton in Access to close it BEFORE closing the browser. But that are just clicking to (X) Close on IE6 and they say this is causing a problem with Access, saying it's leaving the .ldb that the file is still open. I know working directly in Access you just set the forms CloseButton to NO. But this doesn't help prevent them from closing the browser prior to exiting the actual database itself. Is there a way to do this? Please help if you have any ideas.

    thanks
    Bud

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    First tell us how Access 2003 is being access via IE6
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by StarTrekker
    First tell us how Access 2003 is being access via IE6
    Hi there ST. I'm not sure of that but will see if I can get with someone on their side and find this out. I am just going on what I heard the Sup. ask about yesterday. Just the visual it is just Access on the Web is all I can say at this point. Let me see what I can find out.

    Bud

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I'm assuming your working with an mdb file for the web (if not disregard this).

    I wonder if you're able to run a *.vbs script to launch the MSAccess mdb for the web-site (you may have to add the website to the trusted sites for each user to allow running vbs scripts.) If so, you could use something like the cloning script in the code bank. This would at least prevent the *.ldb from locking other users out of the mdb (since every user is in essentially their own mdb cloned from a source mdb.) I'm not sure though without more info on what you mean by web-based database (is this an ASP project?) Or are they just opening an mdb file via the web?

    If the website automatically launches the mdb when the user connects, have it instead run the *.vbs script.
    If the user opens the website, navigates to a folder, and then opens the mdb, have them open the *.vbs script in the folder instead of the mdb.

    All users open my mdb files via vbs scripts so if a user who is connected via the web clicks the X (ie. to close their web citrix session), that mdb file isn't then locked for other users since there will only be a "hanging" *.ldb file for ONLY that specific user (which will fix itself the next time that specific user connects and runs the script again.) (there's also numerous other benefits using the script such as: eliminating the "locked by another user" error for good, unlimited users using the app, knowing who's using the mdb, seeing when they last opened the mdb, copying new code without having users close out, etc, etc...)

    I'm guessing that there is a login of some sort through the website. If so, the script should be able to grab the login name (or you can change it to grab the computername). If there's no login, you won't be able to use the script.
    Last edited by pkstormy; 08-22-09 at 03:05.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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