Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Delete Query Error (2000)

    I have a problem with executing delete queries. I join two tables or querys with one join run the query as a select query and then change the type to delete. I have been able to execute other delete queries using the same process, and I am getting the results I want in the select query...The error I keep getting is that it is a "read only" database error 3086. Any suggestions?? Thanks

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

    Re: Delete Query Error (2000)

    Well, do you have more than one copy of the database open? That can sometimes cause a read-only copy to be opened the second time. Try editing a record in each table to see if it lets you. Otherwise, usually setting the Unique Records property to true takes care of Delete query issues.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delete Query Error (2000)

    Charlotte, Thanks this did the trick. I am surprised it was this simple as I had two Access programers here at the College who could not figure it out! I was certain that it was a more complex problem

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

    Re: Delete Query Error (2000)

    Next time you encounter the problem, YOU can be the expert who knows how to solve it! <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> Psst! Out of curiousity, which one was it--multiple sessions of the database or needing the Unique Records property set (DISTINCTROW in the SQL)?
    Charlotte

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Delete Query Error (2000)

    Charlotte,
    Would you tell me why you need the Distinctrow set?
    I have had similar problems in the past with joined tabled delete queries.
    Pat

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

    Re: Delete Query Error (2000)

    There was a change in the query engine between Access 97 and Access 2000. The A97 engine assumed DISTINCTROW and the A2k engine doesn't. I tripped over that when I first started using A2k and discovered that A97 delete queries didn't work properly ... along with some other queries that I had to redesign. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Delete Query Error (2000)

    Thanks. From memory I have also had problems with update queries.

  8. #8
    New Lounger
    Join Date
    Mar 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delete Query Error (2000)

    Yes, I will be the expert, I am actually really enjoying Access and all it can do! The problem was the Unique Records property. I had thought of the problem of having multipule sessions. Thanks again.

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

    Re: Delete Query Error (2000)

    May be the same issue. I had the biggest problem with append queries with multiple tables in the query. In A97, you left out the PKs for tables that you didn't want records appended to but needed for filtering or to retrieve values or insert keys populated by referential integrity. In A2k, you have to include *all* the required fields for all the tables or it refuses to cooperate. It is very intelligent about not trying to add records to those tables, however, which A97 wasn't. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

Posting Permissions

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