Welcome to SPN

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

Sign Up Now!

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~~
    >> >> >> >
    >> >> >
    >> >

    >
     

Share This Page