How do I change a query to acept new data?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pierre - 04 Nov 2005 23:54 GMT

My query has stop acepting new data. The icon that allows me to enter new
data is grayed out, so I can not enter new data to the query.

Reply to this Message

fredg - 05 Nov 2005 00:56 GMT

> My query has stop acepting new data. The icon that allows me to enter new
> data is grayed out, so I can not enter new data to the query.

And .....?
1) Some query's are not updateable.
In Access Help look up Queries + Troubleshoot Queries + Select Queries
+ I can't update data from a query

2) Perhaps someone set the Query Recordset Type property to snapshot
(read only).

3) If you are opening the query from an event, perhaps it was set to
read only, i.e.
DoCmd.OpenQuery "QueryName", ,acReadOnly

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message