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
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