MDE madness!

[TKnight]

Hi, I'm trying to make an MDE file from a database but I keep getting a message saying that Access can't create the file. I've password protected my VB, and don't think the DB qualifies for any of the restrictions outlined in the help file on MDE's but it still won't work.
I thought it may be because I have tables which reference another DB but that has been converted to an MDE too and when i deleted those tables to test it, it still wouldn't convert.... Does anyone have any pointers?
Thanks, Tom.

 

[Numpty]

I've had the same problem creating MDE files myself. I understand one reason for this may be redundant code within the database. For example a control which has been deleted but the event code for it is still sitting in the database.

Try going through all your code and deleting any of it which is no longer in use.

 

[TKnight]

thank you, will take me ages but needs to be done!

 

[Numpty]

Just a thought but you might want to just comment the code out rather than delete it .....just in case you delete something in error.

I know I'd do something like that

 

[intrep11]

run a debug

the problem is probably a bad reference to find the problem open the code window (on any page will do) then use the debug menu and the compile (it will have your db name after it)
this will run through all your code and highlight where the problem is

either delete or comment out the code and the problem will go away

keep running this until the compile option is greyed out and you should then be able to make the mde file as normal.
nd

 

[schumarg]

Hi,

You all have no idea how much these forums mean to me. I've been fighting creation of a db to an .mde that just wouldn't go. Ran the dubug and found four errors, code that was left over and doing nothing. Removed it and presto, an .mde file.

Your suggestions above did it.

THANK YOU!!

 

[alanj]

fast method to find obsolete code

open any of your modules, then click "Debug, Compile". Access will give you error messages and drop you into the offending code. If you have references to controls you deleted, you can click "view object" to look at the object and verify.

When you complete the compile, you will be able to create your MDE.