Results 1 to 4 of 4

Thread: Errors (2000)

  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Errors (2000)

    What do the following errors mean:
    Microsoft Access
    Could not update currently locked

    This one was in a query

    Chart Wizard
    You can't carry out this action at the present time.

    This one was received when trying to insert a chart into a report.

    Anyone ever get these errors?

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

    Re: Errors (2000)

    The first error indicates (probably) that two users (or processes) tried to update the same record at roughly the same time. If record-level locking is not used, it could also mean that two users (or processes) tried to update records on the same memory page. Waiting a bit, then retrying often solves the problem.

    The second one also points at some kind of conflict. Do you have exclusive access to the database when you try to insert a chart? Does the problem reoccur after compacting the database?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Errors (2000)

    The person creating/using this database is the only one using it. Since she is the only one using (or ever used) this database, is there something she is doing wrong that could cause these errors? Is there some setting she might change that would prevent these errors?

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

    Re: Errors (2000)

    If she is the only user, it could mean that the database is corrupted. She could try creating a blank new database and importing all database objects (tables, queries, forms, ...) from the problem database into the new one. She'll have to set the startup options in the new database, and if there is VBA code that uses non-standard references, the references will have to be set in the Visual Basic Editor.

Posting Permissions

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