Queries Turned Read Only

[Guest]

Hi,

I've been making changes to a database we have which includes performance
based changes such as Name Track and Subsheet, I've also added a new table
and made several other changes.

I've now realised that all my previous editable queries have changed to Read
Only. What have I done that has caused this?

Many thanks

Ian

 

[Guest]

Hi,
most likely you have create non updatable queries. This can have many
reasons. Look it up in the access help:

1. Improper join
2. Aggregate functions
3. Multiple non-hierarchial 1-many relationships
4. Security
5. No primary key on a linked table.
All these things will result in a query which is non updatable. Most likely
it is a relationship issue.
HTH
Good luck