About "Operation must use updateable query" (Error: 3073)

Hi,there,

My purpose is once clicking the a button ( using Access form ) VBA
code will generate a query and execute it.

However, I encounter this error: "Operation must use updateable
query" (Error: 3073)

I set "Everyone" has the full control of the Access database folder,
but it does not work.

If I test that query in a module( step by step, without using Form,
Button, etc) it works well.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11402-about-operation-must-use-updateable-query.html

So, what's the problem?

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
Any ideas?

thanks~~


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

What's the query?

wrote in message
news:1150292238.128137.12030@y41g2000cwy.googlegro ups.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
> Hi,there,
>
> My purpose is once clicking the a button ( using Access form ) VBA
> code will generate a query and execute it.
>
> However, I encounter this error: "Operation must use updateable
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
> query" (Error: 3073)
>
> I set "Everyone" has the full control of the Access database folder,
> but it does not work.
>
> If I test that query in a module( step by step, without using Form,
> Button, etc) it works well.
>
> So, what's the problem?
>
> Any ideas?
>
> thanks~~
>

Left join two exist query


SusanV wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
> What's the query?
>
> wrote in message
> news:1150292238.128137.12030@y41g2000cwy.googlegro ups.com...
> > Hi,there,
> >
> > My purpose is once clicking the a button ( using Access form ) VBA
> > code will generate a query and execute it.
> >
> > However, I encounter this error: "Operation must use updateable
> > query" (Error: 3073)
> >
> > I set "Everyone" has the full control of the Access database folder,
> > but it does not work.
> >
> > If I test that query in a module( step by step, without using Form,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
> > Button, etc) it works well.
> >
> > So, what's the problem?
> >
> > Any ideas?
> >
> > thanks~~
> >

The SQL?

wrote in message
news:1150293661.598013.124480@h76g2000cwa.googlegr oups.com...
> Left join two exist query
>
>
> SusanV wrote:
>> What's the query?
>>
>> wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
>> news:1150292238.128137.12030@y41g2000cwy.googlegro ups.com...
>> > Hi,there,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
>> >
>> > My purpose is once clicking the a button ( using Access form ) VBA
>> > code will generate a query and execute it.
>> >
>> > However, I encounter this error: "Operation must use updateable
>> > query" (Error: 3073)
>> >
>> > I set "Everyone" has the full control of the Access database folder,
>> > but it does not work.
>> >
>> > If I test that query in a module( step by step, without using Form,
>> > Button, etc) it works well.
>> >
>> > So, what's the problem?
>> >
>> > Any ideas?
>> >
>> > thanks~~
>> >
>

SELECT gfkey, german
FROM gfkeys LEFT JOIN Tran
ON strcomp(gfkeys.gfkey,Tran.english,0)=0
WHERE Tran.english is NULL or Tran.german='&NOTRAN&';

B.T.W This SQL is generated by VBA.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402

SusanV wrote:
> The SQL?
>
> wrote in message
> news:1150293661.598013.124480@h76g2000cwa.googlegr oups.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
> > Left join two exist query
> >
> >
> > SusanV wrote:
> >> What's the query?
> >>
> >> wrote in message
> >> news:1150292238.128137.12030@y41g2000cwy.googlegro ups.com...
> >> > Hi,there,
> >> >
> >> > My purpose is once clicking the a button ( using Access form ) VBA
> >> > code will generate a query and execute it.
> >> >
> >> > However, I encounter this error: "Operation must use updateable
> >> > query" (Error: 3073)
> >> >
> >> > I set "Everyone" has the full control of the Access database folder,
> >> > but it does not work.
> >> >
> >> > If I test that query in a module( step by step, without using Form,
> >> > Button, etc) it works well.
> >> >
> >> > So, what's the problem?
> >> >
> >> > Any ideas?
> >> >
> >> > thanks~~
> >> >
> >

VBA DoCmd.RunSQL only executes action queries - update, insert, make table
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
etc. Not Select. You can use the SQL you generate for a recordset, then use
the recordset to update your table or whatever...
--
hth,
SusanV


