Hi,

I currently have a requirement for access to a SQL Server 2000 box using Access 2003. The queries will sometimes be quite demanding which in turn might affect the rest of the SQL users on the system.

Does anyone know of any setting in Access so that I can achieve the same result as setting the TRANSACTION ISOLATION level using T-SQL?

Any ideas would be much appreciated.

Regards,
Paul.