updatable query
in [Queries]
|
Prev: SQL BETWEEN If end date is less than start date all recordsbetween are still displayed.
Next: formatting a phone number in a string
From: inungh on 3 Apr 2010 14:36 I just ran a query and MS Access shows it is un updatable query. I just wonder are there any query is updatable? If yes, are there any rules that for updatable query? Your information is great appreciated,
From: Bob Barrows on 3 Apr 2010 15:16 inungh wrote: > I just ran a query and MS Access shows it is un updatable query. > > I just wonder are there any query is updatable? > If yes, are there any rules that for updatable query? > > There's a wealth of information about this in Access online help if you just type "updatable query" into the search box and look at the topic called "About updating data" where you will find a link to "When can I update data from a query? (MDB) ". You can also google for "updateable query" -- Microsoft MVP - ASP/ASP.NET - 2004-2007 Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
From: inungh on 5 Apr 2010 15:08
On Apr 3, 3:16 pm, "Bob Barrows" <reb01...(a)NOyahoo.SPAMcom> wrote: > inungh wrote: > > I just ran a query and MS Access shows it is un updatable query. > > > I just wonder are there any query is updatable? > > If yes, are there any rules that for updatable query? > > There's a wealth of information about this in Access online help if you just > type "updatable query" into the search box and look at the topic called > "About updating data" where you will find a link to "When can I update data > from a query? (MDB) ". > > You can also google for "updateable query" > > -- > Microsoft MVP - ASP/ASP.NET - 2004-2007 > Please reply to the newsgroup. This email account is my spam trap so I > don't check it very often. If you must reply off-line, then remove the > "NO SPAM" Thanks for the information, |