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