|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 30th, 2010, 11:02 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Dynaset, inconsistent updates
Hello. I've recently upgraded to Office 2007...
Prior versions of Access allowed the user to update tables (via update queries utilizing another query) without getting the dreaded "not updateable" error. You would accomplish this by changing your query property settings to "dynaset/allow inconsisent updates". Queries in Access 2007 don't allow for this, correct? Or am I missing something? Is the only alternative to create numerous temp tables, and then use those temp tables in your queries as joins? Thanks. -- Craig 
|
|
#2
March 31st, 2010, 02:57 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Dynaset, inconsistent updates
Craig,
It's still there... are you looking at the Query Properties or the Field Properties (won't find it there)? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Hello. I've recently upgraded to Office 2007... Prior versions of Access allowed the user to update tables (via update queries utilizing another query) without getting the dreaded "not updateable" error. You would accomplish this by changing your query property settings to "dynaset/allow inconsisent updates". Queries in Access 2007 don't allow for this, correct? Or am I missing something? Is the only alternative to create numerous temp tables, and then use those temp tables in your queries as joins? Thanks. -- Craig
|
|
#3
March 31st, 2010, 05:27 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Dynaset, inconsistent updates
Gina...
Thanks for the reply. No, I do not see it. When I open a 2003 Access query and right-click the query properties I get a dialog box with a "general" tab that includes several options, including "recordset type" that you can toggle to "dynaset", etc. I don't see that in Access 2007 queries. When I right-click in the query I get a dialog box with the "general" tab, but only 2 options ("source" and "alias"). Do I need a service pack, or is there something else I'm missing? Thanks. -- Craig "Gina Whipp" wrote: Craig, It's still there... are you looking at the Query Properties or the Field Properties (won't find it there)? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Hello. I've recently upgraded to Office 2007... Prior versions of Access allowed the user to update tables (via update queries utilizing another query) without getting the dreaded "not updateable" error. You would accomplish this by changing your query property settings to "dynaset/allow inconsisent updates". Queries in Access 2007 don't allow for this, correct? Or am I missing something? Is the only alternative to create numerous temp tables, and then use those temp tables in your queries as joins? Thanks. -- Craig
|
|
#4
March 31st, 2010, 05:48 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Dynaset, inconsistent updates
Craig,
Does it say... Property Sheet Selection Type: Query Properties General ....what kind of query is it? AND are you in Design Mode for the query? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Thanks for the reply. No, I do not see it. When I open a 2003 Access query and right-click the query properties I get a dialog box with a "general" tab that includes several options, including "recordset type" that you can toggle to "dynaset", etc. I don't see that in Access 2007 queries. When I right-click in the query I get a dialog box with the "general" tab, but only 2 options ("source" and "alias"). Do I need a service pack, or is there something else I'm missing? Thanks. -- Craig "Gina Whipp" wrote: Craig, It's still there... are you looking at the Query Properties or the Field Properties (won't find it there)? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Hello. I've recently upgraded to Office 2007... Prior versions of Access allowed the user to update tables (via update queries utilizing another query) without getting the dreaded "not updateable" error. You would accomplish this by changing your query property settings to "dynaset/allow inconsisent updates". Queries in Access 2007 don't allow for this, correct? Or am I missing something? Is the only alternative to create numerous temp tables, and then use those temp tables in your queries as joins? Thanks. -- Craig
|
|
#5
March 31st, 2010, 07:06 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Dynaset, inconsistent updates
Gina...
Yes, I'm in design mode for the query. But the selection type says "field list properties", not "query properties". -- Craig "Gina Whipp" wrote: Craig, Does it say... Property Sheet Selection Type: Query Properties General ...what kind of query is it? AND are you in Design Mode for the query? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Thanks for the reply. No, I do not see it. When I open a 2003 Access query and right-click the query properties I get a dialog box with a "general" tab that includes several options, including "recordset type" that you can toggle to "dynaset", etc. I don't see that in Access 2007 queries. When I right-click in the query I get a dialog box with the "general" tab, but only 2 options ("source" and "alias"). Do I need a service pack, or is there something else I'm missing? Thanks. -- Craig "Gina Whipp" wrote: Craig, It's still there... are you looking at the Query Properties or the Field Properties (won't find it there)? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Hello. I've recently upgraded to Office 2007... Prior versions of Access allowed the user to update tables (via update queries utilizing another query) without getting the dreaded "not updateable" error. You would accomplish this by changing your query property settings to "dynaset/allow inconsisent updates". Queries in Access 2007 don't allow for this, correct? Or am I missing something? Is the only alternative to create numerous temp tables, and then use those temp tables in your queries as joins? Thanks. -- Craig
|
|
#6
March 31st, 2010, 07:57 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Dynaset, inconsistent updates
Craig,
Click in the area where the tables are... not on a table while the Properties window is open. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Yes, I'm in design mode for the query. But the selection type says "field list properties", not "query properties". -- Craig "Gina Whipp" wrote: Craig, Does it say... Property Sheet Selection Type: Query Properties General ...what kind of query is it? AND are you in Design Mode for the query? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Thanks for the reply. No, I do not see it. When I open a 2003 Access query and right-click the query properties I get a dialog box with a "general" tab that includes several options, including "recordset type" that you can toggle to "dynaset", etc. I don't see that in Access 2007 queries. When I right-click in the query I get a dialog box with the "general" tab, but only 2 options ("source" and "alias"). Do I need a service pack, or is there something else I'm missing? Thanks. -- Craig "Gina Whipp" wrote: Craig, It's still there... are you looking at the Query Properties or the Field Properties (won't find it there)? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Hello. I've recently upgraded to Office 2007... Prior versions of Access allowed the user to update tables (via update queries utilizing another query) without getting the dreaded "not updateable" error. You would accomplish this by changing your query property settings to "dynaset/allow inconsisent updates". Queries in Access 2007 don't allow for this, correct? Or am I missing something? Is the only alternative to create numerous temp tables, and then use those temp tables in your queries as joins? Thanks. -- Craig
|
|
#7
March 31st, 2010, 09:04 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Dynaset, inconsistent updates
OK, now I see the query properties...but still, there is no "recordset type"
like in 2003...unless I'm missing something... -- Craig "Gina Whipp" wrote: Craig, Click in the area where the tables are... not on a table while the Properties window is open. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Yes, I'm in design mode for the query. But the selection type says "field list properties", not "query properties". -- Craig "Gina Whipp" wrote: Craig, Does it say... Property Sheet Selection Type: Query Properties General ...what kind of query is it? AND are you in Design Mode for the query? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Thanks for the reply. No, I do not see it. When I open a 2003 Access query and right-click the query properties I get a dialog box with a "general" tab that includes several options, including "recordset type" that you can toggle to "dynaset", etc. I don't see that in Access 2007 queries. When I right-click in the query I get a dialog box with the "general" tab, but only 2 options ("source" and "alias"). Do I need a service pack, or is there something else I'm missing? Thanks. -- Craig "Gina Whipp" wrote: Craig, It's still there... are you looking at the Query Properties or the Field Properties (won't find it there)? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Hello. I've recently upgraded to Office 2007... Prior versions of Access allowed the user to update tables (via update queries utilizing another query) without getting the dreaded "not updateable" error. You would accomplish this by changing your query property settings to "dynaset/allow inconsisent updates". Queries in Access 2007 don't allow for this, correct? Or am I missing something? Is the only alternative to create numerous temp tables, and then use those temp tables in your queries as joins? Thanks. -- Craig .
|
|
#8
March 31st, 2010, 10:07 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Dynaset, inconsistent updates
Craig,
Oh dear... Craig my apologies, I missed the whole Update query part. That option not available in an Update query... it is in a Select query. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... OK, now I see the query properties...but still, there is no "recordset type" like in 2003...unless I'm missing something... -- Craig "Gina Whipp" wrote: Craig, Click in the area where the tables are... not on a table while the Properties window is open. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Yes, I'm in design mode for the query. But the selection type says "field list properties", not "query properties". -- Craig "Gina Whipp" wrote: Craig, Does it say... Property Sheet Selection Type: Query Properties General ...what kind of query is it? AND are you in Design Mode for the query? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Thanks for the reply. No, I do not see it. When I open a 2003 Access query and right-click the query properties I get a dialog box with a "general" tab that includes several options, including "recordset type" that you can toggle to "dynaset", etc. I don't see that in Access 2007 queries. When I right-click in the query I get a dialog box with the "general" tab, but only 2 options ("source" and "alias"). Do I need a service pack, or is there something else I'm missing? Thanks. -- Craig "Gina Whipp" wrote: Craig, It's still there... are you looking at the Query Properties or the Field Properties (won't find it there)? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Hello. I've recently upgraded to Office 2007... Prior versions of Access allowed the user to update tables (via update queries utilizing another query) without getting the dreaded "not updateable" error. You would accomplish this by changing your query property settings to "dynaset/allow inconsisent updates". Queries in Access 2007 don't allow for this, correct? Or am I missing something? Is the only alternative to create numerous temp tables, and then use those temp tables in your queries as joins? Thanks. -- Craig .
|
|
#9
March 31st, 2010, 10:34 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Dynaset, inconsistent updates
No problem...thanks for the assistance.
So, my understanding is you can't update data in a table (linking a query to a table) with inconsistent updates, as you could in version 2003? thanks. -- Craig "Gina Whipp" wrote: Craig, Oh dear... Craig my apologies, I missed the whole Update query part. That option not available in an Update query... it is in a Select query. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... OK, now I see the query properties...but still, there is no "recordset type" like in 2003...unless I'm missing something... -- Craig "Gina Whipp" wrote: Craig, Click in the area where the tables are... not on a table while the Properties window is open. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Yes, I'm in design mode for the query. But the selection type says "field list properties", not "query properties". -- Craig "Gina Whipp" wrote: Craig, Does it say... Property Sheet Selection Type: Query Properties General ...what kind of query is it? AND are you in Design Mode for the query? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Thanks for the reply. No, I do not see it. When I open a 2003 Access query and right-click the query properties I get a dialog box with a "general" tab that includes several options, including "recordset type" that you can toggle to "dynaset", etc. I don't see that in Access 2007 queries. When I right-click in the query I get a dialog box with the "general" tab, but only 2 options ("source" and "alias"). Do I need a service pack, or is there something else I'm missing? Thanks. -- Craig "Gina Whipp" wrote: Craig, It's still there... are you looking at the Query Properties or the Field Properties (won't find it there)? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Hello. I've recently upgraded to Office 2007... Prior versions of Access allowed the user to update tables (via update queries utilizing another query) without getting the dreaded "not updateable" error. You would accomplish this by changing your query property settings to "dynaset/allow inconsisent updates". Queries in Access 2007 don't allow for this, correct? Or am I missing something? Is the only alternative to create numerous temp tables, and then use those temp tables in your queries as joins? Thanks. -- Craig .
|
|
#10
March 31st, 2010, 10:37 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Dynaset, inconsistent updates
Craig,
I just saw you posted a reply but it disappeared from newsreader just that quick. Please repost... -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Gina Whipp" wrote in message ... Craig, Oh dear... Craig my apologies, I missed the whole Update query part. That option not available in an Update query... it is in a Select query. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... OK, now I see the query properties...but still, there is no "recordset type" like in 2003...unless I'm missing something... -- Craig "Gina Whipp" wrote: Craig, Click in the area where the tables are... not on a table while the Properties window is open. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Yes, I'm in design mode for the query. But the selection type says "field list properties", not "query properties". -- Craig "Gina Whipp" wrote: Craig, Does it say... Property Sheet Selection Type: Query Properties General ...what kind of query is it? AND are you in Design Mode for the query? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Gina... Thanks for the reply. No, I do not see it. When I open a 2003 Access query and right-click the query properties I get a dialog box with a "general" tab that includes several options, including "recordset type" that you can toggle to "dynaset", etc. I don't see that in Access 2007 queries. When I right-click in the query I get a dialog box with the "general" tab, but only 2 options ("source" and "alias"). Do I need a service pack, or is there something else I'm missing? Thanks. -- Craig "Gina Whipp" wrote: Craig, It's still there... are you looking at the Query Properties or the Field Properties (won't find it there)? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Craig" wrote in message ... Hello. I've recently upgraded to Office 2007... Prior versions of Access allowed the user to update tables (via update queries utilizing another query) without getting the dreaded "not updateable" error. You would accomplish this by changing your query property settings to "dynaset/allow inconsisent updates". Queries in Access 2007 don't allow for this, correct? Or am I missing something? Is the only alternative to create numerous temp tables, and then use those temp tables in your queries as joins? Thanks. -- Craig .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
