Read only controls are driving me crazy!

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

Guest

Hi,

I created a form based on a query.
The form is NOT read only (i.e. enabled, not locked)
The controls are also enabled and not locked.
However, I can't type anything in that form. I'm not sure what I did that
caused the problem.
Since the form seems OK, I ran the query and tried to edit the query results.
The data there was also read only. However, I could not find anything in the
query properties that would make it's results read only.

Does anybody have any ideas? This seems to be the kind of things that byte
beginners in Access...

Thanks,

Salim
 
You have a non-updateable query. This is usually the result of using
Distinct, DistinctRow, or TOP N in a SELECT query, or from a UNION query, or
from a GROUP BY query, or from using aggregate functions in the query. This
can also be from a set of calculated columns in the SELECT query.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
The query had an inner join -- Apparently this was enough to make the
resulting data set read only.
It would seem that this should not be an issue (unlike the cases you
mentioned where there is no obvious way for access to locate the data)

Thank you for your quick answer.

Salim
 
An inner join between two tables isn't sufficient to always make a query
non-updateable. Are you able to edit at least one column in existing
records, but not add new records? This is a symptom of a partially
updateable query. If one joins two tables and uses the primary key from the
table on the one side of the relationship instead of the foreign key from the
table on the many side, then the query won't be able to add new records.

In other words, if you have a partially updateable query and change that one
field that appears in both tables to the field from the table on the many
side (just change the table name in the query grid to "the other table"),
then your query will become updateable.

Another possibility that may be affecting your query involves a table from
another database (or external data file). Are both of these tables in the
same database as your query and form?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Back
Top