Coffeehouse Thread

3 posts

MSAccess Denied

Back to Forum: Coffeehouse
  • User profile image
    OnlyJack

    Hi guys! Today while I was tinkering with msaccess 2007 I discovered a very strange behavior: when show a form in datasheet mode and I right-click the record selector (the little gray square to the left of each record) the button to delete the record is disabled however if I select the record and press DEL button I'm able to correctly delete the record. What's going on?

  • User profile image
    joechung

    Perhaps the datasheet view was in readonly mode?

  • User profile image
    OnlyJack

    joechung said:

    Perhaps the datasheet view was in readonly mode?

    It wasn't read-only because I could edit all records, delete was working fine when selecting the record and using the DEL key and also when you open a database in read-only mode you usually get a warning. After a quick chat with office support they confirmed it was a bug (with no patches in sight) and that the easiest workaround was disabling layout view. It's really strange that they still didn't notice and fix this bug earlier, considering that most access demo projects make heavy use of those datasheet views. What a disappointment!

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.