I have a replicated Access95 database (4 replicas).
After synchronising, one replica now refuses to run citing a compile error
on the startup form. The startup form is a picture which detects MouseMove
and clicks to pop up home-made menus over word bitmaps. Any event trigger
causes the compile error box to appear. It also complains about silly
things like format() function etc.
This does not affect any other replica or the design master nor has it
happened on virtually any PC but has occured on a few.
I have an OPTION COMPARE DATABASE module level line in the startup module
with a Dim just BEFORE it. This I now know is an error but why doesn't this
trigger a syntax error on mine or most machines. I have Compiled All
Modules etc. and no error. I can't reproduce it.
BTW, I've just heard that fixing the above OPTION line and re-synching
has 'cured' the problem but I wait....
Any ideas (or confirmations) would be really appreciated. Please reply to
me direct and to the list (you know the story, client breathing down my
neck!),

Thanks,

You probably have one of two problems:
First Possible Problem:
You have a missing VBA reference.  Open any module in design view (even a
new one will do) and Click the Tools menu, then Click References.
If any reference that is check off says "missing", that's probably your
culprit.  It could be something that you need, in which case you need to
reinstall it.  Or it could be something you don't need, then just uncheck
it and click OK.  

Second Possible Problem:
Corrupt Database, repairing and compacting might work, but you'll probably
need to get a new copy from someplace else.

If you're replicating form/report/module design changes this behaviour
doesn't suprise me.  I used to replicated front-ends but don't really trust
it now.  Very often I would get a lot of strange errors on the first open
of the database after syncing which would go away on the second open.  It
doesn't seem to fully compile (even if you turn of compile on demand) even
though you see it 'compiling and saving' when you open the database.

Somebody suggested making the replica the Design master and then changing
it back again.  This is supposed to help it fully compile.  I've never
tested this.