Losing Changes to forms

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

Mark A. Sam

Hello,

This is a new one. Today I opened a form and noticed that I lost some
changes that I had made yesterday or the day before. I fixed them and moved
on. Then I was modifying code in event procedures and was pretty sure I had
saved the form, but the at some point while testing the old code was back in
the event procedure. So I made the changes and more, positive that I had
saved the form, in fact saving it as I went along insife the module, then
closing and reopening the form as seeing my chages were intact. Suddenly I
tested and the form was acting as he had before the changes. I opened the
module and the old code was there and I had to redo the code once again.

I don't know what else to say. Has anyone else noticed this type of
problem? I am using Access 2002 on Windows XP.

God Bless,

Mark A. Sam
 
Hi Mark

The symptoms you describe are a fairly common form of corruption. A repair
(Tools | Database Utilities) probably won't fix this, but a decompile often
will. To decompile, close Access, make a backup copy of your mdb, and then
enter something like this at the command prompt. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

As for how you can avoid it corrupting again, see:
Preventing Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-25.html
 
Thank you Allen. I haven't had the problem in the last day, but I had been
having problems with a subform corrupting. I solve it by creating a new DB
and importing the object into it. I will try the decompile.

God Bless,

Mark
 
Decompiling didn't help matters. I just opened a DB that I had changed this
morning and some objects were back the way they had been. But it seems as
though some other objects that I changed afterwards were maintined the
changes. I may be wrong, but I rather think that is the case.

Oh well. I guess I'll live with it (along with a myriad of other quirks ;)

God Bless,

Mark
 
Mark, you should not have to live with this.

Did you check that you have at least SP2 for Office XP, and SP8 for JET 4?

Did you turn off Name AutoCorrect, and then compact?

Those 2 items alone should make a difference, and there were others in the
article as well.
 
Hello Allen
Did you check that you have at least SP2 for Office XP, and SP8 for JET 4?
Click to expand...

SP3 for Office and Security Bulletin MS04-014 for Jet 4
Did you turn off Name AutoCorrect, and then compact?
Click to expand...

I did now
Those 2 items alone should make a difference, and there were others in the
article as well.
Click to expand...

We'll see. I don't see how this is a corruption issue. I really think that
Microsoft created a new electronic life form which is "evolving" and
imitating its creator ;) Thanks again.

God Bless,

Mark
 
Hi, Mark.

In addition to Allen's excellent advice, you may want to look at the KB
article: ACC2002: Silent Design Changes May Be Discarded in a Multiuser
Environment on this Web page, to determine whether it applies to your
situation:

http://support.microsoft.com/default.aspx?scid=285828

We've had "phantom" code execution issues in the past, but making sure that
the "Compile on Demand" option was not checked in the "Options" dialog
window has prevented this. For more info on this issue, see Tom Wickerath's
advice on using the VB Editor options:

http://www.access.qbuilt.com/html/gem_tips.html#VBEOptions

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
 
Thank you Camaro,

I will check those articles out when I get a chance. I'm not working in a
multiuser enviroment now, and "Compile on Demand" is checked on my system.
If this becomes a big issue, I will uncheck that. This hasn't caused any
problems yet, but it just curious that it could happen.

Talking about "Phantom" code execution, yesterday I was working remotely
(VPN) for a client, and the compile button clicked itself (as well as the
syntax checker executing before I left the line).

God Bless,

Mark
 
Only 1???? I think there is legion. So many goofy things are happening, I
won't even try to find answers. I believe Microsoft created a new life form
in MS Access, and a stupid one at that. ;)

God Bless,

Mark
 
Back
Top