ACCESS FEED: Re: [MS_AccessPros] program stop in updateable query

Sabtu, 27 Juni 2015

Re: [MS_AccessPros] program stop in updateable query

Valentino-

Access gets picky sometimes. The query:

SELECT apptblannidarichiedere.Anni, aptbsenewcalcolo01.Costline, aptbsenewcalcolo01.des, aptbsenewcalcolo01.reportcode, aptbsenewcalcolo01.ProductCode, aptbsenewcalcolo01.V1 FROM aptbsenewcalcolo01, apptblannidarichiedere;

Is not updatable because you have no JOIN criteria in the FROM clause. Is there no relationship between the two tables?

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)

On Jun 27, 2015, at 6:43 PM, Valentino Avvisati valentino.avvisati@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello John,

Below there is one of the query

Very often the program go on with no problem but sometime start to giving me error run time 3073

And if I choose debug option, the following query is yellow marked and If I go on with F8 debugging the code, the program is going ahead regularly performing the query.

In addition is not always with the same query, can be different and very often do not happen

db.Execute "INSERT INTO tblmain01bis01 ( Anno, idcostcode, des, reportcode, ProductCode, FV )" & _

"SELECT apptblannidarichiedere.Anni, aptbsenewcalcolo01.Costline, aptbsenewcalcolo01.des, aptbsenewcalcolo01.reportcode, aptbsenewcalcolo01.ProductCode, aptbsenewcalcolo01.V1 " & _

"FROM aptbsenewcalcolo01, apptblannidarichiedere;"

Valentino

2015-06-27 15:26 GMT+02:00 John Viescas JohnV@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>:

Valentino-

Can you give us an example of the SQL that is causing a stop?

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)

On Jun 27, 2015, at 2:46 PM, Valentino Avvisati valentino.avvisati@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Good morning,
I have another small questoin for this wonderful group

I have some code that is running some update query
"db.Execute "UPDATE .....,

I do not know whay but somtime running this query the program stop with the advice that need advice