Access 2007 ODBC File transfer record duplication

[simian336]

I am using Access 2007 to do an ODBC File transfer, and I am getting record duplication. It works fine in Access 2003. The weird thing is that it is only duplicating some of the records. Foxpro is the ODBC source.

DoCmd.TransferDatabase acImport, "ODBC", "ODBC;DSN=Live Data;;TABLE=", acTable, "main", "main", False

Any thoughts?

Thanks

Simi

 

[SkipVought]

Hi,

Please post in one of the many MS Access forums like forum701.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}