473,785 Members | 2,720 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 1676
"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
1662
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
10551
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
2651
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
5893
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
1373
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
1790
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
4447
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
9481
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10155
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...
1
10095
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7502
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
6741
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
5383
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...
0
5513
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3655
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2881
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.