Results 1 to 6 of 6

Thread: Access 97 to Access 2000 conversion

  1. #1
    Join Date
    Dec 2008
    Posts
    27

    Access 97 to Access 2000 conversion

    Hi
    I created databases with Access 97 ... Now that I have Access 2000, I converted a bdd in this version. The conversion is going well, but when an opening the following message appears that keeps me from going further: "Left undefined function in"
    What's that? what i have to do?
    Thank you in advance

  2. #2
    Join Date
    Nov 2008
    Posts
    38

    Re: Access 97 to Access 2000 conversion

    Hello,

    It is certainly a problem of reference.
    Go to the VBA editor (Alt + F11), Tools menu ==> References.
    If possible, starting in version 97 to see which are checked.
    Then in 2000, see if some are marked missing.
    Reorder the references to the project in the correct version (eg Microsoft 9.0 Object Library), and references simply uncheck "exotic" which would have added to the project.

  3. #3
    Join Date
    Oct 2008
    Posts
    336

    Re: Access 97 to Access 2000 conversion


  4. #4
    Join Date
    Dec 2008
    Posts
    27

    Re: Access 97 to Access 2000 conversion

    Hi

    Thank you for this advice ..... but I can not apply them, I can not open the VBA Editor. I tried many times my bdd Access 97 open Alt + F11 nothing happens. I must make a wrong ..... HELP!

  5. #5
    Join Date
    Nov 2008
    Posts
    38

    Re: Access 97 to Access 2000 conversion

    Hello,

    May be trying to select a module and click edit, this should allow you to display the editor.

    Otherwise, after you convert your basic 2000 version, can you go to the publisher?

  6. #6
    Join Date
    Dec 2008
    Posts
    27

    Re: Access 97 to Access 2000 conversion

    Thank you for your answers, they have been successful because it has solved my problem. The concern was well within the VBA editor, a reference has evolved between A97 and A2000: "MS DAO 3.5 Object Library" is missing because it has become "MS DAO 3.6 Object Library"
    Thank you again

Similar Threads

  1. Replies: 1
    Last Post: 31-12-2011, 02:29 PM
  2. access 2000 mdb changes when copied in windows 7
    By sdemmet in forum Windows Software
    Replies: 3
    Last Post: 13-01-2010, 08:28 AM
  3. Migrating access 2000 - 2007
    By GlassFish in forum Windows Software
    Replies: 4
    Last Post: 22-12-2009, 10:34 AM
  4. MS Access 2000 crashes
    By Beter 2 Burn Out in forum Windows Software
    Replies: 3
    Last Post: 10-09-2009, 12:19 PM
  5. Date() function problem in Access 2000.
    By Jerzy in forum Software Development
    Replies: 3
    Last Post: 30-07-2008, 03:44 PM

Posting Permissions

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