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 |
hornet
Yak Posting Veteran
96 Posts |
Posted - 2007-10-17 : 15:44:53
|
Hi all!I have next issue.There is a table in a db. There are people who work with this table using EM by means selecting needed row and updating this row. Seemingly everything is ok, but when 1 user selects a row from table and works with it EM the rest are being locked and unlocked only after updating first user.How to sort out this issue? Could anybody suggest?thanks in advance! |
|
Kristen
Test
22859 Posts |
Posted - 2007-10-17 : 15:50:48
|
"How to sort out this issue? "Well the simple answer is "don't use EM for this task". It was never intended to be used in this way, it only provides a Grid for data-entry to facilitate Admin-folk to sort out the Raw Data if it ever becomes necessary.Can't your cheap-skate company build a proper application carefully tuned and designed to make it easy for users to maintain the data??Kristen |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-17 : 16:05:57
|
> Can't your cheap-skate company build a proper application carefully tuned and designed to > make it easy for users to maintain the data??a simple win app with a grid and 3 buttons would do. _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-10-17 : 16:07:10
|
... or use MS Access. Works quite well as a simple, flexible, quick, cheap interface to SQL Server (assuming you already have it, of course).- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
hornet
Yak Posting Veteran
96 Posts |
Posted - 2007-10-18 : 02:35:33
|
Answer to all.Yea, i'm thinking over about it. But now i ought to solve this issue and would like to get how to do it.Could u offer a solution? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-18 : 02:38:11
|
I can see two suggestions above.With EM, unfortenately, there is no workaround because you can't change the way locks are initiated by EM.Tell the users to never leave a record in edit mode in EM? E 12°55'05.25"N 56°04'39.16" |
|
|
hornet
Yak Posting Veteran
96 Posts |
Posted - 2007-10-18 : 03:13:23
|
quote: Originally posted by Peso I can see two suggestions above.With EM, unfortenately, there is no workaround because you can't change the way locks are initiated by EM.Tell the users to never leave a record in edit mode in EM? E 12°55'05.25"N 56°04'39.16"
I haven't catch what do u mean about users. Could u explain? |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-18 : 03:17:39
|
An EM solution is pretty scary IMHO. No Undo ... so easy to accidentally change a value on the wrong row ... |
|
|
|
|
|
|
|