Access Or MySQL In A Big Company?
Sep 22, 2011
Since a month, i'm working for a big company in France. They asked me to make a application manage their plannings. I devellopped something not so bad using their existant Access database and VB.net.The problem is that in a few months, the application will maybe be used by 70 workers while today only 10 use it.So i did a lot of researches, and i read that Access could not support more that 20 connection in the same time.Firts, is that true ? What do I risk with an Access database for 70 workers ?And then, what do you think of MySQL in my case ? The application won't be connect on internet, only on intranet. I took a very long time to connect my application to MySQL, but now i don't know how to connect the application in intranet.In fact i'm a bit lost with the choice of my SGDB.
View 5 Replies
ADVERTISEMENT
Aug 27, 2010
I have made one application for needs of my company.It is published on company's server and it is possible to use the APP only in company because access db is on local server as well.Now I have small update and when users want to update APP they get this error.
View 4 Replies
Jan 6, 2012
I'm new to VB so was wondering if someone could guide me in the right direction (if what I�m proposing is possible). I�ve got a website that has a MySQL database as part of the package. Is it possible to have a vb app that can connect to this database, perform a select query and send the result back to the client? My vb client app would be at home and the database would be on the net. I tried google and it came back with all sorts of random nonsense. Problem is I�m not sure exactly what I should be searching for. Could someone steer me in the right direction?
View 7 Replies
Jul 1, 2009
I have an application that has been developing in the last months using Visual Basic 2008 Express with Access 2007. In the last weeks I have been converting it to MySQL for my database. i am having problems in configurating vb.net for using mysql. Also converting my existing code to work with MySQL .I use many datagridviews in the winforms and bounded textboxes, etc. How do make them work with a database in mysql. In vb.net when I try to connect to a mysql database the program does not give me an option for a MySQL data source. here is an example in my code wher
Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersKoRnHoLiOsDocumentsDatabase2.accdb;Persist Security Info=False;")
If CheckBox1.Checked = False And TextBox4.Visible = False Then
[code].....
View 9 Replies
Jun 5, 2011
I have a program with access database. Is it possible to convert it to MySQL database?
View 3 Replies
Feb 12, 2010
with .net 2008 exp + MySQL + Access03
i am importing the table data from MySQL to access with this code,
SQLiNSERT = "INSERT INTO imposections(sectors) VALUES('" & Mysql_dataReader.Item(0).ToString & "');"
Dim CMD_INSERT As New OleDb.OleDbCommand(SQLiNSERT, MDE_cnn)
[Code].....
View 1 Replies
Jul 31, 2008
My website connects to a Microsoft Access DB at the moment, im about to upload it to the internet - its a VB.NET web application but i'm advised to convert it to MySQL or MSSQL for better performance.How would you recommend I export the DB ? there isn't too much data in at the moment so mainly all of the tables and fields.
View 2 Replies
Feb 14, 2012
I'm trying to access server database from a remote computer in lan-based network using this connection string "Server=192.168.10.2; user id=user; password=pass; database=sample_db" .. but it can't open a connection.. I don't know what to do, I tried searching for this but no luck.
View 3 Replies
Aug 28, 2011
Is it possible to implement an ASP website written using VB Script on a PHP MYSQL server. Maybe their is a php interpreter that can parse the asp files or something like that?
View 3 Replies
Jan 31, 2012
I'm trying to make a program that takes my old records from Access and moves them to MySQL. Its supposed to take records from 3 different tables in Access to 3 different tables in MySQL. The first table is "Orders" and it sorts the ones to pull to the dataset, taxDS, by "Where Status = 'Waiting Payment' OR 'Cancelled'". Then the second table pulls its info(this is where i'm having trouble) by the "Control_Number" in the "Orders" table, so basically if the control number isnt already in the dataset its not going to pull the data into the new table "FNF Taxes".
Imports System.Data.OleDb
Imports MySql.Data.MySqlClient
Public Class Backup
[Code]....
View 1 Replies
Feb 25, 2012
How to Connect an MySQL to VB8 Form to access File from database I used several codes but connection is not establishing have to connect VB form button by click it connect to database in C# code so Help me to connect for database in C# source code
View 1 Replies
Jul 19, 2011
I am able to copy the complete online mysql database to the local ms access database, but the problem is that the local database needs to be emptied before the new data is being copied.And a progressbar needs to display the entire progress.Here is the code what I have now:
[Code]...
View 1 Replies
Feb 2, 2012
I'm trying to make a program that takes my old records from Access and moves them to MySQL. Its supposed to take records from 3 different tables in Access to 3 different tables in MySQL. The first table is "Orders" and it sorts the ones to pull to the dataset, taxDS, by "Where Status = 'Waiting Payment' OR 'Cancelled'". Then the second table pulls its info(this is where i'm having trouble) by the "Control_Number" in the "Orders" table, so basically if the control number isnt already in the dataset its not going to pull the data into the new table "FNF Taxes".
Imports System.Data.OleDb
Imports MySql.Data.MySqlClient
Public Class Backup
[code]....
So now after my 3rd edit and no answers, I'm finally at the point where I'm only stuck on my For..Next statement not working, How can i get this statement to run for each 24,000 controlnumbers?
View 7 Replies
Jul 19, 2011
I am able to copy the complete online mysql database to the local ms access database, but the problem is that the local database needs to be emptied before the new data is being copied. And a progressbar needs to display the entire progress. Here is the code what I have now:
Private Sub StartScreen1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim dt As New DataTable()
[Code].....
View 3 Replies
Aug 5, 2008
I am asked to write a front end program in VB 2005 (that will run in client computers which running on Win XP) to access an existing MySQL database running in Linux. It is not my preferred choice, but the user have the database and server working just as he wants it, and do not wish to change, at the same time I do not wish to change programming language. Is that even possible? Can we actually write VB 2005 programs that will run in client computers complete with NET framework 2.0 to access a Linux operating database?
View 4 Replies
Feb 1, 2011
I currently have an internal system that I need to link up to an API offered by a company. I am not looking for hand-holding on this, I really need to understand where and how to get started really.
Here is the developer resource for the API I am looking to work with:[URL]..Further, my systems are currently in ASP/ASP.NET & SQL, and I'm familiar with VB so I would rather stay that direction instead of C#.
View 1 Replies
Sep 1, 2009
I am getting this error when trying to connect to the database which comes with Sage Line 50. It doesn't matter what table i try to look at i get this error when i try to create a datagridview. The near 'COMPANY' bit is the name of the table not one of its fields. Is this going to be something wrong with the SAGE ODBC (wouldn't surprise me) or does something need changing?
View 10 Replies
Aug 19, 2010
My app works perfectly until I run it on my companies network, as soon as it begins to download files the application closes and nothing happens.
I Know my company is using a .pac file defined in IE settings. I have tried a number of methods trying to make this work but still nothing.[code]...
View 6 Replies
Jun 13, 2009
How do I change the company name of my project?
View 2 Replies
May 15, 2009
I want to develop a company security software, i wanted to ask if vb.net is web based software. and some tips of how I can start.
View 1 Replies
May 27, 2011
I was wondering how I can set a file's properties? I'm talking about the fields, author, company etc. I found a way of doing it through Word's builtin properties. But it's a little buggy. So I was wondering if it's possible to do that in other ways?I have this code that works for all Word document files except *.doc format it seems.This is the code I have so far, one text box and one button. The button runs findDocLoop()[code]I know it can probably be done better, but I'm kinda in a hurry. I just noticed when I set a break point right after the code sets the value of the property. I set Word to be open, got in there and checked the property value. And it was actually set!. But after the save phaze, it seems to be lost. Or "reset" to some Office defaults.
View 1 Replies
Sep 13, 2009
i had finish my vb.net project. But i dun know how to upload in server company .
View 1 Replies
Aug 11, 2009
Okay, so, for school i have a project i need to completely program by the end of next semester. My graduation project. And it needs to be a full-blown piece of software that would be theoreticly usable for a person or company.assignment was simple:make an application, usable by a person or company, that uses databases and VB.NET
so i started brainstorming and i came up with the following:a client-server application where the server runs on the company's mainframe and it's employees (seeing as it would be an IT company or another company that would use a lot of computer files) can upload to, and download files from, where each file would have a description and additional information (extension, date,emplyees would also be able to exchange private messages so that collegues of the uploader can be notifies that the file they would need is uploaded.
in addition to that there would be an administrator (or multiple) that can overview all PM's (make sure there's no abuse of the system) and administrate the files (delete/edit/...)So really, i have no idea where to begin building this application, so i would think that if i get the interface done, i atleast have an overview of what and how i would need to code.
note: wow now i think about it this seriously sounds more like a website than an application... but still it sounds like a good idea to me and has to be done or else i would not graduate
View 5 Replies
May 22, 2009
I'm creating setup using VS2008 and I can able to create. The problem is the setup location is always c:program filesdefault company name.
I can rename that while installing. but, how can I change default company name while creating setup.
View 13 Replies
Oct 17, 2011
I am new bee in Visual basic and coding stuff. I am planning to create a knowledge base for my company. Can someone suggest me how to proceed. I have some ideas of creating it but really don't know how to move on.I already have some word files and pdf files where I have some troubleshooting steps and solutions, so i would like to create a search engine which searches the exact word file or a pdf file to show the result.
To make it simple just like google search engine. If I type something like "How to configure a network printer?" I should get the result of the word document or pdf file which has printer configuration steps.
View 7 Replies
Feb 15, 2011
I had developed a vb.net windows forms application for my company. It is working fine in our company. The database of that application is maintained in a separate server. I had direct connection to that database through sql connection in my application.Now one of our colleague wants that application to be installed in his laptop so that he can work on it when he is at home. How will I do that? The application will get installed but the problem is that the data won't get saved (as he won't be connected
View 2 Replies
Jul 21, 2009
I have a table adapter for a fairly sizable piece of data. Now with this data I would like to give the user the ability to change the company name and have this reflected in the form on the drop down list of all of the companies once they have clicked submit. However, in order to do so I currently "Fill" the entire table adapter again to achieve this.Is there any way which I could just re-fill the company column from the database in the same tablea dapter.Here is my code for the sub:
Dim NewName As String = txtNewName.Text
Dim OldName As String = txtOldName.Text
Dim FieldName As String = Me.Text[code]...
View 1 Replies
Nov 22, 2010
VB2005. In my application I am required to go to a website, collect info, and then display both the webpage and the info collected. For this I am using the System.Windows.Forms.WebBrowser component and have it working faily well. The only thing now is that in order to get to external websites the company requires us to login to the firewall proxy server. For example when I visit [URL] a login box pops-up for our firewall server [URL] and I sign in with ID 9999 and password "pass". I am trying to programatically do this with the WebBrowser by using the credentails but have not found any relevant examples. Is this possible with the System.Windows.Forms.WebBrowser component?
View 2 Replies
Mar 1, 2012
I am creating a windows application for my company. in the master file i will enter the number of items we are getting from the customer. and in the next page i have to enter the details of each item. For that i have created a datagrid which has one autogenerate number field and the remaining fields must be editable. So that when i enter all the values in the datagrid, it has to go and save in the data base.
View 2 Replies
Apr 27, 2012
I am populating text boxes when a user selects a company name from the cbo box. When I make the first selection everything looks good, but when i make another selection the text boxes do not clear and repopulate with the new values. Here is the code in the selected index change event.
[Code]...
View 4 Replies
