Wrox Programmer Forums
|
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 13th, 2004, 03:24 PM
Authorized User
 
Join Date: Oct 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jolzy
Default ado multi user

Hi

Anyone knows how to detect there has been modified the record?


I am trying to develop a multi user application with VB6.
using ado with msacess
and I like to if there is a way to tell the user that the record they trying to update it has been modified another user

thanks :)

 
Old October 20th, 2004, 07:59 AM
Friend of Wrox
 
Join Date: Sep 2004
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Anantsharma Send a message via Yahoo to Anantsharma
Default

HI,

Well u can Lock the ADO recordset using AdloclPessimistic / AdLockOptimistic if u want to prevent clashesh in multi user. But if its your need to know if another user updated the record, u have to come with a little tricky way.

U can maintain a state variable in table itself and whenever a record is updated, update the state colum also. Whenever a user pick the recorset, he will pickup the state colum value. Anytime a user attempts to update, u compare the value of the state colum in recorset and table, if its same then no one has updated,else its updated......hope u got my point.

Gud luck

B. Anant
 
Old October 20th, 2004, 09:04 AM
Authorized User
 
Join Date: Oct 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jolzy
Default

yes I thought of that but I was nont sure about it
Thanks
:)






Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Multi User Help Delvo Pro VB 6 5 February 26th, 2008 02:44 PM
How to program a multi-user app James Diamond Classic ASP Databases 1 February 2nd, 2004 11:48 AM
How do I program a multi-user app? James Diamond Classic ASP Professional 1 February 2nd, 2004 11:47 AM
How do you make a database Multi-User mikef Access VBA 3 July 3rd, 2003 10:00 PM
Application multi-user password. mosart VB Databases Basics 2 June 16th, 2003 02:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.