Modules

[rp]

I have two modules that would revert back to previously saved code. I thought I may not have saved the modules but it has already happened to the same module at least 4 times; it continues to go back to the first save, even though I haven't made changes to the module for quite a while.

It happened to a different module recently. The last thing I remember doing to the database is compacting it.

 

[Roni Sutton]

I have never had this happen, but I do know that Access has a bug in dbs that are replicatable. If you do not compace twice prior to distributing replicated copies, weird stuff happens to your queries down the road. They still run ok, but when you open them in design view, fields are missing from the tables that the queries are based upon which results in those columns in your querie being changed to expressions. I know that's not what's happening to you, but maybe your problem is also a bug. You could always try compacting twice and seeing what happens.

Roni