AnsweredAssumed Answered

vrf vrf- Using different versions of MS Access

Question asked by VRFuser on Feb 13, 2004

Like • Show 0 Likes0
Comment • 4

No one else has this question

Outcomes

4 Replies

VRFuser Feb 4, 2004 5:27 PM
Mark Correct
Correct Answer
Has anyone run into this problem:
1) Having Microsoft Access 97 on one computer and Access 2003 (or Access 2000) on another.
2) Writing a VEE program to be able to use on both computers.

Here's what I'm doing now:
Set mdb = createObject("DAO.DBEngine.35").OpenDatabase(mdbFileSpec);
The "DAO.DBEngine.35" refers to Access 97.
I think "DAO.DBEngine.36" refers to Access 2000 and
I'm not sure what Access 2003 refers to.

Question: Can I somehow Query what version of Access a computer is running and refer to the DBEngine dll on the fly?
In other words, If my Query sends back that I'm using Access 97 then use DAO.DBEngine.35, if Access 200 then use DAO.DBEngine.36.
Thanks

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!
Like • Show 0 Likes0
Actions
VRFuser Feb 5, 2004 2:52 AM
Mark Correct
Correct Answer
Like • Show 0 Likes0
Actions
g.nied Feb 5, 2004 3:59 PM
Mark Correct
Correct Answer
If you really wanna use the old DAO ...

you should do the following:

one formula box with 'Set DE = createObject("DAO.DBEngine.36")'
and add an error pin to the output. If 3.6 is not installed the error pin fires and you add another formula to that thread with "Set DE = createObject("DAO.DBEngine.35")" and continue your program.
Next item would be to open the database with "set mdb =DE.OpenDatabase(mdbFileSpec)"

But I would really reccomend to use the ADO libraries instead. DAO is not updated by Microsoft any more but ADO is. Moreover your version problem does not exist here because the ADO library operates with version independent ID's. Therefore you can use:
Set Con = createObject("ADODB.Connection") and your OS automatically uses the installed version.

best regards,

G. Nied

-------------------------------------------------------------------------
Georg Nied - Software-Development - Hansestr.7 - 51149 Cologne - Germany
Tel: +49 2203 9770915 - Fax: +49 2203 9770924 - eMail:info@gn-software.de
-------------------------------------------------------------------------

To: rhart@suptech.com
vrf@agilent.com

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!
Like • Show 0 Likes0
Actions
VRFuser Feb 6, 2004 1:18 AM
Mark Correct
Correct Answer
Dear all,

in the context of a big VEE project I need to observe signals on an RS232
line. So far I had a protocol analyzer from Hewlett Packard, but this device
has now reached the end of its life. I tried to find a "cheap" substitute,
but I failed. I do not need protocol analysis, I just need to view by eyes
on the data.

Does anybody have a recommendation where I could buy such a device.

Thanks
Hans-Joachim Fischer

------------------------------------------
ESF GmbH
Brennerweg 7
D-89143 Blaubeuren
+49-7344-919693
+49-7344-919691 (fax)
+49-175-40 74 5 74 (GSM)
http://www.esf-gmbh.de
------------------------------------------
This e-mail may contain trade secrets or privileged, undisclosed or
otherwise confidential information. If you have received this e-mail in
error, you are hereby notified that any review, copying or distribution of
it is strictly prohibited. Please inform us immediately and destroy the
original transmittal. Thank you for your cooperation.
------------------------------------------
---------- Ende ------- The end ----------

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!
Like • Show 0 Likes0
Actions

vrf vrf- Using different versions of MS Access

Outcomes

Related Content

Recommended Content