All my code has dissappeared!

[captain1974]

Access 2003.
I am guessing this is a bug, but all of my vba has dissappeared and all of the functions or events now produce a missing reference error message.
The function names are still in the left pane in the vba window, but I get 'Automation Error' if I try to view the code.

This happened after changing a form's list box option to multi-select>simple. (I have done this on other form's without any errors). I think it was coincidental that this happened after this change.

I created a replica of this database 2 weeks ago for someone else to use when I was on holiday. This is the first time I have come back to it (my master copy) since then, and I now wanted to synchronise the copies.
I have a backup copy that was made before the database was replicated, but obviously this won't syncronise with the replica copy.

Any ideas how to fix?

 

[dfenton]

Replication is not suitable for front end objects. First off, every Access app should be split into two files, the front end MDB (forms/reports/queries/etc.) and the back end (data tables only). Only the back end should ever be replicated. The reason for this is that Jet Replication was only designed and tested to work with pure Jet objects (tables and queries) and not with Access objects (the kind you have in your front end). The result of replicating front ends is that eventually, corruption develops in the Access project, which can lead to failure to synch, disapperance of properties and objects, and even complete loss of the Access project.

Why have you replicated the front end?

--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/