Results 1 to 6 of 6

Thread: Startup problem

  1. #1
    Join Date
    Sep 2006
    Posts
    26

    Unanswered: Startup problem

    I was making changes to a MS access database I inherited from someone.

    The database had a startup macro that hid menu items and the database window. To access the underlying object, I could go to Window/Unhide.

    I messed something up, now when I launch the database, I get an error that says "The command or action 'WindowHide' isn't available now". Now I can't get at the database window to make changes. If I try to launch while holding the shift key, that doesn't work.

    Is there anyway I can bypass the AutoExec macro that is hiding everything?

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Can you get to Tools > Startup... ?
    Me.Geek = True

  3. #3
    Join Date
    Sep 2006
    Posts
    26
    no, all I get are two menu options
    Reports -- which I can use to run a selection of reports
    Window -- where all commands are grayed out

    Also I can run help, and minimize/maximize/close the window.

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Holding down the shift key does bypass the autoexec and startup unless the shift key has been disabled in code in the database (which it sounds like is the problem). You can try opening a fresh mdb and importing the tables, queries, forms, macros and reports, modules. You can also try opening it with the /decompile parameter (see Microsoft help for more info on this.)

    I try not to disable the shift key in an mdb as this causes problems such as this. There might be some other tools which could help but disabling the shift key in code can have nasty consequences for a developer.
    Last edited by pkstormy; 06-14-07 at 17:28.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Maybe this will help...(big MAYBE)
    http://www.softsland.com/property_ed...ft_access.html
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  6. #6
    Join Date
    Sep 2006
    Posts
    26

    Thanks!

    Worked beautifully! I am back in business. Thanks so much.

Posting Permissions

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