473,746 Members | 2,589 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

access2000 dao / ado - can references order by changed programatically

I've got an access97 app that is being converted to access2000
a dao recordset is different than an ado recordset, and whether or not
the app works is determined by the priority of the libraries in the
reference list

is there some vba code that can
a) tell me which of the 2 (dao or ado) is first in the list
b) switch the order to put dao first if required
I know that the vba code can be changed to dao.recordset, but there's
lots of those
Nov 13 '05 #1
2 1671
"Roger" <le*********@na tpro.com> wrote in message
news:8c******** *************** ***@posting.goo gle.com...
I've got an access97 app that is being converted to access2000
a dao recordset is different than an ado recordset, and whether or not
the app works is determined by the priority of the libraries in the
reference list

is there some vba code that can
a) tell me which of the 2 (dao or ado) is first in the list
b) switch the order to put dao first if required
I know that the vba code can be changed to dao.recordset, but there's
lots of those

So how many seconds would it take to convert "As Recordset" to "As
DAO.Recordset" using Access's built-in find and replace functionality? If
you're just starting the conversion process, there shouldn't be any
ADOB.Recordsets as it was written for Access 97.
Nov 13 '05 #2
le*********@nat pro.com (Roger) wrote in message news:<8c******* *************** ****@posting.go ogle.com>...
I've got an access97 app that is being converted to access2000
a dao recordset is different than an ado recordset, and whether or not
the app works is determined by the priority of the libraries in the
reference list

is there some vba code that can
a) tell me which of the 2 (dao or ado) is first in the list
b) switch the order to put dao first if required
I know that the vba code can be changed to dao.recordset, but there's
lots of those

Your best bet is to disambiguate your references. If you prepend
"DAO." to all your objects, you should be fine. Then you can use
GetReferenceFro mFile to register the DAO library if you want. If you
don't, any object that is also in the ADO object model will cause an
error.
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
1659
by: A-PK | last post by:
Anyone know how to breakdown every modules into different assemblies and refernces. Hence, to repair problematic module, only that particular module needed to be recompiled. or any place can get more information about assemblies & references
2
10549
by: Mike Metzger | last post by:
I've been running an Access2000 database for a couple years on a Win2k machine fine. We tried to copy the database over to another machine that already had Access2000 installed. When we tried to run it, we got an error on the following piece of VBA code embedded in a form: ------------------------ With Me .AgeMax = DateDiff("yyyy", Me.dteDateOfBirthMin, Date) .AgeMin = DateDiff("yyyy", Me.dteDateOfBirthMax, Date) End With...
1
2648
by: Mario Crevits | last post by:
My name is Mario Crevits, I'm from Belgium (Roeselare) and I'm working with Access97 for several years now. We are in an Access97-2000 migration project. I'm writing a wizard for the end-users to automatically find and convert their Access97 databases on a specific drive. I want to convert the databases through VBA : 1. create an empty Access2000 2. set the right properties and references 3. import the objects (tables, queries,...
3
5891
by: SAM | last post by:
Hi everyone, I consider myself a very competent programmer when it comes to actual programming and analyzing the business that I'm modelling. I am now crossing into what I would consider Access admin/config territory, an area where I generally suck at. Here is my problem. I do all my programming on my laptop before giving
3
1544
by: Bruce Acciavatti | last post by:
I've split a rather large Access2000 database that resides on a network drive, by keeping the back-end on the network drive and placing the front-end on the client's hard drive, linked to it. Both front-end and back-end dbs are then compacted to save space. This is a normal procedure, but when I run the database now it performs much, much slower than the old unsplit version of the database, which is unacceptable. I have had to back off...
4
3771
by: Adam Ratcliffe | last post by:
I have 2 onload handlers on a web page. One is set programatically in an included script and the other declared on the document's body element. In practice the programatically set onload handler always fires first in Firefox (the desired behaviour). Do I have any guarantee that this ordering will be the same across other browsers?
9
1371
by: DrConti | last post by:
Dear Python developer community, I'm quite new to Python, so perhaps my question is well known and the answer too. I need a variable alias ( what in other languages you would call "a pointer" (c) or "a reference" (perl)) I read some older mail articles and I found that the offcial position about that was that variable referencing wasn't implemented because it's considered bad style. There was also a suggestion to write a real problem...
3
1788
by: olle | last post by:
How to deal with a VBA-project that is damaged? Hi everyone. I am BigOlle from sweden and I have been working with Accees for ten years I am now working on a project that started in Access97 and since a few months it continues in Access2000. My plan is to use Access2000 as it is supposed that mdb-files in Access 2000-format can be opened from all Access versions after that
1
4446
by: Bob Alston | last post by:
Trying to install some software on Access 2007. The software works just fine on earlier versions of Access. I have been told that it works on Access 2007 but I have not seen that personally. The command buttons on my user-created forms do not function when it is run under Access 2007. The operating system is Windows XP home SP2.
0
8974
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
9508
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
9350
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
9218
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
6772
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
6060
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
4586
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3292
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
2
2765
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.