Exporting table to XML incomplete

[ths]

Hi,

I have a database with 8 tables, and I need to export each as an XML file. 7 out of 8 XML files export ok. With one table, the XML file only includes 2,613 records, while the table in the database has 27,561 records.

Any idea what's causing this? I've exported this table successfully in the past, and there have been no changes to the table design that I'm aware of.

I've tried exporting it using the following methods:

1. External Data>> XML file>>[local drive]>>data only (confirmation message says export was successful, but file is incomplete)

2. using VBA to do the same: DoCmd.RunSavedImportExport("exportname") (again, success message)

3. using VBA to do the export directly: Application.ExportXML acExportTable, "tblPeople", "c:\xml_exports\tblPeople.xml" (and I get my personalized success message here, of course)

Any suggestions greatly appreciated.

 

[ths]

update: the trusty compact and repair utility appears to have fixed it. It's off now by only 4 records, which I'm attributing to users modifying records.

Still unclear why it happened in the first place, which I find unsettling.

-Tim

 

[ths]

happened again, but I figured out the problem: there was a record that had an ID but nothing else, and once I removed that record, export numbers matched the db numbers.

just in case others search for this issue....

 

[jdraw]

Thanks for reporting the solution you found.