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

Attached Files

	gc_prenote.txt (12.0 KB, 12 views)
	Access_code.txt (2.6 KB, 11 views)

I would start by making sure you do not have any bogus MISSING reference issues.
http://www.btabdevelopment.com/main/...1/Default.aspx

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

I've checked the references and there aren't any missing.

The stored procedure looks like SQL Server or something and I haven't a clue, sorry.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"