OpenForm action was canceled

[tracktraining]

Hi ALL,

I am getting this error message: The expression On Click you entered as the
event property setting produced the following error: The OpenForm action was
canceled.

I only get it when i open my .mde using runtime 2007. But if i open the same
..mde using the full access 2003, then i don't get that error. I am not sure
what is going on.

Can anyone help?

thanks.

 

[Allen Browne]

If you have multiple versions of Access on 1 machine, and run under Windows
Vista, see:
Errors using multiple versions of Access under Vista
at:
http://allenbrowne.com/bug-17.html

If that's not the case, perhaps the A2007 machine is lacking a library
reference that the MDE uses.

 

[tracktraining]

how can i check if it is missing the library or not?

 

[tracktraining]

nm.. i see my problem.. thanks.
--
Learning

If you have multiple versions of Access on 1 machine, and run under Windows
Vista, see:
Errors using multiple versions of Access under Vista
at:
http://allenbrowne.com/bug-17.html

If that's not the case, perhaps the A2007 machine is lacking a library
reference that the MDE uses.

 

[Crossh]

Would you mind telling me how you fixed the problem? I have an access
database 2003 that works fine on Windows XP, but gets the same error you
described when running under VISTA. Thanks.

 

[Crossh]

FYI, I decompiled then compiled all Access 2003 databases in my Windows XP
machine and now everything works fine on the Vista machines.

 

[krets]

How did you solve this? I'm having the same issue and a tough time figuring
it out.

 

[Crossh]

I figured out that if I de-compiled then compiled the code, compacted &
repaired the database, on my machine (Windows XP), everything works fine for
both operating systems and both versions of Access. I do this everytime I
make a lot of changes, or whenever I think about it. Go figure. Gotta love MS.

 

[tracktraining]

sorry for the delay. But yes, i did the same as you Crossh - de-compiled then
compiled again.