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!
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.
--- 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!
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!
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!