wrote in message
news:1150295289.136113.317420@g10g2000cwb.googlegr oups.com...
> SELECT gfkey, german
> FROM gfkeys LEFT JOIN Tran
> ON strcomp(gfkeys.gfkey,Tran.english,0)=0
> WHERE Tran.english is NULL or Tran.german='&NOTRAN&';
>
> B.T.W This SQL is generated by VBA.
>
>
> SusanV wrote:
>> The SQL?
>>
>> wrote in message
>> news:1150293661.598013.124480@h76g2000cwa.googlegr oups.com...
>> > Left join two exist query
>> >
>> >
>> > SusanV wrote:
>> >> What's the query?
>> >>
>> >> wrote in message
>> >> news:1150292238.128137.12030@y41g2000cwy.googlegro ups.com...
>> >> > Hi,there,
>> >> >
>> >> > My purpose is once clicking the a button ( using Access form ) VBA
>> >> > code will generate a query and execute it.
>> >> >
>> >> > However, I encounter this error: "Operation must use updateable
>> >> > query" (Error: 3073)
>> >> >
>> >> > I set "Everyone" has the full control of the Access database
>> >> > folder,
>> >> > but it does not work.
>> >> >
>> >> > If I test that query in a module( step by step, without using
>> >> > Form,
>> >> > Button, etc) it works well.
>> >> >
>> >> > So, what's the problem?
>> >> >
>> >> > Any ideas?
>> >> >
>> >> > thanks~~
>> >> >
>> >
>

if you get this message in a real-world implementation-- then run away
and start using Access Data Projects


MDB just randomly craps out
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402


-Aaron



SusanV wrote:
> VBA DoCmd.RunSQL only executes action queries - update, insert, make table
> etc. Not Select. You can use the SQL you generate for a recordset, then use
> the recordset to update your table or whatever...
> --
> hth,
> SusanV
>
>
> wrote in message
> news:1150295289.136113.317420@g10g2000cwb.googlegr oups.com...
> > SELECT gfkey, german
> > FROM gfkeys LEFT JOIN Tran
> > ON strcomp(gfkeys.gfkey,Tran.english,0)=0
> > WHERE Tran.english is NULL or Tran.german='&NOTRAN&';
> >
> > B.T.W This SQL is generated by VBA.
> >
> >
> > SusanV wrote:
> >> The SQL?
> >>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
> >> wrote in message
> >> news:1150293661.598013.124480@h76g2000cwa.googlegr oups.com...
> >> > Left join two exist query
> >> >
> >> >
> >> > SusanV wrote:
> >> >> What's the query?
> >> >>
> >> >> wrote in message
> >> >> news:1150292238.128137.12030@y41g2000cwy.googlegro ups.com...
> >> >> > Hi,there,
> >> >> >
> >> >> > My purpose is once clicking the a button ( using Access form ) VBA
> >> >> > code will generate a query and execute it.
> >> >> >
> >> >> > However, I encounter this error: "Operation must use updateable
> >> >> > query" (Error: 3073)
> >> >> >
> >> >> > I set "Everyone" has the full control of the Access database
> >> >> > folder,
> >> >> > but it does not work.
> >> >> >
> >> >> > If I test that query in a module( step by step, without using
> >> >> > Form,
> >> >> > Button, etc) it works well.
> >> >> >
> >> >> > So, what's the problem?
> >> >> >
> >> >> > Any ideas?
> >> >> >
> >> >> > thanks~~
> >> >> >
> >> >
> >

The problem is : If I run this query in another macro,like this:

public sub test()

DoCmd.TransferSpreadsheet, acExport,
acSpreadSheetTypeExcel9,'qryTemp","d:\a.xls"

end sub

It works very well!!!

So, why??



SusanV wrote:
> VBA DoCmd.RunSQL only executes action queries - update, insert, make table
> etc. Not Select. You can use the SQL you generate for a recordset, then use
> the recordset to update your table or whatever...
> --
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
> hth,
> SusanV
>
>
> wrote in message
> news:1150295289.136113.317420@g10g2000cwb.googlegr oups.com...
> > SELECT gfkey, german
> > FROM gfkeys LEFT JOIN Tran
> > ON strcomp(gfkeys.gfkey,Tran.english,0)=0
> > WHERE Tran.english is NULL or Tran.german='&NOTRAN&';
> >
> > B.T.W This SQL is generated by VBA.
> >
> >
> > SusanV wrote:
> >> The SQL?
> >>
> >> wrote in message
> >> news:1150293661.598013.124480@h76g2000cwa.googlegr oups.com...
> >> > Left join two exist query
> >> >
> >> >
> >> > SusanV wrote:
> >> >> What's the query?
> >> >>
> >> >> wrote in message
> >> >> news:1150292238.128137.12030@y41g2000cwy.googlegro ups.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
> >> >> > Hi,there,
> >> >> >
> >> >> > My purpose is once clicking the a button ( using Access form ) VBA
> >> >> > code will generate a query and execute it.
> >> >> >
> >> >> > However, I encounter this error: "Operation must use updateable
> >> >> > query" (Error: 3073)
> >> >> >
> >> >> > I set "Everyone" has the full control of the Access database
> >> >> > folder,
> >> >> > but it does not work.
> >> >> >
> >> >> > If I test that query in a module( step by step, without using
> >> >> > Form,
> >> >> > Button, etc) it works well.
> >> >> >
> >> >> > So, what's the problem?
> >> >> >
> >> >> > Any ideas?
> >> >> >
> >> >> > thanks~~
> >> >> >
> >> >
> >

Macros will run select queries, docmd won't


wrote in message
news:1150349183.009996.23210@r2g2000cwb.googlegrou ps.com...
> The problem is : If I run this query in another macro,like this:
>
> public sub test()
>
> DoCmd.TransferSpreadsheet, acExport,
> acSpreadSheetTypeExcel9,'qryTemp","d:\a.xls"
>
> end sub
>
> It works very well!!!
>
> So, why??
>
>
>
> SusanV wrote:
>> VBA DoCmd.RunSQL only executes action queries - update, insert, make
>> table
>> etc. Not Select. You can use the SQL you generate for a recordset, then
>> use
>> the recordset to update your table or whatever...
>> --
>> hth,
>> SusanV
>>
>>
>> wrote in message
>> news:1150295289.136113.317420@g10g2000cwb.googlegr oups.com...
>> > SELECT gfkey, german
>> > FROM gfkeys LEFT JOIN Tran
>> > ON strcomp(gfkeys.gfkey,Tran.english,0)=0
>> > WHERE Tran.english is NULL or Tran.german='&NOTRAN&';
>> >
>> > B.T.W This SQL is generated by VBA.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
>> >
>> >
>> > SusanV wrote:
>> >> The SQL?
>> >>
>> >> wrote in message
>> >> news:1150293661.598013.124480@h76g2000cwa.googlegr oups.com...
>> >> > Left join two exist query
>> >> >
>> >> >
>> >> > SusanV wrote:
>> >> >> What's the query?
>> >> >>
>> >> >> wrote in message
>> >> >> news:1150292238.128137.12030@y41g2000cwy.googlegro ups.com...
>> >> >> > Hi,there,
>> >> >> >
>> >> >> > My purpose is once clicking the a button ( using Access form )
>> >> >> > VBA
>> >> >> > code will generate a query and execute it.
>> >> >> >
>> >> >> > However, I encounter this error: "Operation must use updateable
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11402
>> >> >> > query" (Error: 3073)
>> >> >> >
>> >> >> > I set "Everyone" has the full control of the Access database
>> >> >> > folder,
>> >> >> > but it does not work.
>> >> >> >
>> >> >> > If I test that query in a module( step by step, without using
>> >> >> > Form,
>> >> >> > Button, etc) it works well.
>> >> >> >
>> >> >> > So, what's the problem?
>> >> >> >
>> >> >> > Any ideas?
>> >> >> >
>> >> >> > thanks~~
>> >> >> >
>> >> >
>> >
>