Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Desktop shortcut to open DB in Exclusive Mode (ACCESS 2007)

    Is there a "switch" that you can put on a target path that will open a 2007 db in exclusive mode only so don't run into any error messages if in design mode that you don't have exclusive use of the database.
    Thanks
    Jerome

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Desktop shortcut to open DB in Exclusive Mode (ACCESS 2007)

    You can use the /excl switch in the shortcut.
    Richard

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: Desktop shortcut to open DB in Exclusive Mode (ACCESS 2007)

    great thanks, any way of checking / verifying that the file is indeed open that it is in exclusive mode??? other than erroring out if it is not in exclusive mode
    Jerome

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Desktop shortcut to open DB in Exclusive Mode (ACCESS 2007)

    Can you explain the setup you are using that leads you to ask this question?

    The ideal setup for a database that you share with others is that:

    <UL><LI>The database be spit into a Front End (containing all the Queries,forms,Reports, Macros and Modules), and a Backend containing just the tables. see WendellB's tutorial Why split a Database
    <LI>Each user has their own copy of the Front End on their local hard disk, with a master copy on the server. The Backend is on the server[/list]This setup removes the issue of Exclusive use (unless you need to make design changes to the tables) because you work with your own copy of the Front End. This also means you can test your changes properly, then distribute them to others by updating the master copy of the FE on the server.
    Regards
    John



Posting Permissions

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