Results 1 to 8 of 8
  1. #1
    merlin777 is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Sep 2011
    Posts
    117

    opening a database for use


    This is going to sound really thick but my minds gone blank so i'm going to ask it anyway.

    How do you save the database you are working on so when the file is opened the db opens for use instead of development? Currently the filenames are .accdb and clicking on them opens in development with toolbars etc. What am I forgetting?

  2. #2
    JamesDeckert is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jul 2015
    Location
    Salina, KS
    Posts
    262
    if you want it to open in runtime mode you need to append the /runtime command line option, or I think you rename the extension to .accdr

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    I have never used accde or accdr.

    I hide navigation pane, disable ribbon, disable function keys, disable right click menu - with db Option settings and disable File tab and X close with customization code. https://www.accessforums.net/access/...ers-48543.html

    Be aware that holding down shift key when opening will bypass these options.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    There are options when you click the Office button top right of access, and choose access options. You can set the startup object for the database under the "Current Database" section.

    you can always employ the bypass shift key function to remove the shift bypass.

  5. #5
    merlin777 is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Sep 2011
    Posts
    117
    Quote Originally Posted by Perceptus View Post
    There are options when you click the Office button top right of access, and choose access options. You can set the startup object for the database under the "Current Database" section.

    you can always employ the bypass shift key function to remove the shift bypass.
    I looked there under access options/current database but I can't see a startup object option?

  6. #6
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    There is a "Display Form" which will load a certain form on load.

    or

    You can create a macro that fires off a module of vba code and such. name that macro autoexec.

  7. #7
    merlin777 is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Sep 2011
    Posts
    117
    Quote Originally Posted by JamesDeckert View Post
    if you want it to open in runtime mode you need to append the /runtime command line option, or I think you rename the extension to .accdr
    I tried renaming to .accdr but when i click on the file icon access opens then immediately closes again.

  8. #8
    JamesDeckert is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jul 2015
    Location
    Salina, KS
    Posts
    262
    Merlin,
    try running updates for Office. There was an update that had to do with the runtime for Office13.

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

Similar Threads

  1. Opening database
    By BatmanMR287 in forum Access
    Replies: 1
    Last Post: 03-13-2015, 05:48 PM
  2. Database not opening
    By jj1 in forum Access
    Replies: 6
    Last Post: 08-18-2014, 09:15 PM
  3. 2007 Database not opening
    By SmartestIdiot in forum Access
    Replies: 8
    Last Post: 01-14-2014, 12:29 PM
  4. Opening a database without toolbars
    By rowejd in forum Access
    Replies: 0
    Last Post: 03-02-2011, 01:32 PM
  5. Problems opening database
    By jdelvie in forum Programming
    Replies: 1
    Last Post: 09-20-2009, 10:11 AM

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