Question about Business & Productivity Software
I have a system developed in vb6 + access97 as database, my database is only 67mb why it's getting slow in retrieving the data when using the system... thanks
There could be a lot of reasons ranging from a virus to simple maintenance to code that is not written correctly (you can be your own worst enemy). Here are a set of things you might wish to do to determine if the problem is with your design or elsewhere.
First.....using both Ccleaner and WiseRegistry cleaner (free downloads from a variety of places on the internet ...i.e cnet downloads). Run these. With Ccleaner just take it's advice and get rid of all. With Wise just get rid of the green checked boxes.
Next...Run scandisk in through mode set to autofix.
Next...Reboot and run your application.
Does it run faster or slower?
If faster good but if still not "fast" (and I have no idea what fast means because I don't know the application is or the machine you are working with....i.e. a Pentium III at 550 htz with Xp loaded is not going to be a winner) that would indicate you fixed some problem (more likely just maintenace related but a cross linked file could have also been a culprit - and if so the fix may have eliminated some code and your application may not work so have a back up).
If the application response time is the same (and time it before you do all the above work so you have a bench mark...i.e. from the time you execute the program until there is some sort of result) more than likely you are either underpowered (despite the size of your database) or Access has a problem or your machine is too small or you have a VB code problem. If you can put your application on a Cd and run it on a faster machine (assuming you have an older machine) and it's the same or faster that tells you something.
Next there are some free utilities on the net that will check your code for syntax in addition to those in VB (haven't used it for a long time) and maybe even some better stuff (from my old days) at the Microsoft VB support site (within Microsoft somewhere).
This is what I would do before I hacked through all the code (if you have written a bunch). On the other hand if you have written just a few pages you might want to (when fresh in the morning) go through it again....stack - buffer - loop problems could be embedded.
If all this fails consider the following possibilities....Access is corrupted (trust me it happens) or some Windows file is corrupted. You probably know (version dependent) what you have for file verification and if you have restore ability you may want to go back to a prior point in time when it was running faster.
The net result of all this will pointyou in "some" direction. The reason I suggest the maintenance stuff first is (as stated) it gives you a clean slate (no suspicions relative to dumb-dumb problem) prior to spending more time.
And opps....I forgot.....if you don't use Spybot search and Destroy and Avast or AVg (anti-virus)....(all of these are free) you should run them before you reboot but after you scan.
This is fairly parochial but without the code and a lot of additional information it's the best I can do. If you suspect you have a code problem....you can paste pieces of it on other forums....you will get some feedback. Hope this helps...Tango.
Posted on Jan 27, 2008
Tips for a great answer:
Nov 01, 2015 | Microsoft Office 2003 Basic Edition...
Jul 20, 2009 | Microsoft Business & Productivity Software
Apr 27, 2009 | Business & Productivity Software
Jan 11, 2009 | Microsoft Access 2002 for PC
Nov 10, 2008 | Microsoft Office Standard for PC
Mar 07, 2008 | Business & Productivity Software
Nov 10, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)
Oct 21, 2016 | The Business & Productivity Software
89 people viewed this question
Usually answered in minutes!