Can't convert to mde

[Guest]

I have an DB that I want to convert to and mde. When I start converting it the system hangs. It manages to create a db1.mdb file. If I attempt to open that file I get a message that "The VBA in this project is corrupt" and then "File Not found" appears for every object or action. If I hit OK it will step through the code and create the form that should be diplayed on open, and populate the values.

I can complile the code in the mdb file without any problems. It also runs without any problems.

I tried converting it on two different computers, one running 2002 one running 2003. Both OSs and versions of office are up to date.

I tried converting a few other DBs and they work.

Any suggestions?

 

[Tom Wickerath]

Michael,

Try creating a brand new database, and then import all objects (tables, queries, forms, reports,
etc.) from the problematic DB into the new DB. I recommend importing objects one group at a time
(ie. all tables, then all queries, then all forms....). Set the references the same as the
source DB, compile the code, and then see if you can create a .MDE file.

Tom
____________________________________


I have an DB that I want to convert to and mde. When I start converting it the system hangs. It
manages to create a db1.mdb file. If I attempt to open that file I get a message that "The VBA
in this project is corrupt" and then "File Not found" appears for every object or action. If I
hit OK it will step through the code and create the form that should be diplayed on open, and
populate the values.

I can complile the code in the mdb file without any problems. It also runs without any problems.

I tried converting it on two different computers, one running 2002 one running 2003. Both OSs
and versions of office are up to date.

I tried converting a few other DBs and they work.

Any suggestions?

 

[Jack]

-----Original Message-----
Michael,

Try creating a brand new database, and then import all

objects (tables, queries, forms, reports,

etc.) from the problematic DB into the new DB. I

recommend importing objects one group at a time

(ie. all tables, then all queries, then all forms....).

Set the references the same as the

source DB, compile the code, and then see if you can create a .MDE file.

Tom
____________________________________


(e-mail address removed)...

I have an DB that I want to convert to and mde. When I

start converting it the system hangs. It

manages to create a db1.mdb file. If I attempt to open

that file I get a message that "The VBA

in this project is corrupt" and then "File Not found"

appears for every object or action. If I

hit OK it will step through the code and create the form

that should be diplayed on open, and

populate the values.

I can complile the code in the mdb file without any

problems. It also runs without any problems.

I tried converting it on two different computers, one

running 2002 one running 2003. Both OSs

and versions of office are up to date.

I tried converting a few other DBs and they work.

Any suggestions?

I'm having the same problem. I tried making a new db

and importing all the tables, etc, and the new db work's
great, except it still will not make an MDE file.

I also tried the fix suggested in the Microsoft Knowledge
Base article- 814858. It didn't work either.