Form not recognized

  • Thread starter Thread starter Norman
  • Start date Start date
N

Norman

I have a form that periodically will fail. By that I mean it simply isn't
recognized. It is there - in my list of forms in the object box, but can't
be opened to view or edit. I tried "analyzing" the form. While I can see
the icon, access simply ignores that it is there. I can import it from a
back up and replace the one not working, but it failed just prior to doing
the backup - so my back up is equally unrecognized.

Thoughts?
 
On Wed, 1 Jul 2009 04:43:01 -0700, Norman

You can try exporting it to a text file using the officially
undocumented but widely documented Application.SaveAsText. Then delete
the object, compact the db, and import it using .LoadFromText.

And keep more than one backup. A "grandfather - father - son" backup
rotation may be what you need.

-Tom.
Microsoft Access MVP
 
Norman,

It sounds as if your form is corrupt. FIRST, make a back-up of the
database. I would try creating a new form and then copying the controls on
the bad form over to the new one. Failing that, I would say you need to
recreate the form from scratch.

This is probably not the best time to say this but better late then never...
When I am developing, I make a copy before I go for the day (copy 1), then
every few hours or more frequently if it's 'heavy' development (copy 2 thru
whatever) and a final copy at the end of the day AND a back-up. Can't be
too careful!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top