Unable to create MDE

[Guest]

I am using Access 2002 and started off creating a database in Access 2000
format. Later, I converted it to a 2002 format and when I want to create an
MDE file, I get an error:

Microsoft Access is unable to create an MDE database.

Any ideas what are the possible reasons for this and if there is any log
files somewhere I can look to get a clue? Thanks.
ck

 

[Douglas J. Steele]

Have you tried to compile the MDB (on the Debug menu when you're in the VB
Editor)?

That should highlight errors. Repeat until you've corrected them all, then
try your conversion again.

 

[Guest]

Thanks, Douglas. That did the trick.

Have you tried to compile the MDB (on the Debug menu when you're in the VB
Editor)?

That should highlight errors. Repeat until you've corrected them all, then
try your conversion again.

 

[Guest]

i'm getting the same error from my a2k mdb file when i try to create an mde
(for the 1st time, btw). so what's the operational definition of "compile the
MDB (on the Debug menu when you're in the VB Editor)?"

thanks for a little bandwidth.

-ted

 

[Douglas J. Steele]

Sorry, I don't understand your question. What is it you're looking for?

 

[Guest]

i want to assure myself there's only one 'Debug' 'button' from the menubar. I
always compile using this every time i add/modify some Event oriented vba
code i author and if this is true then this is not helping me.

-ted

 

[Douglas J. Steele]

Yes, there's only the one Compile option in the newer versions of Access.

For other possibilities as to why you can't create an MDE, take a look at
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

 

[Guest]

errr, i don't think any of those are problems of mine?