cannot input or edit data in query

[Guest]

I have a query in which i would like to allow other users to input data. This
is a select query linking two tables by a common ID field. The query is not
allowing me either to modify existing data in it or to add new lines with new
data. I have checked the query properties but it does not pull up any
dialogue boxes concerning "allow edit". Any help would be appreciated.

Thank you,

 

[Roger Carlson]

When you join two tables in a query the join field MUST have a unique index
(or be the Primary Key) in one of the tables in order for the query to be
editable.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

I checked both of the tables for the primary key on the ID field. The "Main
Table" has the ID designated as the primary key. The records still, however,
cannot be edited. I built a quick select query from the two tables and the
new query will allow edits and the addition of new lines. I am not the
original creator of the database. If the query was built before the primary
key was added to the "Main Table" by the original author, would the original
query maintain these attributes and need to be re-created to adopt the
editing attributes?

Thank you,

 

[Roger Carlson]

No, you shouldn't have to re-create it. Once the unique index is created,
it should be editable.

However, there are other things that can cause a query to be non-editable.
If you have a DISTINCT predicate in the SQL (SELECT DISTINCT * FROM...),
that will also do it. This is the same as when the UniqueValues property is
set to Yes.

For more information on non-updateable queries type:
when can I update data in a query
in the Access Help Answer Wizard tab.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L