Results 1 to 3 of 3
  1. #1
    vconner is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jun 2014
    Posts
    2

    Unhappy Adding buttons forces databases to open in design mode

    I am using Access 2013 to manage several Access databases - some as old as 7 years. These databases serve only as report generators for data gathered via ODBC from an Oracle database. All databases were recently updated to the latest version.



    Now that the update has been done, it appears that any new buttons added to the main menu form in any database causes the form (or at least the buttons) to open in design view. When subsequent people log in, they are greeted with the "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be bale to save them later" message. This happens whether or not anyone who previously logged in is doing any editing.

    The reason I suspect the buttons is that the message will appear as many times as there are new buttons. For example, yesterday I installed 3 new buttons on a form. When I returned to the database later that day after someone else had opened the database, I was greeted with the message three times and had to click "OK" as each error message appeared. After that, the database appeared to operate normally.

    I am looking for a way to go back and edit any current buttons to stop them from causing this behavior and a way to prevent the behavior from happening as new buttons are added.

  2. #2
    Z1nkstar's Avatar
    Z1nkstar is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    Location
    TX, USA
    Posts
    145
    Have you Checked the procedures of each button that you have placed?
    What are the buttons meant to do?

  3. #3
    vconner is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jun 2014
    Posts
    2
    Quote Originally Posted by Z1nkstar View Post
    Have you Checked the procedures of each button that you have placed?
    What are the buttons meant to do?
    The buttons only run queries, macros or reports. In the case of the incident yesterday, the new buttons only ran queries.

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

Similar Threads

  1. Replies: 5
    Last Post: 02-07-2014, 05:23 PM
  2. Can't open form in Design mode
    By GraeagleBill in forum Forms
    Replies: 4
    Last Post: 01-06-2013, 08:41 PM
  3. Disable Form Design Mode
    By EddieN1 in forum Security
    Replies: 1
    Last Post: 02-16-2012, 03:10 PM
  4. Replies: 2
    Last Post: 09-01-2011, 10:48 PM
  5. Replies: 4
    Last Post: 01-14-2011, 10:37 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