error report table

[reddogheat]

Hi,

I am exporting a linked table to a text file. I have approx 1,000,000 records.
During the export, access creates a table of errors. The errors are not a problem, but i do not want access to create the error tables as the export is done several times a day.
Does anyone know how i can stop these tables from being automatically generated?
Many Thanks
Phin

 

[boblarson]

Does anyone know how i can stop these tables from being automatically generated?

No, but if you run the export via code on a form you can use the event to also delete any of those tables.

 

[reddogheat]

Hi Bob,

Good thinking. Problem solved.

Thanks Phin