read isolation levels

[TRBLUE]

Is there a way to use ms access 2003, 2007 with read uncommitted record so that it does not lock SQL with updates.

Anyone know of a way to set this up.

We currently use sql replication and rather not have to use this.

For example if im in SQL doing mass update and open up table in access i have to wait until update has finished then i can view the records in access....

Sometimes if access got the record sql can't update either this causes blocking in sql.

Thanks

 

[Remou]

Whose SQL? SQL Server, Jet SQL, MySQL ...?

 

[TRBLUE]

SQL 2005

 

[Remou]

It seems you need a passthrough query. You should be able to get more information in the SQL fora, for example forum183.