Convert 2000 to 2003 and Make .mde error

Posted on 2006-04-08
Last Modified: 2013-12-05
Hi All,

I need to convert a couple of databases from 2000 format to 2003 format. I seem to be able to convert them okay but when I try to make a .mde out of them I receive an error message and no .mde is created.

There are no add ins or linked tables and I haven't set any securtiy yet.

I've tried converting and importing all objects from 2000 to 2003 but neither approach works.

Can anyone tell me how to make this work?

Thank you,

Question by:OpieTaylor
    LVL 77

    Accepted Solution

    Hi OpieTaylor,
    Make sure you mdb file compiles without error first.


    Author Comment

    Thanks Pete.

    I had an IsOpen() function that wasn't recognized. I commented it out and it compiled without error. Then I was able to create a .mde.

    Now I need to find out why IsOpen() worked in 2000 but not 2003 and fix it.

    Thanks again Pete for helping me find the solution and adding another knowledge token to my repritoir...

    Ryan (Opie)
    LVL 77

    Expert Comment

    Well Isopen() is not a built -in function in Access so either it is in a different refence library or else it is your own function in a module.



    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now