Question about Computers & Internet

1 Answer

Vb 6 access97

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

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 108 Answers

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Where can I get free download of Visual Basic 6.0 installer?


Visual Basic 6.0 is no longer supported by Microsoft so how do you get a hold of it? Currently there is not an easy legal way to get a hold of VB6. Yes that's correct - although people will tell you to simply download a bit-torrents for VB6, this is not legal because you did not buy a VB6 license. Stupid I agree considering that Microsoft does not allow you to purchase a license.

If you simply need to install an application that was originally written in VB6 you can download the Runtime Installer for VB, install it, and then install your VB program. If you want to get a hold of the VB6 developer environment I suggest asking friends that might have it and no longer use it - for example companies that maybe bought legitimate copies and are willing to give up their license (although you would need to verify this is legal and that the license is transferable). Another option is to try and buy it on EBAY.

Jun 14, 2011 | Microsoft Visual Basic 6.0 for PC

1 Answer

How to setup visual basic 6.0


  1. One of the first and best things to do is begin to understand the Visual Basic IDE (Integrated Development Environment). By understanding the IDE you will be able to develop VB programs quickly and effectively. Start by reading the Getting to know the VB6 IDE tutorial
  2. The classic first program in any language is the Hello World tutorial. As a beginner you should make sure you write this program to get your feet wet. Check out the Simple Hello World VB6 tutorial
  3. Good programmers figure out how to use a consistent naming scheme when they develop applications. The quickest way to graduate out of the beginner VB6 level is to check out the Object Types and Naming Scheme VB tutorial
  4. Variables are used in any real development. Make sure you visit the Quick Variable tutorial to see how variables work in Visual Basic 6
  5. (Optional) More In Depth Understanding variables and types in VB6
  6. When you need to make comparisons or have your program choose between options you will need to understand Visual Basic's if statements. Luckily there's a beginners tutorial that explains just that: Understanding the if conditional statement
  7. Once you grasp the basics check out this next beginner VB6 tutorial that goes more in depth into conditional statements: Understanding if statements and conditionals in VB6
  8. Need to do something repeatedly? Need to iterate through a list of things? Need to count from 1 to 1 Billion by 3's? You need to understand loops! Understanding For, Do, and while Loops
  9. Once a beginner understands how to use functions and subroutines he or she is on the road to being a full fledged VB6 guru. A solid grasp on functions and subroutines allows you to reuse code and functionality throughout your program and in future programs.Functions and Subroutines in VB6 tutorial
  10. Last but not least, begin to learn how to use all the great controls Visual Basic offers and create a great User Interface for your clients to use. Basic Graphical User Interfaces in VB6 - Tutorial
Once you have finished these tutorials you should have a very good understanding of the fundamentals of the Visual Basic 6 language and development environment. Feel free to download some more advanced tutorials and continue learning on your own. If you have any questions or comments related to this Visual Basic 6 guide please post them below.

Jan 27, 2010 | Microsoft Visual Basic 6.0 for PC

1 Answer

I need to program a calculator in vb 6


Dear here is the link that contains a sample code to your problem.

http://www.vb6.us/source-code/simple-calculator-written-vb6

Best regard

May 26, 2009 | Microsoft Windows XP Professional

1 Answer

Retrieving acess data which is password protected thru VB


You will need to use a connection string. But - before you can configure the string correctly, I'd need to know how the data is stored (Access, SQL, ODBC, etc). You can find examples online. Just know that you are looking for "Connection String." Here's two examples:
1. For MS Access (Jet files):
' Set up the connection string.
m_strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strDestDBPath & ";" & _
"Jet OLEDB:Engine Type=5" ' NOTE: Use Type=5 for Jet 4.x.

2. For SQL database:
g_strADOConn = "Provider=SQLOLEDB;" & _
"Data Source=SERVER_NAME;" & _
"Initial Catalog=DATABASE_NAME;" & _
"User ID=mssql_userid;" & _
"Password=mssql_password;"

Apr 22, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Migration from single machine to multiuser environment


have you made sure that the ADODC path points to the machine that holds the database on a remote path for example (\\ComputerName\c$\Data\) and that it isn't a local path. (C:\Data\)

Dec 15, 2008 | Microsoft Windows Server Standard 2003 for...

1 Answer

Send me the related titles to develop a projects in c,c++,vb


Hi,
in C/C++ you can have projects related to system/hardware, maths and engineering.
while in VB you can create Database/Interface oriented projects. The related titles are :--
C/C++
=====
1. Serial/Parallel port communication
2. Automatic weight entry from Weighing Machine
3. Your weight on different plannets
4. PC based PH Meter
5. Electronic Punching/Kicking pad to measure power of martial arts/boxing players
6. Electronic man counter
VB
==
1. library management system
2. Video Library
3. Virtual Library
4. Automated Parking Management system
5. Automated Car security check (Bomb finder)
6. Automated ID Card generator
7. Face recognition responsive system

Dec 08, 2008 | Computers & Internet

1 Answer

Database connectivity


Hello,
Please follow the link below to help with connecting to a database and displaying data using visual basic.
http://www.freevbcode.com/ShowCode.Asp?ID=1257

Please let me know if you have any questions.
Thank You, Raph30

Sep 30, 2008 | Project Justice for Dreamcast

4 Answers

Setting Datagrid runtime in Visual Basic


I think you are missing this at the end:

DataGrid1.DataBind()

Sep 06, 2008 | Computers & Internet

1 Answer

CONNECTING VB TO EXCEL


Here is some code that I found in this book:
Microsoft Visual Basic 6.0 Professional, Step by Step.
By Michael Halvorson
Second Edition.
ISBN: 0-7356-1883-6
Code removed for possible copyright issues.

That program in VB6 will open an Excel workbook, and then insert the data into the cells at B1, B2 and B3.
You can change this to have a textbox show up to ask for info to insert into the cells as appropiate.

If you look at www.microsoft.com/mspress/developer and search there, they may still have some code that you can download.

Feb 21, 2008 | Microsoft Windows XP Professional With...

1 Answer

Coding in ms word by using visual basic editor


Hello Kavita! If you want to get the most of VB then i advice that you install Microsoft visual studio...But just in case you want it for free you can find it here..
http://www.brothersoft.com/downloads/vb6.html

Nov 10, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

90 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...