Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts

    Problem loading switchboard

    Hi, My work PC was recently upgraded to Office 2013 - without Access. I still have Access 2007 on my computer, but since the upgrade any of my databases where I use the inbuilt switchboard are falling over and highlighting the following code in the debug window - Set con = Application.CurrentProject.Connection.

    Something in the upgrade seems to have reset the Access references even though Access was not included in the upgrade. How do I fix the references so that the Set con = Application.CurrentProject.Connection command is recognized?

    Regards,
    Maria
    Maria
    Simmo7
    Victoria, Australia

  2. #2
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts
    Quote Originally Posted by simmo7 View Post
    Hi, My work PC was recently upgraded to Office 2013 - without Access. I still have Access 2007 on my computer, but since the upgrade any of my databases where I use the inbuilt switchboard are falling over and highlighting the following code in the debug window - Set con = Application.CurrentProject.Connection.

    Something in the upgrade seems to have reset the Access references even though Access was not included in the upgrade. How do I fix the references so that the Set con = Application.CurrentProject.Connection command is recognized?

    Regards,
    Maria
    In the VB editor go into Tools, References and see if any are marked as MISSING. It sounds like the Microsoft ADO library or something similar may be missing or renamed.

  3. The Following User Says Thank You to jeremybarker For This Useful Post:

    simmo7 (2014-10-01)

Posting Permissions

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