hi!
I have an Access front-end with SQL Server database. I want to change the isolation level in SQL Server to serializable from Access, not to be able to insert while another user is selecting (reading).
I tried making a store procedure just to: "set transaction isolation level serializable go" and call this one with a pass through query in Access.
but, where do I put begintrans, commit and rollback?!
even if I set this level I can still insert from Access in the same table while another user is selecting.
any ideas?!
thanks!
I have an Access front-end with SQL Server database. I want to change the isolation level in SQL Server to serializable from Access, not to be able to insert while another user is selecting (reading).
I tried making a store procedure just to: "set transaction isolation level serializable go" and call this one with a pass through query in Access.
but, where do I put begintrans, commit and rollback?!
even if I set this level I can still insert from Access in the same table while another user is selecting.
any ideas?!
thanks!
