Results 1 to 5 of 5

Thread: TRANSACTION ISOLATION to SQL Server from Access

  1. #1
    Join Date
    Apr 2005
    Posts
    6

    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Tried put 'SET TRANSACTION ISOLATION LEVEL' in your access code?

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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.

  4. #4
    Join Date
    Apr 2005
    Posts
    6
    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.

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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
  •