MDE file

[Dragn73]

I have a data base that I am trying to deploy to multiple users. Everything seems to working correctly as i have had no issues of any kind. I split the database and am now trying to create an MDE file but it won't finish the task. Access hangs up forever. If I shut down access and open up what it started to create to create, I get an error saying the VB is corrupt.

I discovered that my database was under Access 2000 file format and it said i needed to convert it to Access 2002-2003 file format in order to create the MDE file which I have done, and now it won't create the MDE.

I thought it may have been becasue I split the database before I converted it. Would this be a possibility and if so, can I fix this?

I have tried the compact and repair and it doesn't help. I even went back to the 2000 version and tried to compact that one prior to converting it and nothing.

Any ideas?

Thanks
Dave

 

[Dreamweaver]

Have you got any Library Db's that are still MDB's As All Librarys used have to be MDE's

Hope it helps

mick

 

[Dragn73]

Not sure what you mean by that?

 

[boblarson]

Another question - Can you compile it? If you can't then that would be one reason why it won't work as it needs to compile.

 

[Ashfaque]

One of the possible reason...

Have a back up first and compile then before you go for MDE. Normally when we delete some unnecesory form/(s) from the db, we should first delete its code behind. In the same manner we should clear all the codes of command button that we are going to remove from any form. We think that once we delete the form or command button, everything goes away. But code especially for command button remains.

I prefer to have look at the Access version at client's end and match / convert accordingly.