Database won't compile

[dpedley]

I have a database which uses the ucase and mid functions. These functions won't run unless the db is compiled. When I open this db on any of three other machines it opens as compiled. When I open it on the pc it (of course) needs to be installed on. It opens uncompiled. Once you compile it and try to exit it gives the message (Save operation failed) Two questions 1) Why if this db is compiled successfully elsewhere is opening uncompiled on this pc; and 2) how can I get it to compile?

 

[dhookom]

Apparently you understand compiling your VBA. Did you check the references?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[JoeAtWork]

I don't think it's an issue of "it works when it's compiled". It should work whether you compile it or not (although it should work a little bit better if compiled).

As Dhookom suggests, it is probably a References problem which is stopping it (and probably causing it to be decompiled).