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 |
|
muhiar
Starting Member
37 Posts |
 Posted - 2005-12-20 : 05:50:59
|
| hi alli have problemi have changes my database from ms access 2000 to sql server.now i am trying to test my application which is in ms access 2000 so that it works with sql server database instead of ms access one.i have a query in my application (ms access )update t1 set f1 = 0;when i run it the following error appearmicrosoft access can not update all the records in the update querymicrosoft access did not update 0 fields due to type conversion failure,0 record due to key violations 1 records due to lock violations.any idea how can i solve it??thnx |
|
|
muhiar
Starting Member
37 Posts |
Posted - 2005-12-20 : 05:55:53
|
| i have notice that this field is being updated with the value but why??? |
 |
|
|
muhiar
Starting Member
37 Posts |
Posted - 2005-12-21 : 01:24:20
|
| hi alli still need answer is this problem in sql server side or ms access??it is urgent |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-21 : 01:26:32
|
| run the same query in SQL Server via the Query Analyser. What do you get ?-----------------[KH]Learn something new everyday |
|
|
|
|
|
|
lock violation