Unable to open switchboard, print report

Posted on 2009-02-24
Last Modified: 2013-11-28
I have probably corrupted database.  When I was open reports I was having messages error accessing files, network connection may have been lost.  I have read everything about this error on this and microsoft site regarding setting property "Has Module" of the report to "NO".
However, currently I have this error when I'm trying to open switchboard and this means that I simply cannot open database.
Setting property on every report and form is time consuming since I have too many reports and forms in one database.  Most of them have vba code on open event like "docmd.maximize"
I tried to reimport all objects to the new database.  It's not working.  Is there faster way then setting property "Has Module" to No on every form and report of the old database and then re-importing to the blank database
Question by:maximyshka
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    First, setting the HasModule property to No on each Form or Report will destroy any code you have and it will have to be re-written.
    Setting this property to NO is a *suggestion*, only in the worst of circumstances when you cannot open a form or report.
    You should always try Non-destructive ways of reparing you database first.

    1. Try running the "Compact/Repair"Utility
    2. Try a decompile:
    3. Delete the swichboard form and delete it from the Startup options.
    Create your own Form to open the various database objects.
    If you use the button wizard for this, you can perform all of the operations the switchboard manager was doing.

    Keep us posted.



    Author Comment

    Jeff, you are right, but I'm not allowed to use 3rd party software.
    I was trying to decompile it and it was useless.
    I was replacing switchboard from the backup. (Did not remove it from startup option though)  Switchboard on backup database is working fine, once I put it to the server - same thing.  

    BTW, how to open database window if I have problem with startup form (switchboard or anything like that)
    LVL 74

    Accepted Solution

    What third party software?
    The link is just a procedure.

    If you hold down the shift key untill the Database is fully open, then you will bypass all of the startup options.
    If you press the F11 key the Database window should open.

    Keep us posted.


    Author Comment

    Thanks, One Corrupted report was causing problem.  Took time to figure out.

    '* Prepare record for update
    Jeff, would you please tell me whether Access 2000 can recognize this line of Code.  I have complains during debugging
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    1. "would you please tell me whether Access 2000 can recognize this line of Code."
    As you know, you are only allowed one question per post.
    Is your original issue:
    "Unable to open switchboard, print report" resolved?

    2. Becase you have not posted the snippet in it's full context, or stated what errors you are recieving, it is hard to tell.

    3. Please close this question by accepting your own post. (http:#a23821521)

    4. Then post this new issue in a brand new question.



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now