How do I run script on sql server from Access

[SmallTime]

Hi,

How do I pass and run

set language 'british english'

to sql server from access

Thanks
SmallTime

 

[pdx_man]

You must use a pass-through query to run TSQL statements directly on SQL Server.

 

[SmallTime]

Thanks for this.

I was struggling a little before I realised, or discovered, that I should set record returns to 'No' before it would work. All is well now after some time fumbling around.

Thanks for the reply though.

SmallTime