Question

Asked on 2003-08-29 at 12:30:22ID: 27002288

    VB References

    by: Overthere125

    Rating9.0Excellent

    I have a problem that might be fairly simple to solve...

    I'm exporting some data from third-party software that creates an older version of an Access dbase, so when it opens, the first thing to happen is to convert it to my version of Access (2000).  After doing this I import a macro from another dbase and run it to crunch the data as needed.  However, the code included in my macro actually references a library not included in the new dbase.  I need to go into VB and add the Reference to Microsoft DAO 3.6 Object Library so the code will run.  Is there a way to add this reference on the fly or make the conversion add it?  Somehow I would like that automatically added into my new dbase.  The users of this dbase are not well versed in "how" to add this reference in, so automating it is the answer.

    Any suggestions are greatly appreciated!

    Related Solutions

    Solution

    Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

    About this Solution

    View This Solution - Start Your 30 Day Free Trial
    Zone
    general
    Tags
    access macro
    Participating Experts
    2
    Solution Grade
    A

    Replies

     by: jadedata

    Posted on 2003-08-29 at 12:31:27ID: 35586725

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: jadedata

    Posted on 2003-08-29 at 12:32:00ID: 35586726

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: 1William

    Posted on 2003-08-29 at 12:54:42ID: 35586727

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: Overthere

    Posted on 2003-08-29 at 12:55:51ID: 35586728

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: 1William

    Posted on 2003-08-29 at 12:58:38ID: 35586729

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: Overthere

    Posted on 2003-08-29 at 13:01:15ID: 35586730

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: jadedata

    Posted on 2003-08-29 at 13:05:57ID: 35586731

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: 1William

    Posted on 2003-08-29 at 13:08:10ID: 35586732

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: 1William

    Posted on 2003-08-29 at 13:09:55ID: 35586733

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

     by: Overthere

    Posted on 2003-09-02 at 12:23:16ID: 35586734

    All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

    Log In

    Forgot your password?Sign up

    Top Experts

    1. jimpen

      3,600

      0 points yesterday

      Profile
    2. boag2000

      2,000

      0 points yesterday

      Profile
    3. als

      1,360

      0 points yesterday

      Profile

    BrowseAre you an Expert?