Thanks for help.
I've tried decompile, it didn't help yet, even it did
something.
Need to try something else, probably I need to read
instractions more carefully.
About criating new db, I've tried before, and import all
tables, queries and forms - nothing help, even another
problem came out too
Thanks,
Mark
-----Original Message-----
Hi Mark,
Sounds like one of the ugly manifestations of a corrupt
db. To fix this you
can either create a new mdb and import all objects into
the new mdb or ou
can use the undocumented decompile. Personally I find
decompile to be an
easier method of recovering from corruption - just be
sure to follow the
precautions listed in the articles sited below.
Here are a couple of links on decompile. They are
written for Access97 but
the same method works for Access2000. Be sure to make a
copy of your mdb
before you decompile. I've never had any trouble
but . . . backups are
always a good thing anyway.
http://www.mvps.org/access/bugs/bugs0008.htm
http://www.trigeminal.com/usenet/usenet004.asp
Also check Tony Toews' page on corruption -
http://www.granite.ab.ca/access/corruptmdbs.htm.
Good luck!
--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to
this newsgroup.
Mark Remesnitskiy wrote:
Hi everyone,
I have form with subform, and it was working well to
some
point of time, but than when I enter new record in form
and go to subform, or tried to close form, whole
program
shuts down, come up error dialog box with choice to
report to Microsoft, than make backup file, compress
and
repair database.
After opening database again, it is navigating around
form and subform without any problem.
Each new record - everything comes again.
I tried to delete some records, created new database
and
import tables, queries and forms from previous - one
nothing helped
I'm runing Access 2002 on Windows 2000 and XP, on both
some results.
Is anybody have any idia what is going on, and how to
solve this problem
Thanks,
Mark
.