We help IT Professionals succeed at work.

Access 2007 runtime error 2950

I have an Access 2007 application which performs an Output to Excel Macro.
It works everywhere but runtime where I receive an error 2950 and a message saying "The command or action output to isn't available now". I have enabled content prior to compiling or creating a runtime.  Funny thimg is (not really so funny) that it was running fine in runtime until I add more code to other non-related parts of the system.  It still works everywhere except in runtime.  I have run the macro on XP, Vista and Windows 7 as a runtime  until I created a  new runtime.  Any suggestion will be appreciated.
Comment
Watch Question

Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
What other code did you add? If it was working previously, and you added code then obviously that code is causing some issues.

Do you have full error handling enabled on your application?

Author

Commented:
Solved it by deleting the OutputTo code and re-entering.  Something must have gotten corrupted.

Author

Commented:
The issue continued when attempting to execute the macro from a runtime version on a VISTA machine.  I would like the issue to be re-opened.  Sorry for the confusion here.  I'm new at experts-exchange.

Shelties
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
The error you're getting is somewhat generic and doesn't really point to anything specific.

On the Vista machine, where is your database installed? What folder?
Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
Also, can you post the code that throws the error?

Author

Commented:
OutputTo      Table, Vendors, Text Files (*.txt), C:\Vendors.txt, No, , 0, Print

Folder = C:\

I changed the Xls to  .txt   This works in Runtime with XP but not VISTA the error I get is :
Can't save the output data to the  file you've selected
Then it refers to open files and permissions

Author

Commented:
Took some time, but I found an error in the code.

Thanks.