Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Thanked 0 Times in 0 Posts

    Protecting Table Data from a Query Change (Access 2003)

    I'm pretty sure there are several ways to solve this problem but I'd appreciate the easiest. As most database managers know, it's best to split the database, placing the tables on their own, only accessible by forms (to delete, change or add data to the tables). What is the simplest way to prevent a change in a Query affecting the underlying Table(s) i.e. if data is deleted from a query, how can one prevent this deletion occurring in the associated table(s)? Thanks in advance for any info.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Protecting Table Data from a Query Change (Access 2003)

    That cannot be done. If a query is based on a table or tables, any change to the data in the query is a change to the data in the underlying table or tables.

    However, you can make a query "read-only" by setting its Recordset Type property to Snapshot. (Open the query in design view and click in an empty part of the upper half of the query. Then activate the Properties window.) It won't be possible to edit, add or delete records using the query.

Posting Permissions

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