tnx for your help i have created on how to validate the primary key first before save to database i also got it in the net..but there is instances that duplicate the records
Private Sub checkid()
Dim rsuserlist As New ADODB.Recordset
existusername = False
rsuserlist.Open "select * from tblinfo where idnum=" & Val(Text1.Text) , cn, adOpenKeyset, adLockPessimist ic
If rsuserlist.Reco rdCount...
OBA
Last Activity: Mar 12 '08, 06:11 AM
Joined: Feb 9 '08
Location:
-
OBA started a topic how can I write a small database program, that can be used by several computers?in Visual Basichow can I write a small database program, that can be used by several computers?
I am new to vb6, but I was trying to find how can I write a small database program, that can be used by several computers in 1 location (for example: Office), the problem i encounter is that if the two user press or add at same time the records might duplicate. Also, is there is any networking code that I have to add?
Thank you, -
How To Validate Duplicate Id Number In Client Server?
Hi To All.... This Is My First Try To Create A Program Which Compose A Server And 2 Client...i Use Access Database As My Back End And Vb6 As My Front End...
Problem
1. I Create A Code In Which A User Can Generate Autonumber
But The Problem Is If Two Clients Input Together It Would
Both Save The Data To The Server With A Duplicate And
Same Id Number...
This Is...
No activity results to display
Leave a comment: