Hi,

How do I pass and run

set language 'british english'

to sql server from access

Thanks
SmallTime

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

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