Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stopped process (97)

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

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Stopped process (97)

    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.
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stopped process (97)

    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

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stopped process (97)

    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

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stopped process (97)

    You

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stopped process (97)

    Hi Arage

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

    John

  7. #7
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stopped process (97)

    Hope someone can answer me b/c I

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stopped process (97)

    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •