Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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

Discussion in 'Information Technology' started by hoganxian@gmail.com, Jul 28, 2006.

  1. hoganxian@gmail.com

    hoganxian@gmail.com
    Expand Collapse
    Guest

    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~~
     
  2. Loading...


  3. SusanV

    SusanV
    Expand Collapse
    Guest

    What's the query?

    <hoganxian@gmail.com> wrote in message
    news:1150292238.128137.12030@y41g2000cwy.googlegroups.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~~
    >
     
  4. hoganxian@gmail.com

    hoganxian@gmail.com
    Expand Collapse
    Guest

    Left join two exist query


    SusanV wrote:
    > What's the query?
    >
    > <hoganxian@gmail.com> wrote in message
    > news:1150292238.128137.12030@y41g2000cwy.googlegroups.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~~
    > >
     
  5. SusanV

    SusanV
    Expand Collapse
    Guest

    The SQL?

    <hoganxian@gmail.com> wrote in message
    news:1150293661.598013.124480@h76g2000cwa.googlegroups.com...
    > Left join two exist query
    >
    >
    > SusanV wrote:
    >> What's the query?
    >>
    >> <hoganxian@gmail.com> wrote in message
    >> news:1150292238.128137.12030@y41g2000cwy.googlegroups.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~~
    >> >

    >
     
  6. hoganxian@gmail.com

    hoganxian@gmail.com
    Expand Collapse
    Guest

    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?
    >
    > <hoganxian@gmail.com> wrote in message
    > news:1150293661.598013.124480@h76g2000cwa.googlegroups.com...
    > > Left join two exist query
    > >
    > >
    > > SusanV wrote:
    > >> What's the query?
    > >>
    > >> <hoganxian@gmail.com> wrote in message
    > >> news:1150292238.128137.12030@y41g2000cwy.googlegroups.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~~
    > >> >

    > >
     
  7. SusanV

    SusanV
    Expand Collapse
    Guest

    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


    <hoganxian@gmail.com> wrote in message
    news:1150295289.136113.317420@g10g2000cwb.googlegroups.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?
    >>
    >> <hoganxian@gmail.com> wrote in message
    >> news:1150293661.598013.124480@h76g2000cwa.googlegroups.com...
    >> > Left join two exist query
    >> >
    >> >
    >> > SusanV wrote:
    >> >> What's the query?
    >> >>
    >> >> <hoganxian@gmail.com> wrote in message
    >> >> news:1150292238.128137.12030@y41g2000cwy.googlegroups.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~~
    >> >> >
    >> >

    >
     
  8. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

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


    MDB just randomly craps out


    -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
    >
    >
    > <hoganxian@gmail.com> wrote in message
    > news:1150295289.136113.317420@g10g2000cwb.googlegroups.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?
    > >>
    > >> <hoganxian@gmail.com> wrote in message
    > >> news:1150293661.598013.124480@h76g2000cwa.googlegroups.com...
    > >> > Left join two exist query
    > >> >
    > >> >
    > >> > SusanV wrote:
    > >> >> What's the query?
    > >> >>
    > >> >> <hoganxian@gmail.com> wrote in message
    > >> >> news:1150292238.128137.12030@y41g2000cwy.googlegroups.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~~
    > >> >> >
    > >> >

    > >
     
  9. hoganxian@gmail.com

    hoganxian@gmail.com
    Expand Collapse
    Guest

    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
    >
    >
    > <hoganxian@gmail.com> wrote in message
    > news:1150295289.136113.317420@g10g2000cwb.googlegroups.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?
    > >>
    > >> <hoganxian@gmail.com> wrote in message
    > >> news:1150293661.598013.124480@h76g2000cwa.googlegroups.com...
    > >> > Left join two exist query
    > >> >
    > >> >
    > >> > SusanV wrote:
    > >> >> What's the query?
    > >> >>
    > >> >> <hoganxian@gmail.com> wrote in message
    > >> >> news:1150292238.128137.12030@y41g2000cwy.googlegroups.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~~
    > >> >> >
    > >> >

    > >
     
  10. SusanV

    SusanV
    Expand Collapse
    Guest

    Macros will run select queries, docmd won't
    <shrug>

    <hoganxian@gmail.com> wrote in message
    news:1150349183.009996.23210@r2g2000cwb.googlegroups.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
    >>
    >>
    >> <hoganxian@gmail.com> wrote in message
    >> news:1150295289.136113.317420@g10g2000cwb.googlegroups.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?
    >> >>
    >> >> <hoganxian@gmail.com> wrote in message
    >> >> news:1150293661.598013.124480@h76g2000cwa.googlegroups.com...
    >> >> > Left join two exist query
    >> >> >
    >> >> >
    >> >> > SusanV wrote:
    >> >> >> What's the query?
    >> >> >>
    >> >> >> <hoganxian@gmail.com> wrote in message
    >> >> >> news:1150292238.128137.12030@y41g2000cwy.googlegroups.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~~
    >> >> >> >
    >> >> >
    >> >

    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page