I have been working on an Order management System using VB.Net and Microsoft Access as the database, But i am having problems updating the database through my Visual basic Application (I can only view my Microsoft access database but i can not update it through my visual basic application).
View 3 Repliesso i just bought a years web hosting with godaddy, and apparently i have one ms SQL 2008 database, is this compatible with VB ? and if so how can i link them together? i need the user to be able to update the database but also read data from it.
View 15 RepliesI am working on code in Visual Basic 2010 that will read from an Access 2007 data table. If the row has one of the fields marked as processed then do nothing with it, but it not, then process the data in that record, and update the field as processed, and move on to the next one marked as needing processing, looping through all of them. Later I'll go back and repeat this again.
I am able to read from the database and get all the information from it just fine, but I can't then update the 'processed' field. I'd rather like to avoid having the database integrated with the project as other processes will need to access it when this process (program) is not working on it.
[Code]...
When I install my application, some forms are unable to connect to the database.
I say some because, when my login form works totally fine. Authentication happens.
But once I go into the main application, and open other windows, I start to get these error mesages:
[URL]
Is it possible to use microsoft access database for Windows mobile application and save this mdb file locally in the pocket pc?because im trying to make an application to connect to mdb database but this imports seems to be not working.
HTML
Imports System.Data.oledb
oledb is not a member of system.data. why?
I figure why this happens, and is because of Windows 7 and its permissions. Now I'm trying to fix this. but the code for this is a bit complicated for me. I found on this website an example on how to set the permissions on files. ([URL])
[Code]...
I am building a VB 2008 Express Edition application.I have built a database (with a single table) using SQL Server Compact 3.5 and have connected it to the project. I am able to view and edit the data using a DataGridView on a second form (tutorial made this very easy). I need to work with the data in the table within the application. how to easily load the entire table into an array or even read the table a row or cell at a time so that I can make all of the data available for manipulation within the application (the tutorials only seem to show how to display the data).
View 7 RepliesWhy doesn't the database seem to update when restarting an application after some changes?
remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback,
I've created a project in VB .NET. when i build it and run the .exe everything works fine but when i install it the database becomes read only. I've used the VB 'setup and deployment' project to make and installer and i also tried InstallShield but the occurs in both cases. i looked on google but can't find anything that makes sense atleast. i think the application can not create _log.LDF file. Anyone come across this problem before?
error: System.Data.SqlClient.SqlException: Failed to update database "C:........." because the database is read-only.
I'm trying to get my application to read to and write from an Access database. I am running Windows 7 x64.
If I disable UAC, I don't the error. If I have UAC enabled, then the error occurs. Here is a screen shot of the error:
i am just developing a library management system as one of my project. i using vb.net 2010 and the MS Access 2007 as back end. when i save some records into my database through my application it is correctly saved and i confirmed it through opening the relevant table in the database. but when i restart the application all the entered data were missing.
View 1 Repliesi have a simple application which can create/update/delete/search records using Access database. If i add a record, save it, then close the application and run it again and search for that record, it appears. However, when i write some code to my application, nothing to do with the search function, and i run the application the record is not found. For example i added a button to clear the textfields, and when i ran the application the records i have added earlier were not found.
View 1 RepliesWhat is the difference between vb.net application and asp.net application? How can I publish an ASP.Net application with database residing in the server and user could update that through internet?
View 2 RepliesI am trying to create a console application that does the following:
1) read a text file
2) Save the content over to a SQL Server database
3) Use command line arguments to allow user to specify any delimited file
I have vb .net windows form application that I want to connect to Microsoft access database using "Microsoft DAO 3.6 object library". My problem is that when I go to Project tab -> Add reference -> COM tab, there should have been "Microsoft DAO 3.6 Object Library" on the list, but for some reason It's not on the list. Then I googled, and found out that the location of "DAO360.DLL" is "Program FilesCommon FilesMicrosoft SharedDAO". After clicking on Browse tab, I browsed to that location, and I guess I added reference on another way.This is the code that I used before for connecting to Access, but for some reason It doesn't work this way on this PC.
[Code]...
I fill table data into dataset using Adapter. How to update dataset changes back to Microsoft SQL Server Table. I refer to the following URL, the solution is working fine, it makes use of the adapter.UPDATE to get table updated with changes made to dataset. [URL]
Sample Code:
cmdBuilder = New SqlCommandBuilder(adapter)
changes = ds.GetChanges()
If changes IsNot Nothing Then
adapter.Update(changes)
End If
I would like to know is there any other alternatives besides the one I have mentioned above. Can the alternative supports scenarios such as update existing record (probably based on primary key or defined conditions), insert new record as well delete existing record.
I fill table data into dataset using Adapter.How to update dataset changes back to Microsoft SQL Server Table.I refer to the following URL, the solution is working fine, it makes use of the adapter.UPDATE to get table updated with changes made to dataset.
Sample Code:
cmdBuilder = New SqlCommandBuilder(adapter)
changes = ds.GetChanges()
If changes IsNot Nothing Then
[code]....
I would like to know is there any other alternatives besides the one i have metioned above.Can the alternative supports scenarios such as update existing record (probably based on primary key or defined conditions), insert new record as well delete existing record.
I have designed and published my small created app with WINDOWS FORMS using VB 2010 EXP on Windows 7. I can only install the app on the machine that I used to develop the app.I want to install the app on another computer but I cannot. I usually have error reports.
Example:Unable to install or run this application. This application requires Microsoft Common Language Runtime 4.0.3 to be installed on your computer.
what can I do to be able to install the app on a different computer which does not have .Net and does not have visual basic 2010 installed.
can anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
View 5 RepliesI am fresher in vb.net but I have experience in vb 6.0. But I want to connect database in sql server through sql connection. In that case how to create connection with window or sqlserver authintication mode and how to add or update new record in data base in batch transaction. Please help me with sample code.
So that I can understand eassily.
im just starting to work with some database stuff, and ive got data binding done but im a little stuck with filtering. Ive got a test project, which has
-- listbox (bound to column 2/firstname)
-- Combo box (Has items added, with the same names as the items in colunm 3. so it has 'RPG' and 'Puzzle')
Now what im trying to do is when the item in the combobox is changed say to 'RPG' only items in the db which have 'RPG' in the surname column are displayed in the listbox. Been Google'ing and reading but all i can find is examples relating to a dataview and i cant get them to work/adapt to my situation.
I have a console app which checks inbox for unread messages.I would like to make the email message read but could NOT manage. Is there a way to do it?
Dim oMsg As Microsoft.Office.Interop.Outlook.MailItem
Dim i As Integer
[code].....
I am trying to receive confirmations if a user read or deleted an email.Also, I would like to capture if the email was delivered.I have the delivery receipt working, but the read receipt is not working.The email accounts are used on a MS Exchange Server 2010.[code]
View 1 RepliesI'm facing a problem reading .csv file into datatable. The machine on which i install my window service ( which reads the csv ) is Windows Server 2008 R2.The error i get is : The 'Microsoft.Jet.Oledb.4.0' provider is not registered on the local machine
Below is the code i use to fill the dataset from .csv file :
string connstr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + System.IO.Path.GetDirectoryName(arrFilesName[iCount].ToString()) + ";Extended Properties = 'text;HDR=YES;FMT=Delimited'";
OleDbConnection conn = new OleDbConnection(connstr);
[code]....
I also looked at the other option i.e. Micorosft.Office.Interop.Excel but that also needs Excel installed.So, I would like to know that, is there a way to read a .csv file without having Microsoft Excel install on the machine.
update statement, i am trying to update a row within a access 2007 database here is my code.
[Code]...
I am using vb.net with access database. I am using sql. How can i update database with the value 40'6"(Feet and inches values)
View 5 RepliesWhat is wrong with this code. It does not update the access database and no error.
Dim conn As New OleDbConnection
Dim sqlQRY As String = "SELECT * FROM StdMaster WHERE StuNo = " & txtStudentNo.Text & " ORDER BY StuNo"
[CODE]...
I'm currently trying to convince management of the need to port one of our applications to .NET. The application has grown to be a bit of a monster in Access (backend in SQL), with 700 linked tables, 650 forms/subforms, 130 modules and 850 queries.
I pretty much know all the major benefits of doing this, but now need to look at how this can be achieved technically, so I can put a project plan together.So, my plan was to convert the queries into stored procedures and/or views on the backend and re-write the forms in WPF or WinForms.
Now, the code is where I come unstuck. Is it possible to packaged up the code behind and modules into dlls and consume them whilst it is slowly ported to VB/C#?
What we can't be left with is half an application in VB/C# and half in Access, it must 'appear' to all be one application, even half way through the migration.EDIT: Just some more info about what we do and why we're looking at moving away from Access.We are essentially an ISV and the Access application is our main product. This application has been developed over a period of 15 years, by many, many developers on an ad hoc basis. There is no documentation for this application.
We also have problems with getting branching in SCC to work properly, so we've currently got 4 or 5 code bases for the half a dozen clients we have. On top of that, all the testing we do is completely manual, which you can imagine is very labour intensive, and only scratches the surface of what really needs to be tested.We're currently looking to expand, and have a number of sales leads that are in the final stages. I'm worried that with these new sales, we're going to be swamped with support and testing, and that this application is going to become even more entangled an buggy.
I'll also add to this the fact that we're just about to enter the spec phase of a brand new product, which is almost certainly going to be built in .NET. If we were to rewrite the Access application in .NET, then the people we use for that can go straight on to this new development. If we were to stay in Access, then we'd have to get some new Access people in, whom would have to be retrained once we start the new development.
So essentially it has come down to two choices, major refactoring work in Access to try and 'organise' the code a bit better, and those of you who have suggested culling parts are most probably right; I'm sure there are parts that are no longer used. However, I fear that if we stay in Access we still won't be able to build in effective testing and we still won't have proper SCC branching, which will lead to support continuing to be a nightmare, and any future developments on this product makings things worse. Either way there is a lot of work that we're about to embark on, which is either going to be done in Acces, or .NET.
The following is an application sample downloaded from the Microsoft website.It shows how to use the serial port.However, it does not work as written.It sends data OK.When it receives data from the serial port and attempts to display it in textBox2, the program locks up and eventually shows an error message having to do with a thread error..Does anyone understand why this "sample program" written by Microsoft does not work?I see many posts about problems attempting to read the serial port and generating thread errors,[code]
View 2 Repliesi want to use Microsoft Word Object Library for web application , but i dont have office installed in the server side. but i do have a 2007 version installed in the developer machine from where i can build the application. my question here is will my application would be running fine in server , do i need to also install office at server also.
View 3 Replies