Results 1 to 3 of 3

Thread: Upgrade to 2007

  1. #1
    Join Date
    Mar 2009
    Posts
    120

    Unanswered: Upgrade to 2007

    Recently my Office package was upgraded to 2007. I have several databases that where created in Access 2003.

    The trouble I am having is that I have several Macro's built to export various reports and queries into Excel, but they don't work now.

    In the Macro there is no option to export to Excel and if I try to Right click on an object and export it that way the Excel option is greyed out.

    Is there some setting I am missing to allow this or must I rebuild my DB's in 2007 to allow this function??

    Help!

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Have you set the folder your file resides in as "Trusted?"

    Here's a link to Allen Browne's paper on converting to 2007/2010:

    Microsoft Access tips: Converting to Access 2007

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Mar 2009
    Posts
    120
    Thanks. I've added the Trusted Location, but according to the artical you posted the link to. The Export option to Excel was removed, but it also stated that it was fixed in SP2. I have a call into our IT about that to see if we can get SP2 installed.

Posting Permissions

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