Question about Business & Productivity Software

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

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


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


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

  • Expert
  • 108 Answers
Re: vb 6 access97

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 can paste pieces of it on other will get some feedback. Hope this helps...Tango.

Posted on Jan 27, 2008

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

How to fix error in database: microsoft office access has detected corruption in this file

System restore will not restore any data files, only system files.
Databases normally need periodic sorting as their indexes get corrupted. I don't use any microripoffsoft stuff, only Open Office and iMac. Try reindexing your file with Open Office

Nov 01, 2015 | Microsoft Office 2003 Basic Edition...

3 Answers

What is SQL?

It is a special purpose programing language. Computer language you will never use, unless you are into servers or programing type software

Jan 27, 2015 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

How to link vb 6.0 to msaccess?

You Need ODBC to solve your link... ODBC is a gateway. Can Access by Microsoft Access or VB in same time... Note: Please in Code Programming you must lock or unlock you data if you want application running same time..

Jul 20, 2009 | Microsoft Business & Productivity Software

1 Answer

Adodb connection

In VB6 you would use ADODB. This is for ADO and is used for accessing data (read, write, update, etc.) from different data sources. Your connection string will vary based on the data source you need to connect to. Here is an example for a SQL connection:

"Provider=SQLOLEDB;Data Source=your_server;Initial Catalog=your_database;User ID=sa;Password=your_password;"

For VB.NET you would be using the ADO.NET toosl and a connection string as well.

Apr 27, 2009 | Business & Productivity Software

4 Answers

How get sql data backup

there is facility in enterprise manager to take back of database!

Feb 04, 2009 | Keystone Active Server Pages (ASP)/Visual...

1 Answer

Hello to i need defination of microsoft access now.thanx

A database is a collection of information (or data) that is organized to make retrieving specific information easy. Access isa software application used to create and manage a computerized database.
Microsoft Access is database software that tracks information for business or individuals. It's included in the Microsoft Office suite or as a stand alone program. Access is a relational database management system that links tables through common fields such as a part number, invoice number, or social security number. Relational database management systems can eliminate duplication of data and enhance validity by specifying relationships between tables.

Jan 11, 2009 | Microsoft Access 2002 for PC

1 Answer

Code for find the Ms access database size using visual basic

The way to get the database size is to point to the directory that the database is do a DIR statement with an output to a file as in DIR payroll.mdb>dbsize.txt and then read from the text file, the first field of the second line being the name (which you really don't need) then the size value of the database.

To import the text files using VB 8 use

'Imports System.Data.OleDb Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\path\filename.mdb") Dim cmd As New OleDbCommand("SELECT * INTO [import] FROM [Text;Database=d:\path;Hdr=No].[dbsize.txt]", conn) conn.Open() cmd.ExecuteNonQuery() conn.Close()

Nov 10, 2008 | Microsoft Office Standard for PC

1 Answer

Access 2003

page setup problem in access 2003

Mar 08, 2008 | Microsoft Office 2003 Basic Edition...

1 Answer

MS Access and application

You probably need to be inserting the value of a text object (ie, a String) , not the object itself. In VB.NET, a String object is an actual, not unlike a Java String object. In "classic" VB, a String object isn't really handled by the interpreter as an object in the C# / Java sense, so it can be referred to directly without resolving the value via a method call. So attempting to insert an object reference into a database field from C# code will probably not work unless the database knows to call toSting() on the object, which I am 99.99999% sure it cannot (depends on the database-- in this case Access, and more particularly, what version you are using, and if there is any .NET framework interoperability).

Calling myString.toString() though returns a String object in C#, so using that is likely not going to work. What you may need to do is return a character array using the 'chars' and 'length' properties of the C# String object.

Finally, after all this, your problem could be a lot simpler: the value(s) you are trying to insert may not be right for the field-- check the length of the values being inserted, etc. Use .trim() to eliminate leading and trailing whitespace, for example. If you post your INSERT statement and an example of the data you are using, I may be able to tell you more. Also, you are in ASP.NET and data transfer from web containers to Access databases is notoriously bedeviled work.

Mar 07, 2008 | Business & Productivity Software

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..

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

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

89 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides