473,806 Members | 2,732 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DAO to ADO Access 97 -> Access 2000 very slow VB6

2 New Member
Hi all,

I am maintaining a group of applications which share Access databases. In the newer version of the software products we have upgraded from DAO to ADO and also implemented routines to upgrade the databases from Access 97 to Access 2000.

However, bitmaps stored in the Access 97 databases when retrieved into a recordset using the older versions of our software (that used DAO) were accessed at a good speed. However, in the newer versions (which use ADO and the databases are converted to an Access 2000 format), when the same recordsets with the bitmaps are retrieved, it is extremely slow to open the recordset. When removing the bitmap data from the databases, it works fine so it seems like its something to do with retrieving large BLOB data from the database.

The only way round this problem we can see (which I have already started implementing) at the moment, is to programmaticall y convert all bitmaps stored in the database into JPEGs during the upgrade routines to the new version of the software (which now uses ADO and Access 2000).

Is this just purely because ADO is slower than DAO at retrieving large BLOBs from a database or is it something i have missed during the conversion process on the databases? If anyone has any ideas, it would be greatly appreciated!!

Thanks in advance
Feb 9 '08 #1
0 1331

Sign in to post your reply or Sign up for a free account.

Similar topics

6
3503
by: DD | last post by:
hi there, I don't think it's possible, but I'll try the question. A friend of mine mailed me a access database (.mdb), but I only use Linux (RH 9.0) . Is there anyway that I can open the database in mysql? I googled the whole web. You are my last hope Thanks in advance.
1
2899
by: Frank | last post by:
Aloha, I have a DB in Access 2000 consisting of about 1500 lines of code and 65 tables, 95 queries and 60 forms and want to "merge" with another persons program written in Access 2 with about the same size, (code, tables, queries, etc.) We would have in common one table "customers". My friend with the Access 2 likes it because he claims it is faster and takes much less programing space, so what do we do? How would you approach this...
10
5603
by: Mark Day | last post by:
Hi All, I am using Access 2000 to generate over 40 Excel charts and pivot tables using early binding to the Excel 9.0 object library. I am finding that if I show the Excel object while processing the charts, the whole process completes in around 2 minutes. However if I hide the Excel object the same process takes around 27 minutes to complete. I have played around with screen updating and this makes no real difference to the time. Does...
3
2063
by: Doug Baroter | last post by:
Hi, I have a small Access 97 database (~2.5 MB), which has about 9 user tables, and data are normalized up to 3NF. I'm using a third party tool/language for web interface application. I just did a quick test, query runing from Access's internal SQL command line/window, very fast, reasonably involved query (with three inner joins). So, the problem seems to be on the third party tool side, maybe, it's interaction with the driver is not...
2
1359
by: Vitali2000 | last post by:
Hi! I was searching all the day for the solution of the following problem: I've got an Access2000 Database and Want to export the table-structures to SQL. I've found the tool access2sql, but it only generates MySQL or Firebird Syntax. But I need Access SQL Syntax, so I can import the script in Access again. thx. mfg, Vitali2000
2
1413
by: Yisroel Markov | last post by:
Greetings, The subject says it all. Certain operations that used to run pretty fast in A97 take noticeably longer after converting a database app to A2K. For example, during login process the code checks for existence of two tables and whether they contain any data. Took 2 seconds, now takes 15-20 seconds. A report based on multiple SQL statements in each control source took 5 minutes, now takes an hour.
3
1518
by: Zman | last post by:
I've recently added form functionality on my website, which runs with the aid of a perl script and sends the results via an email message. I'm currently able to import, or link, data from a specific mail folder (Outlook 2002) to an MS Access database (Access 2002). However, my problem is the message body, which contains the data I'm interested in, is all placed in the one field. I would like the data contained in the message body to be...
3
2098
by: NickJ | last post by:
Dear all, I've encountered an unusual problem having just recently upgraded an Access 97 database to Access 2000 format and was hoping somebody could point me in the direction of a solution. 1. The problem: Essentially, a couple of the reports which contain SeriesLine charts are NOT displaying the series-lines (i.e. the results) on the charts correctly in
3
959
by: RB | last post by:
I created a VB 6 program which interfaces an Access 97 database. Once I upgraded to Access 2000, my VB6 program can't access the Access 2000 database. I get an unrecognized file format error.
0
1488
by: Stanley Sin | last post by:
Dear all , How can I remote access SQL server 2000 using vb.net? I don't know how to use ADO.net to remote access database . Any solutions? Thanks in advance. Stanley
0
9719
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10623
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10371
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10111
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7650
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6877
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5683
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4330
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3010
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.