Access 2002 English vs. Access 2002 Hebrew - problem running code

[Guest]

I created an mdb in a Hebrew Access Version 2002. It runs perfectly fine.
This mdb does not have ANY hebrew data at all. Everything is in English.
However when attempting to run this database in an English Access Version
2002 environment the code can not run. It is not a specific code that it
wont run. It is any code will just not run. I tried it by opening multiple
forms. Any form that had code in it would just not work.
The code I used is basic simple code that I would use in an English
environment. There is no difference in the code.

Solutions I tried:

A- Recompiling the code
I tried compiling it again in English Environment and it compiles
successfully. However it can not run any code. It gets stuck immediately..
it's not a specific code that it wont run. It is any code. I tried it by
opening multiple forms. Any form that had code in it would just not work.

B- Creating a New Database and importing the objects
I tried creating a new database container - imported all the objects - set
the references - compiled it successfully.. then tried opening a from with
code and did not work!

Please let me know what else I can try. I greatly appreciate your
assistance. I can email a test database with one form and a line of code to
test what's going on. Thanks.

 

[Albert D.Kallal]

Your solutions you tried are exactly the ones that I would have suggested
(so,. you done some good testing).

Perhaps you could try creating a mde...does that work?

And, when you say the code does not work, does that mean you get a error
message?. Can you step through the code using the debugger?

Does any code work?

 

[Guest]

Thanks for your reply.

Creating an mde didn't solve the problem either. I was able to run it fine
on my Hebrew version but it didn't run on the English version.

When I said that the code doesn't run - I mean any code whatsoever doesn't
run. If I open a form that has onTimer event - as soon as the onTimer event
is triggered I get a message box "The expression On Timer you entered as the
event property setting produced the following error: A problem occurred
while Microsoft Office Access was comminicating with the OLE server or
ActiveX Control
The expression may not result in the name of macro, or user defined
function....

If I try to open a form that has module afterUpdate open form - it get's
stuck there... you can click debug and it will take you to the code.. However
the code is totally fine... There's just some weird reason why it can't run
it.

I had someone else test the database on English Access 2003 and they said it
ran perfectly fine. They had no problems. They just set the security
settings for Macros to Medium and all went well.
However 3 people tested it on English Access 2003 and they did have a
problem.. (Although I haven't told them to test it with the security settings
set to medium.. maybe that is the reason. I don't know?)


If you don't mind I could send you a test database.. with a simple form to
test..thanks

 

[Albert D.Kallal]

If you don't mind I could send you a test database.. with a simple form to
test..thanks

Hum, I don't have access 2002 installed. I do have a2003.

But, sure...zip it up..and send me the test form.....