Accessing Same Record By Two Users On Different Machines At The Same Time?
Mar 4, 2009
I am developing Client/Server application in Visual Basic 2005 with back-end SQL Server 2005 Database.I have lot a users to access to this application.I have a problem with accessing same record by two users on different machines at the same time.For example: Two user fetches the same record display on the machine.Now both have same data on the machine. The first user modified and saved the record and after some times another saved the data without modified or modifed some other columns. Now the last user who modifed the record contains the old data.
View 5 Replies
ADVERTISEMENT
Jul 15, 2011
I have written a program in VB 2010 that dumps documentation info into an Excel file. Basically, the Excel file is a log file that keeps track of revisions for design drawings at an engineering firm.
There are approximately 20 people that have access to this program. However, I've run into issues where multiple users may be using the program and trying to send info to the Excel file at the same time. The Excel file is set to read only. My program opens the file with write access, and dumps the info into the appropriate cells, then closes the file. If one person is in the process of using the program, it causes an error with another persons system if they try to use it at the same time.
In some cases, it causes my program to crash, and it leaves the Excel file open on someones system.
Typically, my program would only have the Excel file open for a couple seconds. So, the issues mentioned above are rare, but they do happen.
I'm looking for ideas to prevent this issue from occuring.
View 7 Replies
Apr 18, 2009
I hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
View 1 Replies
May 17, 2010
How do I force users to save the current record (if current record has changed) and not let user go to the next record unless the save button is pressed?
View 5 Replies
Aug 3, 2010
I am trying to develop a small application that logs the IP address and or computer names of all the users [my domain or remote location] that accessed files or folders on the server.
View 1 Replies
Jan 4, 2010
I've got a website and we just had a huge jump in traffic. Now all of the sudden we're getting sql parameter errors left and right. We switched to a new sql server a few weeks ago and everything has been fine but the added traffic seems to be breaking us.I have a data access class that is called when each user trys to logon. It runs through several tasks before finally updating the users last login date and forwarding them to the administration section.
What I'm seeing from the trace logs suggests that when I'm logging in the first several tasks are using my data (lets say user=birk pass=word). But at some point the accessor class starts sending over the data from someone else who's trying to login (lets say user=abcxyz).Every connection we make to the server is closed when we're finished with it. I'm nulling out all of the accessor objects when I'm finished with them. But somehow different user data from different sessions are making their way into other peoples instances of the object.
I'm not using session/application/cache/viewstate to store the objects so I'm not really seeing how they could edit eachother... Its just really weird and I'm not sure how to even go about researching the problem.This is roughly the accessor class... I trimmed out some of the parts that weren't reliant to the issue
Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Data.SqlClient[code]......
View 3 Replies
Jul 22, 2011
So I currently have the following:
2 timers
2 labels
1st label is "Clock" this pulls the time from the users current time zone/local time
2nd label is "UTCClock" Which would be UTC time
Now I have this for the first label: clock.Text = Format(TimeOfDay, "hh:mm:ss tt")
Which would give the users current time zone/local time. As for the UTC.. how would I add in for the UTC time from where the user is located at? I did some searches.. but couldnt find what I was looking for.. IM pretty sure its not as easy as getting the users current time zone/local time.. So im assuming that Theres a "bit more" code into getting UTC time..
View 5 Replies
Feb 23, 2011
I am building an intranet site and i want to display the users email(not the complete email), but the subject, from, date and time. However, the first step would be connecting to the exchange server using the NTLM credentials, which are the same, however, i dont want the user to have to type their password to connect to the email.
View 1 Replies
Dec 7, 2011
How to connect client machines with sql server machines ?Vb.Net as front end.
View 8 Replies
May 3, 2012
Imports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
Dim connection As SqlConnection
[code]....
How would I access a specific record and put it into a variable to compare against user input?I have a table CASHIERS and part of that table is a BadgeID and a PIN number. What I want to do is when a cashier swipes there badge to logon to a POS.. it searches the DB to see if the cashier exists. Then, once it establishes that they do exist, it pulls their PIN # and prompts them to enter it. It compares the data retrieved from the DB to the data that they entered.
View 5 Replies
Oct 26, 2009
is there a way to tell if the record is currently open (for editing) by another useregclerk 1 gets recordset for a person. pessimisic lock, client cursor.
View 1 Replies
Aug 26, 2009
i have a sql table which has 2 fields number & name
1 abc
2 xyz
Situation is that the app finds out max of number and increments it by 1 to get new number.The problem is when two users enter some record sometimes two records get saved on same number.
[Code]...
View 4 Replies
Feb 7, 2009
If Users LogIn, I want to cath the time, in what time it start to login...
View 2 Replies
Aug 19, 2009
Is there something like an ftp server that supports multiple users to login?What i mean is that i need something like an ftp server where can login and upload a file at the same time that other 20 users do.(using vb.net code)
'Upload a file to an ftp server
Dim FTP As Net.FtpWebRequest = CType(Net.FtpWebRequest.Create("ftp:myserver.com/file.txt), Net.FtpWebRequest)
FTP.Credentials = New System.Net.NetworkCredential("Username", "Password")
FTP.Method = System.Net.WebRequestMethods.Ftp.UploadFile
[Code]...
View 5 Replies
May 15, 2010
I'm making a speed game in VB.Net (Console Application) and users have a certain time to press a certain key. So how can I give the Console.ReadKey function a timeout without just waiting until a key was pressed?
View 2 Replies
Mar 1, 2011
(First off all hi to everyone my first post!) Ok, i have two programs one program writes to a text file on a consistent basis, while the second program is opening this text file on a consistent basis for reading.. Sometimes the programs are accessing the file at the same time and the user keeps getting this error : this process cannot access the file because its already in use..
Is there any class, in system.io that i can use to modify the settings of this text file so both programs can access it at the same time?
View 2 Replies
Nov 13, 2011
Im Building a auction application and i need to catch the exceptions i.e if two people press the bid button at the same time i need to capture that exception and figure out who was has the highest bidder out of the pair of them then show the relevant message, my question is how can i achieve the above?
View 2 Replies
Apr 12, 2010
I want to authenticate each user every time. in vb 6.0 i used this
Private Sub cmdIngresar_Click()
Dim rs As New ADODB.Recordset
Dim strConsulta As String
[CODE]...
So, my question is how could i modify it for vb2005, because vb2005 don't use recordsets?
View 4 Replies
Jan 12, 2010
I am using VB 2008 and want to record a start date and time and then the stop date and time in a rich text box, i can get the start time into the box but so far can only stop the time instead of 2 seperate times, what i have is a drop down box with a list of computers 1-10 i was trying to get it so you picked a certain computer and that went into the text box then you started the timer and that was recorded, finally you stopped the timer and that was recorded but as i am a total newbie it does not work
Here is the code i have.
Public Class Form1
Dim time2 As Date
[CODE]...................
View 11 Replies
May 8, 2009
No Update to DB?? ***?
[code]
And why isn't there a query to just INSERT a whole record at a time, based on a DataSource, or is that a better kept secret than what REALLY happened during the final hours of the Titanic?
Also, I'm under the impression that the default CommandType is Text.
View 39 Replies
Aug 6, 2009
i would like to have program a timer that will count the seconds during which there is mouse movement or any keyboard movement.
the point of this application is to record the amount of time an employee has been using the computer (does not matter what purpose or application it has been in use for)
i would like to do this in vb.net for winforms
View 1 Replies
Sep 29, 2011
Private Sub MyXbeeZB_XbeeZBIODataSampleRxIndicatorEvent() Handles MyXbeeZB.XbeeZBIODataSampleRxIndicatorEvent
Dim MachineNumber As Integer
For j = 0 To i - 1
If MyXbeeZB.XbeeAddress64 = XbeeAddress64Array(j) Then
[code]....
View 12 Replies
Oct 19, 2011
I am trying to loop through a dataset and process n numbers of records at a time.For example lets say I have around 240 records in my dataset. I need to loop through the dataset and then create a new batch of 50 records. so for the dataset which has 240 records I want to create 6 batches. Out of these 6 batches, 5 would have 50 records and and last batch would have 40 records.
View 1 Replies
Aug 6, 2011
DateTime: what do you use when you need to record Datetimes back in the time before 0001 A.D. (C.E.)
View 11 Replies
Jan 27, 2012
Day Programmers how do i Update the record based on the Date & Time?? here's the code:
[Code]...
the problem is... it's updating but not on time... it's updating in advance... i just want to update it in the date & time that the record has and i'm thinking that it' may affect the other record's that not on time to update
View 2 Replies
Feb 15, 2012
how do i Update the record based on the Date & Time??
here's the code:
Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer2.Tick
lblTimeOfDay.Text = Format(TimeOfDay, "hh:mm:ss tt")
[Code]....
i just want to update it in the date & time that the record has and i'm thinking that it' may affect the other record's that not on time to update
View 2 Replies
Mar 15, 2012
How to create dailytimerecord system in php please please help me...our defense will be on Friday march,16...
View 1 Replies
Jul 6, 2009
I have a backend database in MS access, which is updated using excel as front end. Due to network issues the record updation takes lot of time. Would it be faster if i use VB.net as the front end.
View 1 Replies
Aug 22, 2010
I have been dabbling in VB before and i played around wiht linq to sql back then but im wondering what i should go with here.I need to have a list of people.. They should all have their own id nr.
The people in the list are supposed to keep a record of values changing over time with a datetime stamp. (In my case its numbers from a test outcome of blood)You have to be able to add people and delete people. All records will be deleted too.A Chart will read information from the records and display changes over time in chart.I was thinking of doing it with linq to sql and i was kinda aiming at Creating datatables with id names from the script
Havent found a way of creating datatables from a script though..I was hoping for a solution like that.. And i was hoping id be able to search databasetable names.
View 6 Replies
Feb 9, 2010
I have an asp.net web app that uses forms-based authentication, a SqlMembershipProvider (using an encrypted password format), and a SqlRoleProvider. I need to know if it's possible to administer the users (create new users, assign them to roles, etc.) from a windows application - the powers that be don't want any administrative functionality in the web app itself.Here is the membership provider definition from web.config:
<membership defaultProvider="MyProvider">
<providers>
<add name="MyProvider"
[code].....
View 3 Replies
