Results 1 to 5 of 5
  1. #1
    Glenn_Suggs is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    72

    Shift key doesn't bypass ODBC connection

    Hello everyone... I have run into a problem I have not seen before and I hope someone here can help me find a solution. I compile my application into an ACCDE file before I deploy it but I turn off the shift key functionality before I compile it. Then I turn it back on so I can get into it later and make changes. The shift key is not doing its job this time and one of the ODBC back-end tables is being accessed on startup and crashing the program before I can even look into the problem and make any changes that might be necessary. Does anyone know how I might get around this?

    Thanks in advance,
    Glenn

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    is this code running from AUTOEXEC macro?
    what runs it?

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    did you make changes with respect to linked tables? Perhaps the db is attempting to resolve a link in a new table and cannot for some reason. Methinks the table links will be resolved regardless of your shift key property setting, although whether or not a user has rights to a table won't be resolved until the user attempts anything that accesses it. That might be immediately if startup code is attempting access data to (for example, validate a user).

    Can you open the be by itself without any issues/warnings? If so, can you open all the linked tables in the be?
    If yes, then perhaps your attempt to alter the shift bypass property wasn't successful, or you actually forgot to do it.
    In those cases, you'd need to write code in a new db to set the property in the target db.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    Glenn_Suggs is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    72
    Quote Originally Posted by Micron View Post
    did you make changes with respect to linked tables? Perhaps the db is attempting to resolve a link in a new table and cannot for some reason. Methinks the table links will be resolved regardless of your shift key property setting, although whether or not a user has rights to a table won't be resolved until the user attempts anything that accesses it. That might be immediately if startup code is attempting access data to (for example, validate a user).

    Can you open the be by itself without any issues/warnings? If so, can you open all the linked tables in the be?
    If yes, then perhaps your attempt to alter the shift bypass property wasn't successful, or you actually forgot to do it.
    In those cases, you'd need to write code in a new db to set the property in the target db.
    Thanks Micron.... I think I’ve found a solution to the problem but I appreciate your quick response. Your reply has supplied me with information I think could very well be useful in the future. As it turns out, I was able to go to the Admin Tools section of Windows and change the login for the ODBC tables (DBA had changed it without informing anyone) before going into MS Access at all. Then I was able to open the database and make my modifications and once again... all is right with the world!!!
    Thanks again... Glenn

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You're welcome. When you deploy changes do you not keep a new fe copy with the bypass enabled to endure you can always recover? That and having a signal for you to know its state might be useful. The signal could be an opening form label colored differently.

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

Similar Threads

  1. Replies: 1
    Last Post: 06-25-2018, 04:15 PM
  2. Enabling shift bypass
    By reynier09 in forum Access
    Replies: 4
    Last Post: 08-18-2016, 08:25 PM
  3. Secuuring the SHIFT bypass function
    By awhittle23 in forum Security
    Replies: 1
    Last Post: 06-22-2016, 06:09 PM
  4. Replies: 3
    Last Post: 06-22-2016, 04:33 PM

Tags for this Thread

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