Re: Jet engine stopped

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Try the queries again, while no other tables, queries, forms, or reports
are open.

If it still fails, go to:
http://support.microsoft.com/gp/sp
and check that you have the latest service packs for both:
- Office 2000
- JET 4.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Zimme" <Zimme@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:718350D5-BA04-4EE4-9B57-2795F02B8D3D@xxxxxxxxxxxxxxxx
Hello:

I have a few queries in Access 2000. Simple ones are like 1) get the Max
date and 2)the Min date.

The problem is: eg, as I ran the Max date query, a dialogue box came up
with
the info "The Microsoft jet database engine stopped the process because
you
and another user are attempting to change the same data at the same time."

The part I don't understand is:The queries worked before and I am the only
user. Also the mdb resides in the local drive. How would the jet engine
mistaken for more users.

Thank you in advance for your help and explanation. Best regards.


.

Relevant Pages

  • Re: query design appears to be overwritten - how, why?
    ... To correct it, make sure all other users are out of the database, and follow ... Compact the database to get rid of this junk: ... The queries draw ... I have saved, closed the query, opened it again and observed ...
    (microsoft.public.access.queries)
  • Re: Forms corrupting - so will create new FE - please tell me gotc
    ... You must create and maintain relationships in the database that contains the actual tables You cannot create a relationship with referential integrity between attached tables in the front end. ... When you create queries in the front end, it actually reads the relationships from the back end to decide how to join the tables. ... Compact, then decompile, then compact your existing database. ...
    (microsoft.public.access.formscoding)
  • Re: Split DB application and file sizes
    ... "Copy of DB_be.mdb" I see only the table, not the Queries or Forms. ... end after the database was split with the wizard. ... menu in the front end open, and it will reclaim the disk space that was once ... long as you relink the table and compact the database periodically. ...
    (comp.databases.ms-access)
  • Re: Allowing new records to be added into a query
    ... Access should have created a new table with details of the compact ... I mention this because the loss of a P.K. in a table could make a query ... I have a pretty large database, with queries containing two tables. ...
    (microsoft.public.access.queries)
  • Re: Split DB application and file sizes
    ... "Copy of DB_be.mdb" I see only the table, not the Queries or Forms. ... end after the database was split with the wizard. ... menu in the front end open, and it will reclaim the disk space that was once ... long as you relink the table and compact the database periodically. ...
    (comp.databases.ms-access)