beginner needed experts help!!!!

Results 1 to 2 of 2

Thread: beginner needed experts help!!!!

  1. #1
    Join Date
    Dec 1969

    Default beginner needed experts help!!!!

    Pl. tell me how will i control no.of records per page when accessing millions of records.<BR><BR>And also i would like to know why everybody will set <BR>connection=Nothing after closing it at the end of the program.<BR><BR> me....<BR>Thanks.

  2. #2
    jason Guest

    Default RE: beginner needed experts help!!!!

    recordset.pagesize or<BR><BR>"SELECT TOP 20 FROM........"<BR><BR>set objConn = nothing just frees up resources on the machine by destroying the object immediately, instead of relying on the server to spot it and destroy it, which may not happen immediately. helps your server go zoom-zoom and should always be done with COM objects<BR><BR>jason

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts