adp and exec stored procedure

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • zacco
    #1

    adp and exec stored procedure

    hi everybody, first of all sorry for my english

    i work with a adp file and msde

    this is my problem:

    in a form I have this command

    docmd.runsql "exec myProc"


    myproc is "insert into tabA (id1, id2) select (id1, id2) from tabB ......"

    tabA have 23000 record but after this command in tabA I find just 10000

    If I open manually myProc from database windows all is ok...in tabA I find
    23000

    What I wrong?

    Thanks
    Max


    Tags: None
    • Lyle Fairfield
      #2
      Re: adp and exec stored procedure

      Options->Advanced->Default Max Records ... 10000?

      Try

      CurrentProject. Connection.Exec ute "myProc"

        Comment

        • AEOM
          #3
          Re: adp and exec stored procedure


          "Lyle Fairfield" <lylefairfield@ aim.com> ha scritto nel messaggio
          news:1139963482 .721082.47460@g 14g2000cwa.goog legroups.com...


          Hi,
          [color=blue]
          > Options->Advanced->Default Max Records ... 10000?[/color]

          no I have set 0
          [color=blue]
          > CurrentProject. Connection.Exec ute "myProc"[/color]
          It's the same...only 10000 record in tabB

          any ideas?

          Thanks


            Comment

            • Lyle Fairfield
              #4
              Re: adp and exec stored procedure

              As a last resort I would use an independent connection eg
              Dim c As ADODB.Connectio n
              Set c = New ADODB.Connectio n
              With c
              ..Open _
              "PROVIDER=SQLOL EDB.1;" _
              & "INTEGRATED SECURITY=SSPI;" _
              & "INITIAL CATALOG=FFDBA_E SO_LOCAL;" _
              & "DATA SOURCE=FFDBA\SQ LEXPRESS"
              ..Execute "spShrinkDataba se"
              End With

                Comment

                Previous template Next
                Working...