Union query of Foxpro tables returns inconsistent results

[catudalg]

Configuration:
Windows 2000 sp3
MS Access 2000 (9.0.4402 SR-1)
Visual Foxpro 9.0 detached tables
MS VFP Driver 6.01.6830.01 06/19/2003

For example, a simple query like:
select * from ddwg1
union all
select * from ddwg2

The query retreives a few thousand records but does not return the same result from one execution to the next.

If I first import the same tables then run the union query on the imported tables, results are ok.

I've tried on different tables with similar inconsistent results.

I've tried to reproduce the problem on a second computer with the following config:

Windows XP sp1
MS Access 2000 (same as above)
Visual Foxpro (same as above)
VFP ODBC driver 6.01.8629.01 12/7/1999 which I downloaded from Microsoft

The same setup produces the following message:
[Microsoft][Visual FoxPro Driver]Syntax error. (#200)

I saw somewhere on the internet that a hotfix existed for that problem but could not find it.

If anybody can help, it would be very appreciated.

Germain Catudal

[catudalg]

Configuration:
Windows 2000 sp3
MS Access 2000 (9.0.4402 SR-1)
Visual Foxpro 9.0 detached tables
MS VFP Driver 6.01.6830.01 06/19/2003

For example, a simple query like:
select * from ddwg1
union all
select * from ddwg2

The query retreives a few thousand records but does not return the same result from one execution to the next.

If I first import the same tables then run the union query on the imported tables, results are ok.

I've tried on different tables with similar inconsistent results.

I've tried to reproduce the problem on a second computer with the following config:

Windows XP sp1
MS Access 2000 (same as above)
Visual Foxpro (same as above)
VFP ODBC driver 6.01.8629.01 12/7/1999 which I downloaded from Microsoft

The same setup produces the following message:
[Microsoft][Visual FoxPro Driver]Syntax error. (#200)

I saw somewhere on the internet that a hotfix existed for that problem but could not find it.

If anybody can help, it would be very appreciated.

Germain Catudal

Additional Note:

I installed FoxPro on the XP machine and now it gives the same inconsistent results as the Win2K.

Germain Catudal