DB/Reporting :: Database For Multi-user Application
Jan 28, 2011
i just want some opinnion or suggestions regarding database softwares. we are going to develop a system for 20 or less users, i am planning to use MYSQL community server as our database to lessen the budget for that system, i just want to know if it is ok to use that version.is there a big differece between mysql community server, enterprise server and MS SQL Server in terms of handling data i.e security, speed, etc...
View 2 Replies
ADVERTISEMENT
Mar 26, 2009
I'm using SQL 2008 Express with a multi user VB.NET Windows application. Do I have to add each user to the SQL user account? Does NT AuthoritySYSTEM work? I do not know how this works. So far I have NT AuthoritySYSTEM in the Security-Logins of the Server. But do I have to add it also in the database? In the databse Security-User, I have the following:
[Code]...
View 1 Replies
Mar 17, 2009
I'm working on a multi user VB.Net windows application with back end as SQL Server 2008 Express. The SQL Server is installed on the intranet network drive. This is the connection string I will be using. Is this correct?
Data Source=.SQLEXPRESS;AttachDbFilename=Q:DatabasePrintDB.mdf;Integrate d Security=True;Connect Timeout=30;User Instance=True
View 3 Replies
Dec 7, 2009
how to make an application with a multiple user.
language: VB
resource: Visual Studio 2008 Pro(90-day trial)
Sql express (the packages when u download the VS 2008)
scenario: i will make database located in a server (LAN) and a multiple client that can access the server database to add,modify,delete records.Im not aware that building a multi-user application database is different from a normal one user application database. T_T.i read some guide and other walkthrough on building a database but it became confusing when it doesnt my requirements. coz when i try to open my database(.mdf) to connect from other client (in another station) it says its currently in use and connot connect to it. err. @_@..
View 3 Replies
Aug 26, 2009
I am designing a fairly small application to manage a waiting area for a clinical department. There will be a receptionist who books appointments and updates exisiting appointments to say that a patient has "Arrived". In seperate rooms will be nurses who call patients who have "Arrived" and update the appointment as "In Session" and finally as "Discharged". The appointments are viewed in a flexgrid with nurses across the top and time down the left, patient names are displayed at the relevant times and the cells are shaded a colour to represent the current appointment status ("Booked", "Arrived", "In Session" and "Discharged").
I am using SQL Server as the back-end and Visual Basic 6 (I know) as my front-end.I have been told that there will be 2 or 3 nurses plus the receptionist logged in to the system but I would like to cater for growth.My question is what is the best mechanism to use in order to reflect the status change made by one user on the screens of the other users currently logged in?
I have been thinking about using a timer to refresh the data at a set interval but I do not want to keep hitting the server excessively (although what is considered excessive? we would be talking about a call for data every 60 secs per user). Plus the server could be serving data for many other applications so this is another consideration.Alternatively I have been thinking about sending some kind of message via Winsock to the other users notifying them of data changes as they happen. I don't have a lot of experience with this and am concerned about clients not receiving messages and users seeing old data. It also seems strange to me that once the days appointments have been retrieved from the database that "in theory" a client could go the whole day without having to query the database again to pick up changes - kind of scary.Some information on the data:We would probably be looking at around 100 appointments per day We capture patient name, date of birth, date and time of appointment and appointment status.What is the standard approach / best practice for this kind of scenario?
View 6 Replies
Mar 10, 2009
I have finished coding a VB.Net application that has connection to SQL Express 2008 database. My question is, what steps do I have to take to make this a multi user application.
FYI:There are 3 tables in the database of which two tables contain data to be viewed by the user and one table is to insert records by the user. The former two tables will be edited by the administrator only. So there is no issue of concurrency. But the one table that is used to insert records by all users has to be dealt with.
View 11 Replies
Sep 18, 2009
I am new to programming. I know how to create simple windows app using VB and Sql Server/AccessDB. My question is this: Can my windows app be ran on a LAN or do I have to create a special multi-user app for a LAN? If the answer is yes, can someone please guide me on how to create a LAN/Multi-user app.
View 2 Replies
Feb 19, 2009
I need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it? Please give me a start up.
View 6 Replies
Apr 11, 2009
I want to about a multiuser application that have a server and 2 or 5 client to interect with mssql thorough application. how multiple cleint connect to database in same time.
View 4 Replies
Jul 29, 2009
I have been trying for years making a network app.I need linked to a video or something, mainly on msdn or some microsoft site, because youtube created videos for coding aren't all that helpful as most of the microsoft made videos.
I need not linked to things like multi-user tcp chat application, as i have looked at these, and even found no code solution, but the no code doesn't allow too much customization and hard to deal with data received to make your own commands send and receive and have events for them.
The multi-user tcp chat application, it doesn't explain anything, just gives you the code for you to look at, and well, it's hard to understand.
I WANT TO MAKE THE PROGRAM BEFORE MORE YEARS PASS BY.
View 1 Replies
Mar 2, 2009
give me some example code to insert rows of datagridview into a sql express database table? Also, how do I manage concurrency as it is a multi user application?
View 6 Replies
May 11, 2011
How do I make a multi user database?
Give me the logic, how do I achieve it?
For example, what file should the database be, where should I put the database(I prefer on my server), how do I encrypt the database.
Can I make it in columns? Username column and password column? My application then finds if any username match to the username inputted by user in my UsernameTextbox.Text then see if the inputted username and the password from PasswordTextBox.Text matches.
For now I'm using the If statement for both username and password. I have to write the same code again again for new users.
View 10 Replies
Jul 25, 2007
I am developing a VB.Net application. That application might be working on a LAN. MS Access as a backend will be used.
I have developed many single user applications, but don't know of multi user , LAN, manage DB etc. How do I make the program as Multi user on LAN. Data will be accessed at the same time. How to mange such things.
View 5 Replies
Jan 8, 2010
Someone gave me a link to a Multi-User TCP Chat application once, but, there is a flaw in it, where it wont do special characters, such as Alt+1 will become a different character to the server than the one that was sent. Even I tried to see if the output was usable but it sees it as multiple chars, when it is only 1, and I can't find a link between what it sends and what the character is, so I can't just tell it based on whats sent what the char is, because I see no relation, I would have to type it out for each and every special character.
View 2 Replies
Feb 19, 2009
I need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it?
View 4 Replies
Sep 17, 2009
I have developed an application using vb.net. This application will run on approximately 15 machines at the main office and also roughly 10 machines spread over 3 different locations. I am using SQL Server Express edition in the backend. I deployed the application on the network using caspol but it is extremely slow. The Company Manager's perception is that because a script will invariably have to be deployed on each client machine to configure CASPOL, that the solution is not viable.
What is the best method to develop and deploy a multi-user desktop application?
View 9 Replies
Apr 6, 2011
I've been trying that example application at [url]...
I'm just using the client part to connect to an exiting server application. It works OK up to the point where it appends text into the[code]...
View 2 Replies
Apr 27, 2012
I have been using access for my applications from over 4 years now. I realize its time to move on now and i need suggestions for a new database. Here are my requirements :should be able to connect it with Vb.net windows form frontend GUI - all database functions such as add/delete/edit/update will be done through the vb.net front-end only.Should be able to place the db on LAN and each client on the LAN can then access the centrally stored db through their individual front-ends.At the most 5-6 users will be reading/writing to the database at the same time , so the database should not crash or slow down Since i come from MS access background, i would like something thats similar to it so that i can learn and adapt to it quickly.Not very important, but i think its worth mentioning. This db will be the main central db for my .net application.My .net application will also be interacting with quickbooks and magento via some apis but ultimately all this data will go to the central db. So just curious, will there be any compataibility issues with the database that you suggest Should handle about 10 tables and around 10k records in each table Should be secure - just that i should be able to lock it up or anyhow prevent it being accessed from anywhere else other than the vb.net front-end.
Lastly, I would prefer it to be free to use if possible but not essential. I realize there are some topics like mysql vs sqllite and on databases, but pls understand i need suggestions for one that will be apt for the purposes i have listed above.
Edit : Just curious - Would i pushing the limits if i still stick to access - i understand access won't be good for multi-user access but i guess 5 users is not much ?
View 3 Replies
Apr 7, 2011
Our engineers use an application developed internally to perform risk assessments at a customers site. Sometimes on larger jobs a group of engineers will all carry out risk assessments together and will all need access to a single database file to all work on at the same time.
[Code]...
View 7 Replies
Jun 2, 2011
I want to learn the Database application programming. Especially, the multi-user environment. User can update the data at the same database. So, could you give me some advices ? Does it should use SQL server db ? How to connect with the the SQL server from other PC user ?
[Code]...
View 1 Replies
Jul 10, 2009
I'm building a multi language application, but in the application, there will be some data that will be retrieved from the db. In the db I have two tables (Access Groups, Teams) the two tables are related, there are some groups, that have teams, example (sellers can belong to team 1, team 2, team 3...). The data that will change it's the names for the access groups and the names for the teams. The only way that I can think to do this, is to have the different values for all the languages in the code, or some auxiliar file, and when loading the application I'll truncate the two tables and fill them with the current language values. By the way those values never change...
View 5 Replies
Apr 25, 2010
I am using VB.net 2003. I am working on a stand alone windows program that stores data in an Access database via ADO.net via MS jet 4.0 OLEDb. I have progressed to the point that I would now like to provide the end user the oportunity to back-up the data they have stored and re-install if they choose. I am envisioning a menu item for "maintenance" with sub-items for "back-up" and "restore"
View 1 Replies
Feb 29, 2012
I created an executable file of an application done in VB Express 2010 which connects to a Access 2010 database. When installling the executable file at one of the user's computer, the file is installed correctly, but it fail's when trying to connect to the database. It says that Microsoft Dataengine cannot open the database. The user's computer doesn't have Access installed, does it need to be installed? or can I install a framework or application to avoid installing Access at the user's computer?
View 8 Replies
May 2, 2008
Alright, let's try this again. I have an mdb file as a database in my program, I need this mdb file to be what my published program reads off of. Is there any way to have Visual Basic (2008 Express) not encode my mdb file to Example.mdb.deploy?
View 1 Replies
Jun 23, 2009
I 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
View 3 Replies
Oct 30, 2008
Here's what I'm attempting: The user browses for and opens a dbf file. The user is presented with a checkedlistbox which shows the column headers. The user then selects the columns they wish to run a report on. ex. total # of cells not empty, longest cell length, etc.
I'm to the point of populating the checkedlistbox with all of the columns shown but I'm unsure if the users selections are actually linked to my data and if they are how I go about isolating said selections for the reports. I have a feeling that my approach to populating the checkedlistbox is not the proper way for what I'm trying to accomplish.
Here is the code
Public Sub btnGetFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetFile.Click
Dim fileLookUp As New OpenFileDialog
[CODE]......................
View 2 Replies
Apr 9, 2008
A portion of my code is below. I am making a database application using FlexGrid and an ADO Control. I get errors on the statements following .saying that "Overload resolution failed because no accessible 'Fields' accepts this number of Arguments". Can someone explain this error and also a fix for it? I am using Visual Basic 2008.
[Code]...
View 1 Replies
Jan 20, 2011
In vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
View 2 Replies
Sep 10, 2008
I have been reading books and the forums for a rew days now trying to work out how to use any control to carry out the following:Basically, I want to display a selection e.g "Club Name" in a combobox (or similar control) and have the ID of that selection in a separate hidden column e.g. "ClubID". This will allow me to easily reference and store the actual "ClubID" in the required record when I save it back to the database.I can not use the "SelectedIndex" property of the control as the combobox is populated from a 'sorted' stored procedure so the "SelectedIndex" does not match the actual index of the selection.
I have found lots of posts saying use the "ListView" control, but none of them actually show examples of how to bind the control to a data control to acheive what I need.What I am after is a turorial showing ADO code (because I want to hard code this to get a better understanding of how it all works) binding a multi-column control to a SQL database.
View 1 Replies
Oct 19, 2009
Suppose i have made a single user program that receives its data from a database on a SQL server. What things do I have to change to the program to make it a multi user program while preserving data integrity?
View 3 Replies
