I am taking over an Access 2000 application from some else who is no longer with the company. There is an application that exports a pipe delimited file. It works in production. I copied the application from production to another computer to test the export process but I am not getting the same results. I have reviewed the attached VBA code and stored procedure many times but couldn't configure how the file is being exported. I didn't see an export procedure or function in the application. Basically it's a VBA procedure calling a stored procedure and somehow the file is created. It seems really illogical. There got to be another procedure somewhere in Access or SQL Server that triggers the file export task. Any tips in Access or SQL Server would be greatly appreciated. I am using Access 2007 to run the Access 2000 application. I don't know if it makes a difference.
Thank you.
Ken