Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-10-08 : 12:13:21
|
| If i use microsoft access to query sql and i do an update in SQL Server when using access it has to wait until the sql is completed.Does any one know how to connect to microsoft access with a transaction isolation read uncommitted so that i can still read the database whilst an update is in process.This thread works for all other queries and updates etc http://www.sql-server-performance.com/articles/dba/isolation_levels_2005_p2.aspx |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-08 : 21:33:01
|
| Try put SET TRANSACTION ISOLATION LEVEL at beginning of your code in access. |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-10-09 : 10:22:22
|
| The users just click on the tables rather than doing any select statements, is there a way to do it at the ODBC or even better have SQL OLED for access . |
|
|
|
|
|
|
Isolation