Results 1 to 2 of 2
  1. #1
    pmacafee is offline Novice
    Windows XP Access 2000
    Join Date
    Jul 2012
    Posts
    1

    Problem running Access 2000 database in Office 2007.


    I want to run an access 2000 database in Office 2007. When we run it in Access 2007, it changes all the VBA references to Access 2007 and Office 2007 dlls and my Access 2000 code won't run properly. I use some calls to Outlook 2000 in the programing and Outlook vba code changed from 2000 to 2003 and 2007.
    I have copied over all the dlls and replicated the paths on the Office 2003 and Office 2007 machines so that the references will work correctly.
    I can run it in Access 2003 just fine and the references to the dlls work OK, but not in Access 2007.
    When I look at the references in VBA on the 2007 machine they are all upgraded to Office 12 references.

    Access 2007 has the capability to set new databases to an Access 2000 format but not a way to open them in a specific fashion. I just want 2007 to not change the references to 2007 dlls.

  2. #2
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    I have no experience with this (yet!), but one thing you might try is to put the reference to the old Outlook 2000 dll back in (manually), and move it up in the list so that it is above the new version. Access will use the first reference it finds.

    Can't say for sure that this will work, but it's worth a shot.

    (PS - thanks for the heads up - I'll be going through the same process soon).

    John

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

Similar Threads

  1. Mixing Access 2000 with Office 2010
    By fiveoaks in forum Access
    Replies: 3
    Last Post: 10-20-2011, 09:59 AM
  2. Replies: 1
    Last Post: 08-02-2011, 06:49 AM
  3. Replies: 2
    Last Post: 06-18-2011, 09:55 AM
  4. Opening Database between 2007 and 2000
    By jo15765 in forum Access
    Replies: 19
    Last Post: 11-21-2010, 06:46 PM
  5. Access 2000 and 2007 VB code
    By gnuman in forum Access
    Replies: 0
    Last Post: 08-26-2009, 05:55 AM

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