Question ACCDE version od database doesn't work as it should

[mcdhappy80]

This is the second database I've created in Access 2007 and now I have a problem when I compile it to .accde, it doesn't work. it's like there is no code, the button on my main form doesn't do anything.
The previous database I've created worked normal.
What should I do?
Thank You

 

[boblarson]

This is the second database I've created in Access 2007 and now I have a problem when I compile it to .accde, it doesn't work. it's like there is no code, the button on my main form doesn't do anything.
The previous database I've created worked normal.
What should I do?
Thank You

Is the ACCDE in a trusted location?

 

[mcdhappy80]

Is the ACCDE in a trusted location?

Of course.
I've noticed that all the .accde versions I've created on my current system does not work.
I have second system on other hdd (on which I switch to test something) and when I create .accde on it, that version works.
Also, when I try the .accde version I've created on my first system at my office, it doesn't work (I'm getting some kind of message that it is "created with older version of access" which cannot be true), but when I create .accde at work it works.
Could it be that my installed version of access (on the first machine), corrupted, or something?
.accdb version works normally.

Thank You

 

[boblarson]

Of course.
I've noticed that all the .accde versions I've created on my current system does not work.
I have second system on other hdd (on which I switch to test something) and when I create .accde on it, that version works.
Also, when I try the .accde version I've created on my first system at my office, it doesn't work (I'm getting some kind of message that it is "created with older version of access" which cannot be true), but when I create .accde at work it works.
Could it be that my installed version of access (on the first machine), corrupted, or something?
.accdb version works normally.

Thank You

When you say, first system and second system. What does that mean? Does it mean you have a completely separate Operating System installed and you shift into a test version?

 

[mcdhappy80]

When you say, first system and second system. What does that mean? Does it mean you have a completely separate Operating System installed and you shift into a test version?

It means that I have two HDDs, one is 640GB and one is 80GB.
On both HDDs is installed Windows XP SP2.
640GB HDD is my main system which I use for every daily work.
80GB HDD system is a system which I use to install and play games on, and sometimes test something, like installing a new program etc.

 

[boblarson]

Okay, you do know that you have to set a trusted location for BOTH Access installs? It is machine (OS) specific. So each of them needs to have the Trusted Location set, not just one.

 

[mcdhappy80]

Okay, you do know that you have to set a trusted location for BOTH Access installs? It is machine (OS) specific. So each of them needs to have the Trusted Location set, not just one.

On both machines the location where the database was is in trusted locations.

I solved the problem. The problem was that I needed to compile my code before making .accde. I don't know how could I oversee this.

Thanks.