Recent content by mikej28621

Your a genius. Thanks M

Not sure about the problem. I just recreated it with: makecert -r -n "CN=test 2004" -b 01/01/2000 -e 01/01/2099 -eku 1.3.6.1.5.5.7.3.3 -sv test.pvk test.cer cert2spc test.cer test.spc pvkimprt -pfx test.spc test.pvk I left the password blank and took the defaults for all the rest except I...

All I have are Visual Basic for applications microsoft excel 10.0 object library ole automation microsoft office 10.0 object library microsoft forms 2.0 object library microsoft ActiveX Data Objects. 2.0 library These are fine unless you distribute to people with older versions of Excel...

I assume you double-clicked on the .pfx file and installed it. From there open Outlook then Alt-F11 to open the VBA interface. Go to TOOLS>DIGITAL SIGNATURE select the certificate from the browse button and OK it and close the VBA interface. Close Outlook and reopen it. It may prompt you to...

PS once you get a .PFX file then you can just double click on it to except it. Then in VBA interface go TOOLS>DIGITAL SIGNATURE select the certificate and save the file. Close the file and reopen it. When prompted check "Always turst macros from this source then click Enable Macros...

From what I remember and my notes basically 3 steps. (fill in with your own info and file names - run from command line) 1. makecert -r -n "CN=Your Name" -b 01/01/2000 -e 01/01/2099 -eku 1.3.6.1.5.5.7.3.3 -sv selfcert.pvk selfcert.cer 2. cert2spc selfcert.cer selfcert.spc 3. pvkimprt -pfx...

Your goal is a certificate that you can install. It will be a .pfx file. Look at this page. http://www.source-code.biz/snippets/vbasic/3.htm M

Ron, Here is one of my own examples.... Dim cn As New ADODB.Connection Dim cnstr As String Dim CurrLib, ipadd As String ipadd = "192.168.1.1;" CurrLib = "lib1" cnstr = cnstr & "DRIVER=Client Access ODBC Driver (32-bit);" cnstr = cnstr &...

Cha Ching..... Ron checkout http://support.microsoft.com/default.aspx?scid=kb;en-us;124218 Sample 8: Using Long SQL Query Strings NOTE: There is a maximum limit of 255 characters in a SQL query string. You may also receive GPFs if the length exceeds 127 characters. Use the method below to...

Ron, Sounds like no matches to your query. Did you get an error or just no records? Did you go to the 400 and do a STRSQL and paste your query there. That will tell you. Any query that returns an answer there should work from ODBC. M

skarosi, Check out http://www.w3schools.com/ado/ for some good examples. M

Post more code and check out http://www.w3schools.com/ado/ M

Check out http://www.w3schools.com/ado/ M

comconrk, any luck? M

Oops That was STRSQL.... M