3 Replies - 4957 Views - Last Post: 12 January 2010 - 10:37 AM Rate Topic: -----

#1 srbatcha   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 17
  • Joined: 20-March 09

speed up in my vb6.0 with ms-access project

Posted 11 January 2010 - 11:54 AM

Hi
i have done one project using vb6.0 with ms-access 2003.
and report will display in excel. now a days my project very slow.
(now more than 1000 records)

how can i speed up in my project

please help me
Is This A Good Question/Topic? 0
  • +

Replies To: speed up in my vb6.0 with ms-access project

#2 June7   User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: speed up in my vb6.0 with ms-access project

Posted 11 January 2010 - 05:28 PM

Your entire dataset is just over 1000 records? That's barely drop in a bucket. I have Access project of at least 100,000 records for which speed is not a problem and that is not a terribly big data set

You will probably have to give more info about your db structure (presume you mean VB6 is frontend and Access2003 is the backend) and how you establish connection to data.

This post has been edited by June7: 12 January 2010 - 10:32 AM

Was This Post Helpful? 0
  • +
  • -

#3 thava   User is offline

  • D.I.C Lover
  • member icon

Reputation: 180
  • View blog
  • Posts: 1,607
  • Joined: 17-April 07

Re: speed up in my vb6.0 with ms-access project

Posted 12 January 2010 - 07:22 AM

hi if you are try to impost data's to excel
the best way is using clipboard method
if you use cell by cell method it's really slow down your process

http://www.lmgtfy.co...lipboard+in+vb6

the first link will provide many solutions to you

This post has been edited by thava: 12 January 2010 - 07:28 AM

Was This Post Helpful? 0
  • +
  • -

#4 June7   User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: speed up in my vb6.0 with ms-access project

Posted 12 January 2010 - 10:37 AM

Good point by Thava, if it is the writing out to Excel through VB code that is slow, then yes you could notice it with only 1000 records.

If you only want the interface with Excel to present the data in a 'report' and are not doing any manipulation of data or calcs in Excel, would suggest that you find an alternate reporting method.

Thava, very clever link!
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1