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 |
|
fan
Starting Member
10 Posts |
 Posted - 2004-06-18 : 02:34:18
|
| Hi allI am using ADO+VBA together with SQL SERVER2000.If there is a recordset I want to upload onto server, how do I make sure there isn't any issue in a multiuser environment. What I only did is:set up all the values of each field in recordset then myrst.updateIs that OK? Or we need write and call a SP including sth like rollback?Appreciate your help |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-06-18 : 11:09:09
|
| I usually never give answers like this but this time I can't help myself: take the time to learn some proper SQL! Using the ADO-commands for inserting/updating/etc is a serious performance-killer and you should avoid it if you can. Unfortunately I don't know too much about them other than this so I'll give you this link instead. Hope it's useful:http://www.w3schools.com/ado/default.asp |
 |
|
|
fan
Starting Member
10 Posts |
Posted - 2004-06-23 : 08:16:48
|
| Thanks for your reply.Yup, ADO is much easier for me than SQL. But could you give me some hints if I don't apply ADO commands to manipulate database, any other kind of way I can do? I know a bit about sp, can I just pass all the values as parameters, and run a sp to do inserting/updating/etc. So I can 'rollback' to solve the multi-user problem, rite?Appreciate any help from anyone |
|
|
|
|
|
|
Multiuser and ADO