Deployed MSAccess Database Not Updated Through Application?
May 26, 2009
I've created a VB.NET Windows Form application which pulls info from an MSAccess database via datasets and tableadapter. When the user makes a change to the data, I use the Update method of the tableadapter to send the changes back to the database. This all works fine in the Visual Studio 2008 IDE, but once the build is done and the application is installed, I run into problems. The application keeps the original data and will not read or write to the database, although any changes I make through the application are mysteriously saved somewhere. If I make changes directly to the database using MS Access - which I need to be able to do - those changes don't show up in the data pulled into the application.
View 13 Replies
ADVERTISEMENT
Mar 9, 2009
I've developed an application in VB2008 express and have installed it to another PC. The installation has put the mdf file in c:documents and settingsuserappsdata.I want to attach this with SQL Server Management studio but when I try to browse to the file in order to attach it, I find I can't browse further then C:documents and settingsuser.
View 3 Replies
Jul 31, 2009
I want to compress an ms access database using vb.net. If the database is open this fails. How can I close the database, compress it, then reopen the database using vb.net code to accomplish this. I've already successfully written the code for compression, but I can't find anything on closing the database while leaving ms access open.
View 2 Replies
Aug 21, 2009
I am calling a stored procedure that calls a bcp command from a visual basic 2005 application to export data to excel. When I publish the app on my machine the procedure works fine. However when I attempt to install on another users machine when I push the button to call the event ..the export does not happen. I am trying to install from a network and the other modules work fine.
View 2 Replies
Nov 30, 2010
This may be a dumb question, but I am stumped. I wrote a simple desktop application in vb.net (vs2005) and published it via the "deploy" method. After I deployed the app and ran the deployment exe - the application runs fine. However, I have recently added some command line switches so I can run the app via a scheduled job. But I cannot find the "exe" file in order to run the application from the command line. Am I missing something or did I deploy/publish the application wrong?
View 1 Replies
Nov 9, 2010
I am new to ClickOnce deployment and at first glance it seems a great way to maintain .Net applications updated with ease. I am developing a simple application that stores information on a mdb database and over some XML files. I understood how to use the "data" folder with ClickOnce and I am developing the part of my application that should migrate the data from older versions after a ClickOnce update. Now I need to debug that part of my code that only runs when the application is in "networkDeployed" mode. So actually I'm doing the following really slow process to test a new deployed version:
publishing the application on a provisional website (I can choose between a faster locale iis site or a real online one) installing the application from the deploying website (the first time) or running the old installed application so it automatically catch new updates and gets updated... running the application
So basically I have two problems here:
the whole process is much too slow :/ I'm running the app as every other app directly from the OS, so I can't access to the debugger...
I am pretty sure that there are better way to test ClickOnce deployed applications...
View 2 Replies
Sep 27, 2010
I want to know how i can add reports either crystal or microsoft to a folder called reports in my application and then for them to be displayed in my menu tool bar under reports and then for them to run once clicked. I know it can be done its just how it is done.
View 2 Replies
Jun 24, 2009
I have migrated a VB6 application to .Net which uses the MSFlexGrid in a total of 7 different places on 3 forms.When the compiled application is installed on a non-development PC, one of the forms throws a LicenseException when trying to create the instance of the MSFlexGrid control.The other two forms successfully create and use the MSFlexGrid instances that they contain.The problem doesn't occur when the application is run on a development PC.[code]I have looked at the designer.vb code for the forms, comparing the instances which work with the one that doesn't.In both cases, (working and failed) the same calls are made to the control wrapper (i.e. a new instance is created, BeginInit() is called, attributes are set, it is added to the containing control, and EndInit() is called, where the exception is raised.To reiterate, this is not the 'usual' problem of a missing developer license.The exception is not occuring during development, it is occurring in the application installed in the production setting.
View 1 Replies
Aug 12, 2009
I would like to create a desktop shortcut for my clickonce deployed application.The IDE is VS2005 and there is no need for upgrading to 2008 yet.
View 3 Replies
Jun 24, 2009
I have a smart client application deployed as a click once application called "PDFSplitter". The link to install this PDFSplitter is on our company intranet and when you click the link you get a "The publisher could not be verified. Are you sure you want to run this software?" message. Is there any way to make this message go away?
View 4 Replies
Dec 17, 2011
I have recently finished a console application and deployed it to several computers on our network for testing. As it is just an EXE a copied to the hard drives of selected computers for now. When the app is launched it writes info to an sql DB so I always know which computers it is on.
During the past few weeks I have modified this app at least 6 times (improvements, adjustments, etc)
It is a paint to keep going back to the computers to update it with the new version, and getting mixed up which version i am on - LOL I am looking for advice on how I would go about doing this automatically, for example, it would be cool if I just had to put an updated file in a repositry and clients would use this to update.
In Visual Studio, when I view the properties of my application>assembly information - I can set a file version. Is it possible to extract this info and store it in a variable? I would like to dump the in my DB. Also I could then possibly compare the file version of the launched app against an updated file in a network share folder.
View 16 Replies
Jun 25, 2010
Im a newbie in vb.net 2005. I want to use MSACCESS MDB as my database.. DO you have tutorials or tips what should i tackle first?
View 6 Replies
Feb 19, 2010
Im developing an app in VB.NET 3.5 and uses an msaccess database. when the app run by firtstime look for some config files including this example.mdb but if this msaccess file doesnt exist the app should be able to create it and create the tables for being used later.
View 3 Replies
Oct 15, 2009
Do I need to have MSAccess installed in order for a VB.NET application to use an .MDB?
View 10 Replies
Oct 15, 2011
I developed a vb.net application using Ms-Access 2007 as backend. Now can i deploy this application in a machine where Ms-Access 2007 is not installed. Is Ms-Access runtime necessary for running the Apllication in machine not having Ms-Access 2007 installed?
View 1 Replies
Feb 23, 2012
I have the following set of code for a Sub program. It's inserting a row into a MSAccess Database using data provided in the containing form. What I would like to do is grab the ID number of this added record so that it can be set for a property of a window that is invoked when successfully added. I tried looking this up but I get something about @@IDENTITY but it's using an entirely different way of connecting.
Private Sub CreateTournament_Click(sender As System.Object, e As System.EventArgs) Handles CreateTournament.Click
' TODO: Check the form for errors, or blank values.
' Create the tournament in the database, add the values where needed. Close the form when done.
[code]....
View 1 Replies
Jul 7, 2009
how to connect database in vb.net using msaccess
View 1 Replies
Mar 11, 2010
I'd like to make a little vb.net program that executes searches on a msaccess database. I use a textbox to get the value to search and than i'd like to search all the values that has the textbox value in the middle. So, the queries should look like this: SELECT Rec1, Rec2, Rec3 FROM Table1 WHERE Rec1 LIKE "*" & txtTextBox.Text & "*"...My problem is that i don't know how to pass the "*" character to my query, if I build a string that i pass to OleDbCommand(), the query returns nothing.
View 2 Replies
Dec 22, 2011
The following commands I used them in VB6 for database operations MsAccess which are, kindly DataBaseDataSet corresponding commands in VB10?
- Data1.Recordset.FindFirst query
- Data1.Recordset.NoMatch
- Data1.Recordset.MoveLast
- Data1.Recordset.AddNew
- Data1.Recordset.Edit
- Data1.Recordset.Delete
- Data1.Recordset.Fields("nome campo") = dato
- Data1.Recordset.Update
View 7 Replies
Feb 16, 2011
im using vb.net 2005 express to connect to Ms Access 2010, im trying to insert information from textboxes located in a vb form to a table in Access how ever its not working here is the code ive tried :
Public Class Form2
Dim cn As OleDb.OleDbConnection
Dim cmd As OleDb.OleDbCommand
[Code].....
View 8 Replies
Jun 9, 2011
I am trying to add a record into the database wothout much success. sometimes it works and sometimes it returns error "overflow exception unhandled".And even the database is not all the time updated. How do you add the Datatimepicker value into the database...?[code]I'm using VS 2008 and MsAccess as my database connected through the database connection wizard
View 2 Replies
Feb 24, 2009
i want to access locked databse from my vb.net code, i really dont have code for that,
View 1 Replies
May 19, 2012
I tried using the following codes but it's not working,
Dim Con As oledbconnection = new oledbconnection()
con.connectionstring = "Provider = Microsof.jet.OLEDB.4.0; Source=c:\program file\database.mdb"
dim sqlcmd as oledbcommand = new system.data.oledb.oledbcommand()
sqlcmd.commandtype=commandtype.storedprocedure
sqlcmd.commandtext = "query"
[Code]...
View 1 Replies
May 30, 2012
I'm updating an app for children I wrote in VB6 to VB2010. It uses a rather extensive MSAccess Database. It works perfectly but I need to update it to utilize better speech technology. I have read a lot about SQL and can't find how it is useful for anything accept business applications that add, delete or update records as long as you hard code in a name. I don't use datagrids and I never display a table. how to do a few things, I can figure the rest out.
In VB6, I had:
Option Explicit
Public db As Database
Public rs As Recordset
Public Reader As Recordset
[Code]....
View 3 Replies
Jun 22, 2010
When i try to log in i keep getting this error and what it means the code i used is below along with the error message:
code - Dim dr As OleDbDataReader = cmd.ExecuteReader
error - Syntax error in FROM clause
View 2 Replies
Apr 17, 2009
I have the same table in SQLServer and MSAccess database named "KHang" with fields : ID int identity(1,1) primary keys , MaKH char(4),TenKH varchar(50)
Here is my data :
MSAccess (" KHang" : Id-MaKH-TenKH)
1-KH01-tes
2-KH01-test
3-KH01-testing
SQLServer (" KHang" : Id-MaKH-TenKH)
1-KH02-testing1
2-KH02-testing2
I connect to MsAccess database using oledb in vb.net and fill data to DataSet1. So I want to update it to SQLServer database. I mean, the result will be like this:
SQLServer(table "KHang") :
(Id-MaKH-TenKH)
1-KH02-testing1
2-KH02-testing2
3 -KH01-tes
4 -KH01-test
5 -KH01-testing
How can I do it in vb.net?
View 2 Replies
Mar 16, 2009
,i write a simple program in vb.net 2005everything is ok when i run the program in solution, but problem appears when i run the program from bin eleasemyprogram.exethe error message is :'..bin eleasedbx.mdb' is not a valid path. make sure that the path is spelled correctly and that you are connected to the server on which the file residesi dont have a clue about what mistakes i did..
View 2 Replies
May 13, 2010
I need to edit and add records to a shared MSAccess .mdb file residing on a server (actually a shared Public folder during development), preferably through an OleDBAdapter or OleDBConnection. I've been able to connect and read data from the database, but receive an "Operation must use an updateable query." error when trying to invoke the OleDBAdapter.Update({datatable}) method. The Update method works fine if I move the database (and connection) to my local C: drive, but fails when moved to the shared folder. Eventually, the shared .mdb file will need to reside on a server after development.
View 6 Replies
Oct 1, 2009
Does anyone know the sql statement for the inserting of records? I am using the MSAccess database to insert my data of records. I need it asap
View 2 Replies
Dec 17, 2009
Im trying to build an order form application that pulls information from a msaccess file.The form has 3 Textboxes labeled 1,2,3 etc//The first one is a product code, the second a description. i would like to be able to type a product code into box1 and on pressing return it populates box2 (the description).
View 2 Replies