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 tabA I find

What I wrong?

Feb 15 '06 #1
Share this Question
Share on Google+
3 Replies

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


CurrentProject.Connection.Execute "myProc"

Feb 15 '06 #2

P: n/a

"Lyle Fairfield" <ly***********> ha scritto nel messaggio
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?

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 _
..Execute "spShrinkDatabase"
End With

Feb 15 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.