Corrupted Database?

[Guest]

Have a database that continues to error out with:

"You canceled a previous operation."

which make compact/repair and even decompile impossible...

Does anybody have any ideas on how to resolve this without pulling the
objects into a new database?

Thanks in advance for any light that you can shed on this situation. ~
SPARKER ~

 

[TC]

If you've run jetcomp.exe (on a copy please - not on the original!),
there's probably not much you can do, except to try importing it (which
you don't want to do, for some reason), or sending it to a data
recovery service.

Why don't you want to import it?

HTH,
TC

 

[Guest]

It is for a coworker that has this problem. I had him pull everything into a
new database this morning when I saw the state of that one. He did, but the
way this system is set up only the CIO can set the security permissions on
all of the objects within the database. Until he does that it is of no use to
anybody. He told my coworker that he did not have time to do it and that
mycoworker needs to try and find a way to uncorrupt the database he is
working with. So I told him I would make a post here in my favorite users
group hoping to get some sort of path to try in the morning so as to not eat
up my entire day trying to help this guy. So I will definately be trying your
recomendation in the morning as soon as I can locate this exe you speak of.
Thank you for taking the time to asnwer my post. Take Care & God Bless
P.S. if it works I will come back and rate you with a green circle / white
check mark! ~ SPARKER ~

 

[Jesper F]

It is for a coworker that has this problem. I had him pull everything into

a
new database this morning when I saw the state of that one. He did, but
the
way this system is set up only the CIO can set the security permissions on
all of the objects within the database. Until he does that it is of no use
to
anybody. He told my coworker that he did not have time to do it and that
mycoworker needs to try and find a way to uncorrupt the database he is
working with. So I told him I would make a post here in my favorite users
group hoping to get some sort of path to try in the morning so as to not
eat
up my entire day trying to help this guy. So I will definately be trying
your
recomendation in the morning as soon as I can locate this exe you speak
of.
Thank you for taking the time to asnwer my post. Take Care & God Bless
P.S. if it works I will come back and rate you with a green circle / white
check mark! ~ SPARKER ~

As you describe the database cannot be opened at all or can it?
Has your friend tried to simply compile the database?
It sounds like a dlookup-error, but if you're well into coding you've
checked that off course.


Jesper

 

[TC]

It wouldn't really be anything to do with dlookup IMHO.

The message that he quoted is a sign of possible corruption in the
database. And he said that he can't even compact or repair it, which
clearly supports that idea.

Cheers,
TC

 

[Michael J. Strickland]

Have a database that continues to error out with:

"You canceled a previous operation."

which make compact/repair and even decompile impossible...

Does anybody have any ideas on how to resolve this without pulling the
objects into a new database?

Thanks in advance for any light that you can shed on this situation. ~
SPARKER ~

If you can open the database, one thing I've found to help with corrupt
forms whose code can't be viewed or executed, is to import a known good form
from another database. Then:

1. Run the imported form and hit Ctl-Break to beak its execution.

2. In the window that comes up, Click on the debug button to view the code
for the good form.

3. Click on the Project Explorer button (or click View->Project Explorer) to
show all database forms in the left-hand pane.

4. Click on the corrupted form and re-compile it (and all forms in
database).

5. Close and Save the corrupted form. Close and Save the database.

Sometimes I've had to repeat this process a few times and/or re-boot first
but it has always worked.

--