Run-time error 2282 - DoCmd.OutputTo....

[demoman]

I have the following line of code in my VB6 app..

objAccess.DoCmd.OutputTo acOutputReport, strReport, acFormatSNP, "U:\reptmp.snp"

It works on most Workstations, but not on others. The error is:

Run-time error '2282':

The formats that enable you to output data as a Microsoft Excel, rich-text format, MS-DOS text, or HTML file are missing from the Windows Registry.

I am referencing the Access 9.0 object library in a Win2K SP3 environment. The Workstations have Access 97 installed with Office 2000 (backward compatibility for an old legacy app). I thought the issue might be using the 'acFormatSNP' argument, which is not supported in Access '97. But it does work on most machines, so????

Microsoft reports the error is raised because of an invalid path, but that is not the case.

Any ideas?


Run-time error '2282':

The formats that enable you to output data as a Microsoft Excel, rich-text format, MS-DOS text, or HTML file are missing from the Windows Registry.

 

[cghoga]

Is every user's U: drive mapped to the same server? If not this would cause a problem. If this is the case use the name of the server (instead of the drive letter) in the file path.

Hope this helps.