Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    31

    Unhappy Unanswered: how to write non updatable query in Access

    by default, when I run a query in Access, it opens the result in datasheet view.
    However, there one can modify data. How can I run a query so that user can only view data, not modify?

  2. #2
    Join Date
    Feb 2002
    Posts
    4

    Lightbulb

    sbasak.

    In code, use DoCmd.OpenQuery()
    among the options, you can choose the "read-only" argument.

    HTH,

    Ubiq

Posting Permissions

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