ACCESS FEED: RE: [MS_AccessPros] Query - Read only and Read/Write

Jumat, 17 Mei 2013

RE: [MS_AccessPros] Query - Read only and Read/Write

ZJubias-

When creating a query involving two tables, it is critical that there be a
link (JOIN) between a Unique key in one table to a related field in the
other. You normally create a link between a Primary Key in one table and
the related Foreign Key in the second. For example, when including
Customers and Orders in a query, you would link the CustomerID (Primary Key)
in Customers to the related CustomerID in Orders (Foreign Key) - the link
that tells you which customer owns each order.

You may have created such a link, but if you create a Totals query, that
will always be not updatable because a Totals query aggregates groups of
rows - there is no single row in the output that represents a single
underlying row.

There are several other things you can do to make a query not updatable, but
those are the two biggies.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ZJUbias
Sent: Thursday, May 16, 2013 11:35 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Query - Read only and Read/Write

Hello all,

Why is it that sometime I have a read only query and sometimes able to add
(read/write).

In cases I need to build a query from two tables as a record source of my
entry form, but in some cases it turns out that my query is read only.

Why is it that this things happens, I could not from my novice knowledge see
the reason.

Can someone please show me how to avoid and what should I consider when am
making such query(s).

Thank you, and please bear with me, just trying to learn the ins & out of
Access..

Thank you in advance for help,

Zjubias

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links