Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Location
    Camp Lejeune, NC
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Search Key Not Found (A2K SR-1)

    For the third time in two weeks, I have had a record appear in my main table that is nothing but boxes in the fields. I can't delete it, so I learned to just make another table and copy that data to it without that record. Two questions, how do I keep this stupid thing from occuring in the first place and when I create the new table, even if I give it the same name, I have to reset permissions for it so everyone else can use it. Does that mean I am doing something wrong with the security?

    Thanks for you info and guidance.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Search Key Not Found (A2K SR-1)

    It seems that you are getting some database corruption. Have you tried compact/repair before trying to create a new table? My guess on security is that there is an internal ID that Access uses to keep track of objects, and your permissions are really granted based on this ID rather than the name (so if you change names, permissions should stay with new name). What you might do is don't rename the old table; create a new table, import everything from old table, delete all contents of old table (not table itself), then import all records into old table.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Search Key Not Found (A2K SR-1)

    Just be sure you don't have any cascading deletes turned on first or you'll have *real* problems to deal with. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    Charlotte

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Search Key Not Found (A2K SR-1)

    >>Just be sure you don't have any cascading deletes turned on first or you'll have *real* problems to deal with. <<

    OOh, good point!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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