Web Development

Ask something
Discussion Locked

Updatable Query Def

0 helpful
3 replies

by ideafixer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have created a query def for the purpose of setting up a form with the same criteria a report is generated from. I want to have the query updatable but for some reason when I create the query def, then go into the query tab and open the query, the data is not updatable. How do I make that data updatable?

3 replies

by timwalsh

I'm assuming you are using Access. Not all queries are updatable.

To determine if your particular query can be udated, go to Access Help and run a query on "updatable query" in Answer Wizard. You should see a topic listing for "When can I update data from a query?" This topic listing provides a list of the types of queries that can and can't be directly updated, and whether there are any alternative solutions.

NOTE: This is for Access 2000. I don't know if updatable queries were available in previous versions.

This discussion is closed to new replies.