Impromptu locks when saving as text

[KellyK]

After I run a report, I go to File, Save As: and attempt to save the data as .csv with no success. The status bar increments up to around row 700 and then it hangs indefinitely. I have tried saving as a .txt as well. I know it is not a space issue. This is the only report that causes this problem and it happens every time I attempt to save. I am at my wits end but don't want to go through the trouble of creating a macro to do this when I'm not even sure that will work. Does anyone have a clue about what might be going on here?

Kelly

 

[mfgf]

Hi,

Do you get the same problem if you go to the query dialog, onto the Access tab, uncheck 'Retrieve only the required rows', then run the report again (report/retrieve)?

Just wondering if it's a problem retrieving the data for the report if you fetch it all, or if it's specifically to do with saving as csv (or txt).

This might help you narrow it down a little - let us know what you find.

Regards,

MF.

 

[KellyK]

Thanks for the help, MF.

For some odd reason, when I checked the "Eliminate Duplicate Rows" box and reran the data, I was able to save as .csv. I'm not even gonna question it.

Kelly