473,387 Members | 1,497 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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

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 programmatically 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 1309

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

Similar topics

6
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...
1
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...
10
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...
3
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...
2
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...
2
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...
3
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...
3
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. ...
3
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
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
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

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.