With Microsoft. Jet. The OLEDB. 4.0 generation of DBF file name only 8 digits,
After 123456789 ha. DBF file becomes 12345678. DBF
Guidance,

Dim conn As New ADODB. Connection
Dim dbfRs As New ADODB. You
Conn. The ConnectionString="Provider=Microsoft. Jet. The OLEDB. 4.0; Data Source="& amp; The data catalogue & amp; "; Extended Properties dBASE of=5.0; User ID=Admin; Password=;"
Conn. Open
Conn. Execute (joining together to create DBF file statement)

Has been installed VFP9.0, before rebinding system is normal, after installed system appears the question,

Windows 7 64 bit, the system before and after reshipment is done with the same GHOST file

CodePudding user response:

DBASE database is the DOS era, only support 8.3 filenames very normal ah,
If you want to use VFP9.0 data files (and make sure it is support long file names), should use the

 conn. The ConnectionString="Provider=vfpoledb; Data Source="& amp; The data catalogue & amp; "; Collating Sequence=general;" 

CodePudding user response:

reference 1st floor Tiger_Zhao response:

dBASE database is the DOS era, only support 8.3 filenames very normal ah,
If you want to use VFP9.0 data files (and make sure it is support long file names), should use the

 conn. The ConnectionString="Provider=vfpoledb; Data Source="& amp; The data catalogue & amp; "; Collating Sequence=general;" 

Other computers can normal use, this two days appear this problem again,
Computer for myself after reshipment system appears the question,,,, now use MSSQL2000 DTS export file name also limits 8 characters

CodePudding user response:

Suggest filename less than or equal to 8 characters, and don't use Chinese