Error 3146

[ZetecS]

Hi,

I have inherited a two Databases which is pulling sales data from our SQL Server and then exporting the data into a text file.

Now one database works fine but the second one doesn't. It is returning error 3146.

Marco Name: Export Routine
Action Name: ImportExportText
Arguments: 3, ACTSALES Export Specification, ACTSALES, M:\Procast Data\ACTSALESMonth.txt, No, ,

I have triple checked the ODBC connections as it works for one but not the other and I am lost to what it might be.

This works fine in Access 2003 and Windows XP but is not working on Vista with Access 2010

Any help is much appreciated.

Thanks,

 

[DavidAtWork]

When you check the ODBC connections are you able to do the 'Test connection' option and does that work on both, otherwise where in the process does it fall over?
David

 

[ZetecS]

When I test connection it completes successfully. I have made sure it is the same as it is on the computer that can export the database without any issues.

I am completely stumped.

 

[ZetecS]

I found out the issue. Was a data source that was missing. I wasn't told about this one and now that I have added it, it is working successfully.