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?
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 RepliesI 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 RepliesI'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]...
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].....
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 RepliesI 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.
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 ?
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]....
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 RepliesI 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.
[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.
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 RepliesMaximized Window Size - For Multiple Users (Computers/Monitors)
View 1 RepliesSay 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 RepliesI 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.
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
I've been looking all around and i have not found a appropriate solution for my question.Here it is. I've a database table which has the field "username" and "password" and within the "username" field, there would be users like "admin","cashiers" etc. I would like to generate a login page using php that actually detects what are the users logged in as. additional info: I'm using Flash, php and MySQL. So i would just need the solution to how am i to detect.
View 3 RepliesI Created a database in SQL Server Management Studio(2008 R2) And The server name . Is When I installed the software on the user's system software can not connect to database? But I can not underestand that What is needed for installation on user systems.
View 6 Repliesusing the sql server management studio we can create users to access the database. so we can grant several privileges as well as revoke some. so i want to create a login form with those user's. how to do it. is there any other way [code] in the connection i have to mention the user also.. is it possible. if its possible.
View 1 RepliesI'd like for my application to have a listbox displaying all users currently connected to my access database stored on a server. Also, it would be nice at startup for a message box to pop up saying something like "Other employees are currently using this application. To view active users go to..."
View 3 RepliesI have a vb.net web application and when a particular function runs , i get data timeouts in the rest of the application..(ie..row not found errors or column does not belong to table but it does) The function is adding multiple rows in multiple tables in the database and is running in a for loop. It seems to be all SQL related but I am not seeing anything in the error logs in SQL or in the application Right now I am assuming it is memory related where to start note..the for loop will be replaced with a bulk insert but right now I jest need to resolve the issue of the timeouts
View 1 RepliesI am using the Mysql .NET connect and can connect to my database using my program. i want to be able to get a Users Password from the database using there user name
This is the query i want to use: "SELECT Password FROM staff WHERE Username = " & textbox1.text & " '". But i don't know how to run that query and to get it to store the Password as a variable
Do users of windows applications have to have the database application installed if your program uses databases to store information? For example, when making VB2008 programs, if I use the visual studio express database (.sdf), or maybe a MSAccess database, to store information within my visual basic program...when I deploy the application to the users, can they run the program okay even if they don't have MSAccess installed on their computer?Also, do I need to have MSAccess installed in order to write programs that use MSAccess databases?
View 1 Replieshow to authenticate users with the SQL Server database table using VB as a web service. I managed to connect to the SQL server via this VB code;
Public Sub ConnectToSQL()
Dim con As New SqlConnection
Dim cmd As New SqlCommand
[Code].....
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].....
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?
The application must have basic functionality as to: Insert new customers into the database A search function will be needed to find a users criteria entered The more advanced features would include matching certain criteria with another for example if the data in field 1 is the same then it should match this and return the results. so for example if a person has a hobby of 'football' it will return all the people with the same hobby
View 4 RepliesI have a form in which I am updating records to table Users in database China.accb. The btnClick sub successfully updates the Dataset. However, the actual table Users never gets the update. What am I doing wrong? The code is below.
[Code]...
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.