Stopped process (97)

Topic

New Reply

Stopped process
My system users (and myself) get error messages from time to time that

Reply | Quote

Replies

How often is this happening? Can you reliably recreate it or are there circumstance under which it *never* happens? I have seen this kind of message when both a form and subform were bound to the same datasource.

Reply | Quote

Well, yesterday for one of my users, it was occurring in one form (no subform) & I got her to restart her computer & then the error started popping up in another of her forms (no subform) This problem happens intermittently, even to me but it is rare & when it does happen, there usually isn

Reply | Quote

Hi Arage

This is a nasty one.

Do a Wody’s search on “The Microsoft jet database engine stopped the process”

You will get a laundry list of other users experience and some good suggestions.

Let us know what your resolution was.

HTH

John

Reply | Quote

You

Reply | Quote

Hi Arage

I’m over my head here, maybe another lounger can jump in.

John

Reply | Quote

Hope someone can answer me b/c I

Reply | Quote

If the table has a unique ID field, you can use that to write a delete query and an append query.

If the values are contiguous, you’re in luck. Use a Where-condition

WHERE UniqueID Between LoVal And HiVal

Otherwise, you’ll have to write down the offending ID’s and use

WHERE UniqueID In (Val1, Val2, …, Val35)

The SQL of the delete query would be

DELETE FROM tblMyTable WHERE … (see above)

and of the append query

INSERT INTO tblMyTable SELECT * FROM tblBackup WHERE … (see above)

Reply | Quote