Problem: move files from sql2000 server S1 to sql2000 S2 the fastest way possible. S1 is 4 times faster than S2.
Which is faster:
1. DTS on S1 to push to S2
2. DTS on S2 to pull from S1
3. bcp on S1 to push to S2
4. bcp on S2 to pull from S1
According to Microsoft a bcp doing export is 3 to 6...
I am using the following VBA code to automatically refresh my crystal reports:
Dim crpApplication As CRPEAuto.Application
Dim crpReport As CRPEAuto.Report
Set crpApplication = CreateObject("Crystal.CRPE.Application")
...
Set crpReport = crpApplication.OpenReport(strStartDirectory &...
I am currently using VBA in Access 2000 to loop through a list of reports in the database and automatically refresh the data in the report. All our reports are in Crystal Reports Version 7. The process works fine if the PC running the program has Version 7 installed. If version 8 is installed...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.