Can someone give me ideals on how to code a function that will create log files each time my app runs and increment the log file name each time it creates a new one. Like so…

0001.log
0002.log
0003.log
0004.log
0005.log

I’m creating a program that pulls data from one database and insert the data into another. Each time a new record is inserted while looping through a recordset, my app will write the insert statement to the log file.

Thanks for any help.

Corey