Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Programmer access to MSAccess

11 Dec 2012   #1

Windows 7 64bit
 
 
Programmer access to MSAccess

Hello,
In Windows XP to gain programmers access to MSAcess you would
Shift+double-click. That doesn't work in Windows 7. Help? Thanks


My System SpecsSystem Spec
.

12 Dec 2012   #2

Windows 7 Home Premium 64bit
 
 

My System SpecsSystem Spec
12 Dec 2012   #3

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by rbassman98003 View Post
Hello,
In Windows XP to gain programmers access to MSAcess you would
Shift+double-click. That doesn't work in Windows 7. Help? Thanks
Shift+double-click does work on Windows 7 x64 home premium and all Windows 7 flavors.
My System SpecsSystem Spec
.


12 Dec 2012   #4

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by rbassman98003 View Post
Hello,
In Windows XP to gain programmers access to MSAcess you would
Shift+double-click. That doesn't work in Windows 7. Help? Thanks
What version of ms access? Shift+double-click just skips the startup code/startup form.
My System SpecsSystem Spec
12 Dec 2012   #5

Windows 7 64bit
 
 

Using Office 2010
My System SpecsSystem Spec
12 Dec 2012   #6

Windows 7 64bit
 
 

I have a laptop running Windows 7 Home Premium and a desktop running Windows
7 Ultimate and on neither machine does Shift+double-click do anything. No response at all whether it be an .mdb or an .accdb. I have databases that have
startup screens that I cannot get into the tables, queries, forms etc.
My System SpecsSystem Spec
13 Dec 2012   #7

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

It should work! Bypass startup options when you open a database - Access - Office.com
Did you set AllowBypassKey property to FALSE (it should be true)?

Tip: create a new database with a startup form or startup code and try to bypass it using SHIFT key. Works?
My System SpecsSystem Spec
13 Dec 2012   #8

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
 
 

  1. Create a new database
  2. Create a new module in that database
  3. Paste the code as displayed below in it.
  4. Change the red text with real database location you want to unlock
  5. Put cursor in SetBypassProperty subrountine
  6. Press F5 (means run)
  7. Does is say "AllowBypassKey value is now: TRUE"?
It fixed the issue?

Code:
Option Compare Database
Option Explicit
 
Public Sub SetBypassProperty()
Const DB_Boolean As Long = 1
    ChangeProperty "D:\Ron\Docs\test\ff.accdb", "AllowBypassKey", DB_Boolean, True
End Sub
 
Function ChangeProperty(DbName As String, strPropName As String, varPropType As Variant, varPropValue As Variant) As Integer
 
    Dim dbs As Object, prp As Variant
    Const conPropNotFoundError = 3270
 
    Set dbs = OpenDatabase(DbName)
    On Error GoTo Change_Err
    dbs.Properties(strPropName) = varPropValue
    ChangeProperty = True
    MsgBox "AllowBypassKey value is now: " & dbs.Properties(strPropName).Value
 
Change_Bye:
    Exit Function
 
Change_Err:
    If Err = conPropNotFoundError Then ' Property not found.
        Set prp = dbs.CreateProperty(strPropName, varPropType, varPropValue)
        dbs.Properties.Append prp
        Resume Next
    Else
        ' Unknown error.
        ChangeProperty = False
        Resume Change_Bye
    End If
End Function
My System SpecsSystem Spec
18 Dec 2012   #9

Windows 7 64bit
 
 
Found resolution

Just wanted to let you know I found the resolution to my issue today. Through trial and error, I found
that if you open Access, go to File\Open and select that,
locate the .mdb database you are wanting to modify, highlight it, hold the Shift key down and click on the Open button the database will open in "programmer mode" so you can modify it. I'm going to mark this as solved and I appreciate your help...
My System SpecsSystem Spec
Reply

 Programmer access to MSAccess




Thread Tools



Similar help and support threads for2: Programmer access to MSAccess
Thread Forum
Copied MSAccess DB "Loses" Data - There but not viewable. Why? Microsoft Office
Anyone a C# Programmer? Chillout Room
Need Outlook SQL/DASL Programmer Microsoft Office
Programmer slip-up produces critical bug, MS admits System Security

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 07:27 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33