-
TRANSACTION ISOLATION to SQL Server from Access
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.
-
Tried put 'SET TRANSACTION ISOLATION LEVEL' in your access code?
-
You can check options - advanced option in your access database (in database menu), here you can specify what kind of locking you want. Choices are no locking, locking all, locking edited row.
-
Hi All,
Thanks for your responses.
rmaio: I was looking more for a solution where she could could just turn it on permanently rather than having to remember to put it in each time she writes some new code.
skhanal: I had a look at this and it seems like you can do it for .mdb files rather than connections to a SQL Server box. Is this true?
Regards,
Paul.
-
You are right, for any ODBC connection, you only have choice of row level locking.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|