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 |
|
Robwhittaker
Yak Posting Veteran
85 Posts |
 Posted - 2002-12-09 : 05:11:55
|
| Hi,I've been trying to help somebody out with a problem they have (which is really due to badly written code), however their code is fine running against a V7 database and not a 2000 database, so I was wondering in there has been an enhancement or fix that might have caused this.The app is written in Access froms hanging off a sqlserver DB. If 2 users concurrently connect to the database, and user 1 reads the data from a table, by passing a select string to the database, the table remains locked so the 2nd user cannot update until the first users exits the form. |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-09 : 15:17:24
|
| Can you post the code or query.Have you looked into access data projects.Edited by - ValterBorges on 12/09/2002 15:57:10 |
 |
|
|
Robwhittaker
Yak Posting Veteran
85 Posts |
Posted - 2002-12-10 : 05:41:21
|
| I have suggested a couple of solutions including ADP, I'm not sure what they have decided.I was just confused why SQLServer v7 and 2000 behaved differently.Basically what happens, is the form has a combo box that is populated from the database using basic Access form controls. The same form also updates data in the same table when you hit save.When 2 users logon they can both query the table fine, but when user 2 hits save they can't update the table until user 1 logs out. I believe the update is done by passing a string back to the database. This is only a problem against a 2000 db, it works fine on V7Sorry I'm a bit vague, but it's not my code and so I'm reluctant to put it on the site. |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-12-10 : 10:06:23
|
| A Short in the dark.Try Encanpsulating all the DML in transactionsi meanbegin tran...commit tran-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-10 : 18:59:54
|
| What type of Recordset and what type of Record Locks are you using on the form?Edited by - ValterBorges on 12/10/2002 19:00:40 |
|
|
|
|
|
|
locking differences between v7 and 2000