Results 1 to 4 of 4
  1. #1
    birch.jc@pg.com
    Guest

    Error on Deleting records

    Access 2000 on Win98

    I'm new to Access and have created a table that I have populated from Excel with 22,000 records.

    I need to delete them all, before reimporting from Excel

    I selected "Edit | Select all records"
    and then "Delete"

    I get an error message saying "Could not update; currently locked."

    There is nobody else using this file and I do not have any other tables or queries open...

    Help!!!! What could I be doing wrong and how do I fix it?

  2. #2
    New Lounger
    Join Date
    Jan 2001
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error on Deleting records

    You could just delete the table completely and do the import again.

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error on Deleting records

    Just as an afterthought...You might consider a Delete Query also. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  4. #4
    birch.jc@pg.com
    Guest

    Re: Error on Deleting records

    Thank you

Posting Permissions

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