By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,963 Members | 1,238 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,963 IT Pros & Developers. It's quick & easy.

adp and exec stored procedure

P: n/a
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
Feb 15 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Options->Advanced->Default Max Records ... 10000?

Try

CurrentProject.Connection.Execute "myProc"

Feb 15 '06 #2

P: n/a

"Lyle Fairfield" <ly***********@aim.com> ha scritto nel messaggio
news:11*********************@g14g2000cwa.googlegro ups.com...
Hi,
Options->Advanced->Default Max Records ... 10000?
no I have set 0
CurrentProject.Connection.Execute "myProc"

It's the same...only 10000 record in tabB

any ideas?

Thanks
Feb 15 '06 #3

P: n/a
As a last resort I would use an independent connection eg
Dim c As ADODB.Connection
Set c = New ADODB.Connection
With c
..Open _
"PROVIDER=SQLOLEDB.1;" _
& "INTEGRATED SECURITY=SSPI;" _
& "INITIAL CATALOG=FFDBA_ESO_LOCAL;" _
& "DATA SOURCE=FFDBA\SQLEXPRESS"
..Execute "spShrinkDatabase"
End With

Feb 15 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.