Err Message: "'FormName' has been changed..."

[DaveTom]

Two of my users get the following message fairly frequently when they are in the main data entry/update form of my database, either upon closing or when trying to update information:<br><br>*******************<br>'frmFormName' has been changed since the last time you opened it, either by another user or because another instance of it was opened on your own machine.<br><br>Do you want to replace the changes that you or another user made?<br><br>To save your most recent changes and discard the other user's changes or your previous changes, click Yes.<br>To save this version of the object with another name, click No.<br>************<br><br>The users are definitely not changing the form (by going into design mode).<br><br>Does anyone know what might be causing this error?&nbsp;&nbsp;I can't duplicate it, but it happens frequently to people who use the database a lot.&nbsp;&nbsp;Is it something the users are doing?&nbsp;&nbsp;Something my VBA code is doing?&nbsp;&nbsp;Or a corruption of the database?<br><br>Any ideas would be helpful.&nbsp;&nbsp;Thanks.<br><br>

 

[DougP]

It's time you make a .MDE out of your database.<br><br>See my FAQ's on that topic<br><br><A HREF="

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=3382811&CFToken=85682352#91"

TARGET="_new">

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=3382811&CFToken=85682352#91</A><br><br><A

HREF="

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=3382811&CFToken=85682352#90"

TARGET="_new">

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=3382811&CFToken=85682352#90</A>

<p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[katiekat]

I have had similar problems. If you are working on the database, and someone else goes in to change something, no matter if its data or design, whoever leaves first gets that kind of message. It's weird. At least this is what I have been able to devine from these silly messages. The only way I am able to prevent it is to restrict write access to only the people that really need it. And even then......that's all I know. I hope it helps, I bet it won't but at least you got some kind of response!<br>