Results 1 to 6 of 6

Thread: Open Exclusive

  1. #1
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941

    Unanswered: Open Exclusive

    I have 2 shortcuts to databases on my desktop. Both open local versions of different front ends on my pc. One opens the front end exclusively every time open it. The other doesn't, so it's not very useful for development. I can't spot the difference between the two. Is there some flag I need to set in security?

    Mark
    Inspiration Through Fermentation

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I usually distribut the front end to the users

    Are your linked tables to sql server or access
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I would check the Properties of the shortcut itself. If you right click and go to the Shortcut tab, the Start In property will probably have a different command line.

    I f you search Access help for command line you will see the start-up command line options. One of them is an excl switch for opening a database exclusively.

  4. #4
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Well.... The /excl switch did the trick. But I don't have that switch in the one that was already working. "Help" said something about inheriting the way it was opened the last time, so I must've just gotten lucky when I set up the first shortcut.

    Thanks
    Inspiration Through Fermentation

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Oh for the love of....

    It's Access for heavens sake

    You expect predictable results?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    yeah, you've got a point there
    Inspiration Through Fermentation

Posting Permissions

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