Results 1 to 4 of 4
  1. #1
    s23prite is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2013
    Posts
    2

    Switchboard is misspelled error after compact and repair.

    Using Access 2007 on Win 7 machine. The database has forms and reports. Access opens to the switch board but after running compact and repair, the forms and reports are removed. All that I read indicates that compact and repair only works on the tables. As a test, I split the database to a front-end and back-end. Running it on the front-end the forms and reports are removed. Some may say, "don't run it on the front-end" but the database is implemented as a packaged solution (with both the fe & be in the same file) and I have not seen this operation before.



    has anyone seen this error?

    any solutions to this?

    thanks.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Really strange. Try *importing* your db into a fresh new db and see if the issue follows.

  3. #3
    s23prite is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2013
    Posts
    2
    Thanks this suggestion worked. One thing I noticed during the import was an indication of an activeX component not being registered. Don't know if it was the culprit at this point, but will check it out later today and update this thread.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Excellent! Glad we could help.

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

Similar Threads

  1. Automating compact/Repair and backup of BE
    By togo in forum Programming
    Replies: 1
    Last Post: 12-27-2012, 03:29 PM
  2. Compact & Repair, Will I Run Into Problems?
    By robsworld78 in forum Access
    Replies: 1
    Last Post: 01-10-2012, 05:11 PM
  3. Compact and repair on close
    By colotazzman in forum Access
    Replies: 2
    Last Post: 05-20-2010, 02:04 PM
  4. Error 3167 Compact and Repair
    By jonsuns7 in forum Access
    Replies: 3
    Last Post: 10-27-2009, 08:19 AM
  5. MS-Access 2007 - Compact & Repair how?
    By techexpressinc in forum Access
    Replies: 2
    Last Post: 03-05-2009, 02:12 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