Results 1 to 3 of 3

Thread: Open Access DB Tabels From Win XP

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 2003
    Posts
    51

    Open Access DB Tabels From Win XP

    hello
    Unable to open database with full access to tables through
    shift / enter function after Microsoft XP was installed.
    Database was created in Access 2000 with a main
    switchboard and limited menu & toolbar options. How can I
    access the database tables, form design to make changes
    and compress database?
    FiDz

  2. #2
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    Shift locked db --- do you mean xp office -- ie Access 2003 ?

    If so you need to convert the db up.

    If not, then someone wanted it locked for security reasons. Shift lock should still work, but this can be disabled to make sure you cannot use shift to stop it.

    There should be some posts in the forum (have a search - button at the top) with relevant vba coding to adding/set/unset the relevant property.


    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

  3. #3
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709
    You mean like when you select the db shortcut icon and hold down
    the shift key. Then double click it or press enter?

    If I remember correctly, its a hidden property that can be set to
    disable/enable the shift key at startup. Its called the
    AllowBypassKey property. I forgot where you set it, but thats the
    property you need to enable.

    HTH
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width