Record locking in Access and SQL Server

This is a discussion on Record locking in Access and SQL Server within the ODBC forums in Framework and Interface Programming category; Hello, I'm using VB6 as a front end and Access/SQL server as the backend database I wish to know what is the best technique to use when locking and updating records. Do you have to trap an error when two or more users try to update the same record? Regards, Mario Chertub...
Go Back   Application Development Forum > Framework and Interface Programming > ODBC
Record locking in Access and SQL Server Record locking in Access and SQL Server

Object Mix

 Register FAQ Calendar Search Today's Posts Mark Forums Read
Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 01-11-2004, 11:25 AM
Mario Chetcuti
Guest
  
Default Record locking in Access and SQL Server
Hello,

I'm using VB6 as a front end and Access/SQL server as the backend database

I wish to know what is the best technique to use when locking and updating
records.

Do you have to trap an error when two or more users try to update the same
record?



Regards,


Mario Chertub


Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode


All times are GMT -5. The time now is 06:41 AM.

Privacy Statement -

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vB Ad Management by =RedTyger=

In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.