Is Excel 32-bit or 64-bit? 64-bit Excel wouldn't see 32-bit VFP OLE DB provider.

BTW 'TABLEVALIDATE=3' is not a good setting. It should be 7 or 15.


>Please consider my ADO connection in an excel vba program that accesses VFP tables frequently and in a variety of ways (all via ADO). (Note that pADOConn is public variable)
>
>

>
>Set pADOConn = New ADODB.Connection
>pADOConn.Open "Provider=VFPOLEDB; Data Source= " & Me.dbFilename & ";Password='';Collating Sequence=MACHINE"
>
>

>
>When I run the program on a Windows 7 (64 bit) pc I get frequent "read errors", that do no seem to appear on a Vista (32 bit) machine.
>
>After I connect this the connection string (in padoConn.connectionstring)
>
>

>Provider=VFPOLEDB.1;Data Source=V:\DATA\PLUCZ\PLUCZ.DBC;Mode=Share Deny None;
>User ID="";Mask Password=False;Cache Authentication=False;Encrypt Password=False;
>Collating Sequence=MACHINE;DSN="";DELETED=True;CODEPAGE=1252;MVCOUNT=16384;
>ENGINEBEHAVIOR=90;TABLEVALIDATE=3;REFRESH=5;VARCHARMAPPING=False;ANSI=True;
>REPROCESS=5;
>

>
>Should be clear by now that I have no idea of what I'm dealing with here, but I was wondering if this could somehow be a setting, or worse a 64 bit issue?
>
>Thanks for any light you care to shed on this.
>
>Marc