Hi, Tnx for that, however it is not company policy to have SQL Server installed onto client machines, so which DLLs would I need to ship my app with inorder...

Well thnx man but this works the same as application.displayAlerts = false. They both do what I want them to do but, they still open the fileOpen dialog box, with...

Andy, you deh man, thnx a lot for sharing your knowledge.

This has worked for me, if you must keep this TempRX_NDC table otherwise using #RX_NDC as a temp table is better if you don't wanna keep the temp table.

INSERT INTO...

The reason I want the new column before the last one is the the last column is a Reporting_Date field and it MUST be the last field of the table

...

You deh man! Tnx it worked man. Thank you

Just to make something clear.

I know how to change the default language of a login. But I wanna make this change permanent such that whenever I run SELECT @@LANGUAGE I...