Updates From Multiple Users?
Jul 9, 2009
I have a program that uses sql for the database. The issue im having is when two users attempt to update the same record then the update from second user overwrites the record from the first user. I believe this problem comes from the the way i attempt to preserve existing text in the fields.
My thought on whats going on is: If the form has fields A and B. Both users start with a blank form. User 1 adds a record with an entry in field A. When user 2 goes to update the record with an entry in form B, the program overwrites user 1s field A entry with the blank field A from user 2.
Is there a way to force it to grab the most recent data before it tries to add/update? I thought about resetting the digit combo box to the same digit which would trigger the change event for that field. but the issue with that is it would also wipe out the current entries on the form.
Below is the change event for the digit combobox, the main submit procedure, and the subprocedure for one of the days.
[code]
Private Sub cboDigit_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboDigit.SelectedIndexChanged, cboOffice.SelectedIndexChanged, dtEndDate.ValueChanged, dtStartDate.ValueChanged
[Code].....
View 1 Replies
ADVERTISEMENT
Feb 23, 2012
I'm using the Application Updates option in Visual Studio with 'Before the Application Starts' checked.Users are complaining of canceling the update and then finding out they really want the update. When they decide they want to update there is no way for them to update the application until I publish a new version, because once they cancel the dialog box it never shows up again.
Is there a way to create a menu option to force a check for updates?
Kind of off-topic... Are there any open source Application Update programs for .NET?
View 1 Replies
Dec 29, 2010
I am creating a form that creates new users and then updates them to a dataset, I have done this ok, but I am getting a runtime error when I delete a record. Please see below the exception being thrown
"Update requires a valid DeleteCommand when passed DataRow collection with deleted rows"
My code below
CODE:
So I know I need to add a delete command, but how do I write this in code and do I write it in the saveitem click event? I guess I would because the app crashes when I click save to update the dataset.
View 5 Replies
May 9, 2009
In grid there r checkboxes for selecting the records to be updated as soon as checkbox is checked textboxes changes to edit mode. when data is modified and update button is clicked updation should be done to the database.But when update button is clicked its not working.when i checked through breakpoints i m not getting the value for the variable strID.
Protected Sub btnupdate_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles btnupdate.Click
Dim strSql As New StringBuilder( String .Empty)
Dim cmdup As New SqlCommand
For i As Integer = 0 To GridView1.Rows.Count - 1
[code].....
View 3 Replies
Sep 11, 2010
it is possible to do a multiple records editing by linqtosql method in one click event?What I've been trying to do is to edit all the names in the table which are having the same account number.
Private Sub Button2_Click(------------) Handles Button2.Click
Dim accnt As String
accnt = Textbox1.Text
Dim db As New memrecDataContext()
[code]....
Why is it these codes could only edit records in one datarow?Can you debug the codes to edit all records which are having the same account number after it is being query?
View 5 Replies
May 17, 2011
Since ADO.Net uses a 'disconnected' model where the data available to a single program is just a copy of what is in the database, what is the normal way to handle multiple programs needing to update the same table in a database? The problem I see is that a program can't update unless his copy of the data is the most up-to-date. Are we supposed to read before updating and hope that the update occurs before someone else changes the data?
View 2 Replies
Oct 19, 2009
I would like to ask if it is possible to do a multiple records editing by linqtosql method in one click event? What I've been trying to do is to edit all the names in the table which are having the same account number. I was able to edit but only one name has been edited and the rest are not
******************************************************
Private Sub Button2_Click(------------) Handles Button2.Click
Dim accnt As String
accnt = Textbox1.Text
[Code]....
Why is it these codes could only edit records in one datarow? Can you debug the codes to edit all records which are having the same account number after it is being query?if that is possible for you.
View 3 Replies
May 31, 2010
I'm using a SQL database and I'm writing a VB.NET client application. This application is used on multiple computers at the same time. If one of the clients makes an update to the database I would like to have the other clients to be aware of the update.
Has ony one already done this before?
View 3 Replies
Feb 26, 2009
I am on the brink of developping an application for myself and some collegues at work. I will use VB 2005 and SQL server 2000 or 2005.
Here is my question: When I build the connection string do I have to use only 1 database user for all of the users of the application or does each user need to have its own database user in SQL Server?
View 4 Replies
Feb 21, 2012
I need to add multiple users to active directory in vb.net what would be my best way to do this? Although i see some dotnet classes for them its hard figuring this out for my first time. Mostly what must i be aware of when trying to add them? Multiple opinions on the matter would be fine but I really just wish to add users with basic information like firstname and lastname and maybe to specific group.
View 8 Replies
Jun 28, 2011
I have a form which has a textbox named "textbox1", and a button named "Button 1". Button 1 is meant to be a submission for textbox1 (i.e. when button1 is pressed, the value of textbox1 is saved and remembered). I want the value of textbox1 to be remembered on any computer, but I need it to be update-able too. I tried using settings to do this like so:
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.TextBox1.Text = My.Settings.TextBox1
[Code]....
but the problem in doing this is it only works for the current user. When the application is then put on another computer the value is blank.
View 4 Replies
Apr 30, 2012
I know my Question was asked maybe 10000 times before, but i really did not take the chance to search the forum coz i really short of time.
I have *.mdb DataBase with 20 tables each table have more than 10 fields, i'm trying to automate the MDB file from a network like that 5 PCS + One vb.net exe program (5 users) working on the same time on the exe that is connected to the database , my questions are :
1) How much risk is it to put the database into one (shared) folder and connect it to the program ?
2) What is the best way to establish this method ?
3) Is there any alternatives ?
View 4 Replies
Dec 15, 2011
I am developing project in which i am sending emails to multiple user as follows
Dim users(20) As String
users(0) = "xxx@xxx.com"
users(1) ="xxx@xxx.com"
[Code]....
View 1 Replies
Jun 10, 2012
i have a program where the high scores will be saved in a txt file. of course, if the file is already in use, saving the text file won't work. is there an if statement i can do to check if it is in use? or could i check the last access time, and the last modify time and if the modify time happened after the access, i know its closed, and if the access time happened after the last modify time it is still in use?
View 4 Replies
Jun 28, 2011
I have a form which has a textbox named "textbox1", and a button named "Button 1". Button 1 is meant to be a submission for textbox1 (i.e. when button1 is pressed, the value of textbox1 is saved and remembered). I want the value of textbox1 to be remembered on any computer, but I need it to be update-able too.I tried using settings to do this like so:
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.TextBox1.Text = My.Settings.TextBox1
End Sub
[code]....
but the problem in doing this is it only works for the current user. When the application is then put on another computer the value is blank.
View 1 Replies
Aug 22, 2008
I am developing an access database that will be shared with multiple users.I don't want the users to access the database directly so I will have them enter new data on a data access page. The data access page is stored on a Microsoft Share Point web page, and the database is stored on a network drive.Here is my problem: When new data is entered on the web page I need it to trigger a WillChangeRecordset event; however, I have not been successful because the web page does not declare a new instance of a recordset object.At a minimum I need the new data to be processed before the web page appends the new data to the table.
View 3 Replies
Nov 5, 2011
I am developing a Visual Basic .NET application to be used by the staff of a small training centre nearby. The front-end (UI, menus, etc.) will all be in VB .NET, and there will be a back-end database for storing all of the required data, such as student records and meeting information. What I would like to know is if it's possible to use a Microsoft Access database for this purpose, and have it accessible by all the staff in the centre (on the same network) at the same time. For example, would I be able to put the database in a shared network folder, and have a copy of the VB application on each PC that would all be able to read/edit/add to the database?
View 2 Replies
Jan 26, 2009
[Code].....
I got to work and only popup once instead of multiple times. But what Im wondering is It wont do that Unless I run the program AT the same time that is in the Cell. Im wondering if ma7ybe I should creat a new timer for each row then just have a timer constantly reading through the rows and to see what time is in the cell vs. System time or what.
View 1 Replies
Mar 15, 2012
We are four in a team using a data entry application created using VB and MS Access as backend DB. The application is installed on all our PCs, but uses my PC as server. We enter data at same time. The application has been slow since we started using it. We were advised to increase the internet bandwidth, which we doubled, but the application is still slow. What can be done to increase the speed of the application to make work move faster?
View 1 Replies
Dec 13, 2009
Maximized Window Size - For Multiple Users (Computers/Monitors)
View 1 Replies
Jul 12, 2009
Say you have a form that is designed to be maximized on startup. Now, on the programmer's computer (mine), it looks good. But going from user to user, the dimensions of monitors, as well as the resolution each user has on their computer/monitor will vary.Here is the question: If you want to have an application designed to be in a maximized window, how do you ensure that it looks the same on each and every computer/monitor that will be using it. Controls, and everything else that would normally be on the form.
View 5 Replies
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
Oct 24, 2011
I am trying to create a program which will allow users to select multiple files from a list and then burn them all to a playable DVD. It would be wonderful if i could setup a custom menu programatically as well. I have seen some documentation on Imapi 2.0 but i have not been able to find too much suppoert for it. I have also found a few SDK's out there but most are over $1000 which just isnt in the budget.
1) Is there a library included in windows 7 that will allow me to do this.
2) Is there an inexpensive or open source sdk with good documentation out there to do this with
View 4 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
Dec 29, 2010
I've got a code using SQLClient that loops though all users in a Users table inside each loop i want to preform another search in the UserOrders table, thus doing a count of all orders.
I get this error
HTML
There is already an open DataReader associated with this Command which must be closed first.
Here is my code
vb.net UserLists.Items.Clear()
Dim connection As New SqlClient.SqlConnection(My.Settings.ConnectString)
Dim command As New SqlClient.SqlCommand("SELECT * FROM Users ORDER BY PersonName",
[CODE]...
View 3 Replies
Jun 30, 2009
I am writing a program in VB.net (vs 2008) that requires that only one instance of the executable be running at a time. Naturally I went for the simple solution by selecting the "Make single instance application" checkbox in the Project properties. Unfortunately, this option does not seem to work across multiple users that are logged into a single XP machine, thereby causing the same issues for my program as if I were able to run multiple instances on one single user. Granted this is a corner case, that someone would switch users while my program is running, but I'd like to understand the limitations. So my question is whether the "Make single instance application" property is supposed to work across multiple users? or is it limited to only one-instance-per-user.
Here are the steps the recreate the issue (prereqs: computer with XP pro installed, 2 user accounts (not on a Windows Domain), and a dummy "single instance" program created using the property mentioned above):
1) Log in with user1, start up the single instance program
2) Switch to user2 (StartMenu -> LogOff -> Switch User)
3) Start up the single instance program using user2
*After step 3, the program launches without complaint even though another instance is running on user1. Is this a glitch? or by design?
View 2 Replies
Apr 3, 2012
1.I�d like to publish a free vb.net desktop application for the users to download and use meanwhile I�d like to collect usage information ex: user ip address, user�s registration information, used features, time spent� if the user allows the report to be sent back.
2.Also , in order for the user to be able to use the application, he�ll have to register it then, everytime, before the application loads, it gets verified online that it was registered, maybe validate the registration information or a valid user name and password, no critical personal information. The target of this step is for the application to be used exclusively by the registered user and maybe on his computer only.
View 2 Replies
Apr 4, 2012
1. I�d like to publish a free vb.net desktop application for the users to download and use meanwhile I�d like to collect usage information ex: user ip address, user�s registration information, used features, time spent� if the user allows the report to be sent back. 2. Also , in order for the user to be able to use the application, he�ll have to register it then, everytime, before the application loads, it gets verified online that it was registered, maybe validate the registration information or a valid user name and password, no critical personal information. The target of this step is for the application to be used exclusively by the registered user and maybe on his computer only. Any alternative way to achive the target is just fine.
View 1 Replies
Jun 10, 2008
I cannot figure out how to get this call to work.I have searched EVERYWHERE.MSDN is no help at all and the only thing I can find is this vb6 code that doesn't work in .net.I tried to convert it over but I've had no luck.Specifically I'm trying to get the path of the "All Users" Desktop and the "All Users" Start Menu.It would rock if anyone could help me out with this one.
View 5 Replies
Dec 15, 2011
I am currently working with a vb2010 front end with access as the database. everything works for accessing the information adding information. But when I try to edit/update the contents of a row I find that the update is being applied to the first row of the table rather than the target row. i have tried using the ID as a way to specify the row i want updated but that doesn't appear to work.
UPDATE ExamContent
SET Question = ?, ExamsText = ?, [Answer 1] = ?, [Answer 2] = ?, [Answer 3] = ?, [Answer 4] = ?, CORRECT = ?, LastEditUser = ?, LastEditDate = ?
[code].....
View 4 Replies
