AnsweredAssumed Answered

vrf Vee and Microsoft Access 2002 Databases

Question asked by Dave_E on Jan 4, 2006
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 11 (filtered medium)"><!--[if !mso]><style>v:* {behavior:url(#default#VML);}o:* {behavior:url(#default#VML);}w:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);}</style><![endif]--><o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/><!--[if !mso]><style>st1:*{behavior:url(#default#ieooui) }</style><![endif]--><style><!-- /* Font Definitions */ @font-face     {font-family:Tahoma;     panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal     {margin:0cm;     margin-bottom:.0001pt;     font-size:12.0pt;     font-family:"Times New Roman";}a:link, span.MsoHyperlink     {color:blue;     text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed     {color:blue;     text-decoration:underline;}p     {mso-margin-top-alt:auto;     margin-right:0cm;     mso-margin-bottom-alt:auto;     margin-left:0cm;     font-size:12.0pt;     font-family:"Times New Roman";}span.EmailStyle18     {mso-style-type:personal-reply;     font-family:Arial;     color:navy;}@page Section1     {size:21.0cm 842.0pt;     margin:72.0pt 89.85pt 72.0pt 89.85pt;}div.Section1     {page:Section1;}--></style></head><body lang=EN-US link=blue vlink=blue><div class=Section1><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>I’m currently using Access 2003 andVEE 7.0 but the communications between Access and VEE are all developed fromthe example programs which ship with VEE.<o:p></o:p></span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Go to Help -> Open Example and then ActiveXAutomationand there are two example programs, although they were written for Access 97they still work with later versions. All you need to do is change the currentversion of the Microsoft DAO Object Library and make sure you are calling the correctversion of the database engine for Access 2003 it is DAO.DBEngine.36 it maybe be.35 for Access 2002.<o:p></o:p></span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>In fact I have been using the same basicfunctions since VEE5 and Access 97, just had to update the ActiveX libraryreferences etc.<o:p></o:p></span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p><div><p><st1:PersonName w:st="on"><st1:PersonName w:st="on"><font size=2 color=navy  face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial;  color:navy'>Dave</span></font></st1:PersonName><font size=2 color=navy face=Arial><span lang=EN-GB style='font-size:10.0pt;font-family:Arial; color:navy'> Evanson</span></font></st1:PersonName><font color=navy><spanstyle='color:navy'>
</span></font><font size=2 color=navy face=Arial><span lang=EN-GBstyle='font-size:10.0pt;font-family:Arial;color:navy'>Characterisation Engineer</span></font><fontcolor=navy><span lang=EN-GB style='color:navy'> </span></font><o:p></o:p></p></div><div><div class=MsoNormal align=center style='text-align:center'><font size=3face="Times New Roman"><span style='font-size:12.0pt'><hr size=2 width="100%" align=center tabindex=-1></span></font></div><p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> jeremy gabel[mailto:jeremyveegabel@yahoo.com]
<b><span style='font-weight:bold'>Sent:</span></b> 04 January 2006 16:31
<b><span style='font-weight:bold'>To:</span></b> VRF
<b><span style='font-weight:bold'>Subject:</span></b> [vrf] Vee and MicrosoftAccess 2002 Databases</span></font><o:p></o:p></p></div><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p><div id=RTEContent><p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Ok, I am running a test program and each time it runs, I have about 30values that need to be stored and I wanted to use Access 2002 as the databasestorage.  How do I get Vee to send this data to a microsoft accessdatabase?<o:p></o:p></span></font></p></div><div class=MsoNormal align=center style='text-align:center'><font size=3face="Times New Roman"><span style='font-size:12.0pt'><hr size=1 width="100%" align=center></span></font></div></div>

<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"></SPAN></FONT> </P><P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'">_________________________________________________________<BR><BR>Zetex Semiconductors - Solutions for an analog world.</SPAN></FONT></P><P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><BR>http://www.zetex.com<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></FONT></P><P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'">http://www.zetex.cn<o:p></o:p></SPAN></FONT></P><P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'">_________________________________________________________</SPAN></FONT><FONT color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy"><o:p></o:p></SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy"><o:p> </o:p></SPAN></FONT></P><BR>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list,  email "vrf@agilent.com".  <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".<BR>Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".</BODY></html>  

Outcomes