Hi All,
I have a problem making changes to a query. The query is extracting
data from three different tables, but when I run the query in a form
or datasheet view I can't make any changes to the data. I can view the
data but not make changes.
Can anyone help? I would like to make changes to the data.
Thanks
John 4 1975
You appear to have created an unupdateable query. If the Help is not
sufficient explanation, Google the archives at http://groups.google.com.
Updateable and unupdateable queries have been discussed at length.
If the joins are not "ambiguous" to the software, and if you have included
the unique identifier(s) of each record you want to update, you will have
made a good start. Note that a corresponding field from one of the other
tables is _not_ "just as good".
Larry Linson
Microsoft Access MVP
"John" <jn**********@yahoo.com> wrote in message
news:b5**************************@posting.google.c om... Hi All, I have a problem making changes to a query. The query is extracting data from three different tables, but when I run the query in a form or datasheet view I can't make any changes to the data. I can view the data but not make changes.
Can anyone help? I would like to make changes to the data.
Thanks
John
John,
If you have any grouping or various other features in your query, the
recordset becomes non-editable.
If not, post your SQL and we can look at it for you.
Cheers,
Doug
--
Remove the blots from my address to reply
"John" <jn**********@yahoo.com> wrote in message
news:b5**************************@posting.google.c om... Hi All, I have a problem making changes to a query. The query is extracting data from three different tables, but when I run the query in a form or datasheet view I can't make any changes to the data. I can view the data but not make changes.
Can anyone help? I would like to make changes to the data.
Thanks
John jn**********@yahoo.com (John) wrote in message news:<b5**************************@posting.google. com>... Hi All, I have a problem making changes to a query. The query is extracting data from three different tables, but when I run the query in a form or datasheet view I can't make any changes to the data. I can view the data but not make changes.
Can anyone help? I would like to make changes to the data.
Thanks
John
One method to solve this problem is to join the tables only on Primary
Keys, if possible. When that happens, Access often seems to be able
to size up the situation and allow edits. If that doesn't solve it
try using some 'IN' SQL constructions in criteria fields instead of
the joins. Also, post the query SQL string you are using. You are
likely to get some specific useful recommendations from this NG that
way.
James A. Fortune
Hi All,
Thanks for your comments. I believe I have solved this issue by
selecting query properties, changing Recordset Type from Dynaset to
Dynaset (Inconsistent Updates). It seems to be working.
Are there any problems to use the query with Dynaset (Inconsistent
Updates)?
Regards
John ja******@oakland.edu (James Fortune) wrote in message news:<a6**************************@posting.google. com>... jn**********@yahoo.com (John) wrote in message news:<b5**************************@posting.google. com>... Hi All, I have a problem making changes to a query. The query is extracting data from three different tables, but when I run the query in a form or datasheet view I can't make any changes to the data. I can view the data but not make changes.
Can anyone help? I would like to make changes to the data.
Thanks
John
One method to solve this problem is to join the tables only on Primary Keys, if possible. When that happens, Access often seems to be able to size up the situation and allow edits. If that doesn't solve it try using some 'IN' SQL constructions in criteria fields instead of the joins. Also, post the query SQL string you are using. You are likely to get some specific useful recommendations from this NG that way.
James A. Fortune This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Sims |
last post by:
Hi,
I have a function to update some data, I run a set of 6 queries, ( all
updates and all on the same table).
I seem to run into problems where the data does not seem to be updated
properly or...
|
by: Nick Stansbury |
last post by:
Hi,
Sorry for the obscure title but I'm afraid I can't think of a better
way to describe what happened to one of my clerks last night. The guy was
working late, made a series of changes (accross a...
|
by: UDBDBA |
last post by:
All:
We are running UDB V8.2 FP8. We have sql query which uses DGTT. The
access plan for the query changes based on rows selected into DGTT.
1. Secnario I: DGTT has atlest 1 row.
I see INDEX...
|
by: strauss.sean |
last post by:
I have been asked to begin documenting the ongoing development and
changes to a database that I maintain. Not the entry of data; this is
about the changes to how tables are restructured, and any...
|
by: Colleyville Alan |
last post by:
I have some data in a table structured like this:
Date Cust_ID CUSIP Amount
01/31/2005 060208 02507M303 27,061.84...
|
by: Mark |
last post by:
Hello,
I have researched and tried every thing I have found on the web, in groups
and MS KB articles. Here is what I have.
I have a Windows 2000 Domain Controller all service packs and...
|
by: Ian Boyd |
last post by:
Every time during development we had to make table changes, we use Control
Center. Most of the time, Control Center fails. If you try to "undo all", it
doesn't, and you end up losing your identity...
|
by: Joe C. |
last post by:
hello all, thanks for reading.
i am trying to find a better way to keep track of changes in a ms sql
database table.
we have a ticketing system in the office, and a small app was written
to...
|
by: cori25 |
last post by:
I have data in a table for the entire month which breaks out by date, each day I am running the data and updating what currently exists for that day so any changes made will be captured. For example,...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |