Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Convert 2000 to 2003 and Make .mde error

Posted on 2006-04-08
Medium Priority
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
  • 2
LVL 77

Accepted Solution

peter57r earned 500 total points
ID: 16410374
Hi OpieTaylor,
Make sure you mdb file compiles without error first.


Author Comment

ID: 16411780
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

ID: 16411812
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Implementing simple internal controls in the Microsoft Access application.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

577 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