Uneditable Query

  • Thread starter Thread starter Karlos
  • Start date Start date
K

Karlos

I have a 3 tables which have realtionships.

When I create a query and use fields from all tables, I
cannot actually alter any of the data in the datasheet
view.

Any ideas whats stopping me from doing this?
 
You can edit data in a multi-table query only if Access can figure out the
relationships between the tables, and the the relationships all consist of a
unique key in one table (usually a Primary Key) related to a key in the
second table. Other things will cause a query to be not updatable - such as
calculating totals or asking for all the DISTINCT rows.

You'll have to post more information to get a more specific answer - such as
the SQL from your query.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Back
Top