Converting accdb to accde VBA code is not working

[wassimdaccache]

Dear friends

I am working on access 2007 sp2.

I do have a database(accdb) i converted it to accde.

While I am opening the converted database the VBA code is not working.

For example

docmd.maximize

on each form is not working and forms won't maximize

Is it a bug on my office or I am doing something wrong...


Could you please point me to the write direction


Thank you all

[missinglinq]

Are you running the accde file from the same folder as the original accdb was run from, or from somewhere else? Does other code run?

Remember that in order for code to run in Access 2007, the file has to be in a folder that has been set as "Trusted."

Linq ;0)>

[wassimdaccache]

Yeah I am running my accde file in the same folder root.

also I added a trusted location and I enabled all macros.

Nothing on the code is working (VBA) Macros are working well.

P.S all code is working well before the accde conversion

[mrrcomp]

HI Wassim,


I am having the same problem. Did you ever figure out how to solve it?

Regards
Meir R.

[wassimdaccache]

No didn t get any solutions yet ...

[mshmyob]

Before converting it into an accde format you should test ALL your code by "compiling" it. Everything may appear to work in the accdb version but when converted won't work if there are some problems.

To "compile" it you open your accdb version and go into any of the code. Then select the DEBUG menu option and select COMPILE (1st option). If you get any errors then fix them and the compile again just to double check. Then try creating your accde again.

Try this and let us know.

cheers,

[mrrcomp]

HI

I was just going to post the solution of "Compiling" the code before the converting to ACCDE. In Access 2003 and earlier version the conversion automatically did a "Compile" seems that 2007 doesn't. So even if there are no problems with the code you still need to "officially" compile it.

Thanks

Regards

Meir

[TheSmileyCoder]

You also need to compile it in Access 2003. At least that has been my experience.

[Nizar Yussef]

Hi ev one
I got the same problem with Access 2010

I did the Compiling and it worked just fine.

It seems to b that also in Access 2010 you must Compile before covert to ACCDE file.

tnx to u all
Nizar

[informerFR]

Hi Mshmyob

Thanks a lot for this information. You make my day and now it works perfectly

[NeoPa]

Actually that solution was first posted by Mshmyob in post #6. Nizar simply posted, like yourself, to thank the earlier posters for their assistance.

Glad that you got the help you needed anyway :-)

[informerFR]

I changed my post and you're right, Giving credit where credit is due

one must give to Caesar what is Caesar's'.