Results 1 to 9 of 9
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095

    No "Open Exclusive" option shown to enable setting of password

    I have a 2007 formatted accdb that I want to set a password to use. The A2013 instructions state one has to "Open Exclusive" in order to set or otherwise effect an existing password. The option DOES NOT show.

    Is there something else required to use the encryption facilities in A2013?

    Bill

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    when you are in access: File, open , and the File explorer to choose the db to open,
    there is a down arrow on the OPEN button, to select Exclusive,

    is this down arrow not on the open button?

  3. #3
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    if you hold shift whilst opening the database and you are the only person. i think that will open exclusively. make sure you have read/write perms.

  4. #4
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    Shift key has no affect on any of the approaches to open.

  5. #5
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    Code:
    is this down arrow not on the open button?
    That's what's puzzling. There isn't any arrow on the OPEN button.

  6. #6
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Ranman's solution should work.
    If the Open button really doesn't have the dropdown with 4 options, try opening Access using the Run As Administrator option.
    You can do this from its desktop shortcut or from the Start menu.
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  7. #7
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    Code:
    try opening Access using the Run As Administrator option.
    Hi Colin,
    Opening A2013 as administrator from the Start Menu had no affect. The option drop-down arrow is still absent.

  8. #8
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Rather than do screengrabs of what you should see, have a look at this link
    https://www.teachucomp.com/set-a-pas...-instructions/

    It is also possible to open Access exclusively by using the /exclusive command switch after the program & file path
    Create a shortcut as follows

    "path to Access.exe" "path to your db" /exclusive

    If that doesn't help, suggest you run an Office repair.
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  9. #9
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    Okay, the instructions at "teachucomp" got me headed in the right direction. One has to use the drop-down on the file name pane to identify the DB file if one's computer is set for "Single Click", otherwise one DOES NOT get the opportunity to use the drop-down feature of the "OPEN" button. Needless to say, the instructions offered by ACCESS leaves a little bit to be desired in that they never identify "which" "OPEN" button they're talking about.

    Thanks Colin,
    Bill

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 02-28-2017, 12:29 PM
  2. Replies: 5
    Last Post: 12-04-2015, 10:19 AM
  3. Replies: 1
    Last Post: 09-03-2014, 03:27 AM
  4. Replies: 3
    Last Post: 08-21-2014, 08:32 AM
  5. Replies: 2
    Last Post: 01-15-2014, 07:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums