How do I change a query to acept new data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split data in field on character return 0
date format conflict 5
How to have a user click okay/decline on a form to continue my cod 11
Multi query report 2
edit field data in query 1
Asp.Net and XML 3
Parameter Query Won't Run 0
Make table query: [Enter 1] AS Test 1

Back
Top