MS: need your help Report Export

[Guest]

Hi Folks

Access is having problems (with a fully functional report) exporting it to
XML.

Neither a manual Report Export as XML works (nor does the module effort):

Sub RptExport()
Application.ExportXML ObjectType:=acExportReport, _
DataSource:="MyReport", _
ImageTarget:=".", _
PresentationTarget:="MyReport.xsl", _
OtherFlags:=acPersistReportML
End Sub

1. Tried compact and repair (just fine)
2. Imported to an empty .MDB (just the single table and report)
3. The module throws a:

'Run-time error '2950''

and the manual process gives me:

"Microsoft Access was unable to export the data"

This is CRITICAL for me, since I need to import the report into SQL Server
Reporting Services and this is a 'show-stopper' (or spend dozens of hours
hand coding this).

Rob
PS If you are MSFT, I can send u the .MDB (Access 2002, SP-1) for inspection.

 

[Guest]

OK, Access 2002 is broke...

Found a version of 2003 and it works fine.

rob