DB/Reporting :: Stand Alone Application Data Access?
Dec 22, 2008
I am new convert from VB6 and needs some help developing a stand alone application in VB 2008 that needs access to stored data values.All applications I have developed so far have been for computers that have either SQL Express or Access installed locally on the computer. This has made development really easy since I could use ADO to access and query the data.
The application I am now developing will be installed on a computer that does not have any of the MS office applications and I do not want to install SQL Express on the computer. But I still would like to use an 'ADO type' functionality to access, query and modify the data stored in the system.I started looking into using XML, but I was unable to find much information on querying and modifying individual elements.
View 12 Replies
ADVERTISEMENT
Jun 23, 2011
I have the following code that i need to convert from a MS Office- Visual Basic App into a stand-alone application. I have debugged most of it to run in visual studio 2008, however it has a problem with the message box stuff. If i cant have a message box with the information in it then I want to put the output in a label but im not sure how to convert it to display in a label. [Code]
View 9 Replies
Jun 2, 2008
I am an Australian user so use date format dd/mm/yyyy...my frmMain has a list box that retrieves a list of date values from the access db and displays them in the correct format (15/12/2000 - dd/mm/yyyy). When I update the DB using that same date the date format becomes reversed (ie interprets as 12/15/2000 - mm/dd/yyyy). [code] I believe the problem is something to do with the fact I am enclosing my date in my code with #'s and that somewhere between visual studio and access, the dates are getting flipped. [code]
View 1 Replies
Jun 3, 2011
I have a stand alone application "test.exe" on a Windows 7 operating system.I have an application "test.exe" made in Visual basic 8.0.I have an "Auto Update" function . Call this function from "test.exe". In the first line in "test.exe".This function does the following:
1. This checks whether the current version is older than the version on specific site, if so:
1a. Removed all *. old
1b. Rename test.exe to test.old
1c. dowload new test.exe
I'm afraid I get an error when I rename "test.exe" to "test.old" because "test.exe" is now active.How can I prevent this or what else should I do?
View 2 Replies
Oct 29, 2011
I'm tired of how to make my application stand-alone exe. I have created a small application console using C# in visual studio 2010, and I want to make it run on other computers with out having to install .net on that machines. and also make it just like notepad.exe with just click and it will run. I've read a lot of articles talking about netz or ILmerge.exe or mono which is so difficult to me to understand. and another question is how to know how many .net files or dll s that my application needs?
View 5 Replies
Aug 18, 2009
I'm working on a VB.Net Windows form that is supposed to manipulate an Access Database. I can Already read data from the database (placing them in a combobox) using the following:
Code:
Private Sub Form2a_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
OpenFileDialog1.FileName = ""
OpenFileDialog1.Title = "C# Corner Open File Dialog"
[code]....
View 4 Replies
Apr 17, 2009
I wanted to know how I can make a stand alone exe without making the user install the application. So that the program can be ran from a disk or flash drive. Currently I can run it just fine on the PCs, I'm developing it on. But when I take it to another, that has the targeted framework, it crashes.
[Code]...
View 24 Replies
May 19, 2009
I'm trying to remember how to insert data in to a table. Here is my code
Code:
I get the error
Quote:
Number of query values and destination fields are not the same.
I also get some error about the Insert INTO part not being right somewhere. Am I doing this how you would do it, or how would you do something like this?
View 1 Replies
Oct 7, 2008
Using Access I created a few Data Access Pages. These web pages, once opened, work fine to manipulate data as intended, but they keep generating annoying warning messages.There are two messages that pop up every time the web page is accessed. Before the page opens the first message that pops up states: "This website uses a data provider that may be unsafe. If you trust the website, click OK, otherwise click cancel."After pressing OK on the first, the second message pops up and states:"This website is using your identity to access a data source. If you trust the website, click OK, otherwise click cancel."After pressing OK on both messages the page functionality works just fine.I've tried adding password protection to the database and even signing the project with a digital certificate, but I still get the warning messages. This would be fine except there are multiple end users for the access pages and I am trying to avoid the additional confusion this will create, especially since IT has restricted many of the users from editing the internet options.
View 1 Replies
May 19, 2008
See our Posting Guidelines for our policy on archived threads.I am confused as to where to place the following code snippet in my code. I put the function above my load event and the same exception still occurs:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
[code].....
View 1 Replies
Jun 21, 2008
I'm using XP and access 2003 and visual studio 2005. I created a project and connect this project with database access file. and I created some textboxes and command button on the form. Is possible to modify and add a new record to the database without using the navigation toolbar by insert a code in the command button.
View 1 Replies
Jul 23, 2008
the access data are not getting reflected on the DataGridView unless the form is reloaded again. I am acessing the MSAcess data for back end processing (SELECT,DELETE)using odbc connection and displayin on .NET form using DataGridVew
View 2 Replies
Jun 8, 2009
I have a problem with transfering data from MSSQL Server 2005 to Access.
I need to make a VBScript that can take out all data from one table in mssql and update one table in Access. The tables exist in both databases and looks the same, but there can be more data in the table from MSSQL Server so i need to update the table in Access with this data.
E.g. I have a table called: SMP_Alert in both database's. So i want to do something like this (dunno if that is possiable):
Set objConMSSQL = CreateObject("ADODB.Connection")
conMSSQL = "Provider=SQLNCLI;Server=127.0.0.1SMP;Database=SMP;Uid=SA; Pwd=smp;"
objConMSSQL.Open(conMSSQL)
[Code].....
Or do i need to create a recordset of the table (SMP_Alert) from MSSQL, and loop through it to transfer the data into the table in the Access database?
View 1 Replies
May 12, 2008
I am quite green to VB .NET and it start occuring to me that I am doing things probably in a very ineffective way.Anyway here is the problem I have datasets, consisting of integers there is set 1 which is of format ID, ID2 - ID here is unique but different ID can refer to same ID2. Before I start reading in the data I have unknown number of these entries (ID and ID2 can be at least as high as 99999999)
Then I have a second data set of format ID2 here is the same as in the set 1 and it can contain several PID entries (all integers). In this set the ID2 is unique and again for one ID2 there can be unknown amount of these PIDs, same PID can occur more than once.
[Code]...
View 17 Replies
Apr 29, 2009
Source: DataTable
Destination: Access Database Table
I should mention that the DataTable contains data resulted by an SQL SELECT query and it's not related to the "targeted" Access Database Table.
View 1 Replies
Mar 8, 2009
I'm presently creating an application which uses Access2007 as the database. No problem there. But Since most use Excel for data-entry, i've created two tables in access linked to excel source file. Any change in excel will reflect in Access database and subsequently in my Application . Until now my application only reads the database and displays records in DataGridView. These records, i then export to excel along with other formatting for direct printing as a report as I have no idea how to make report. Now i want to add data-entry capability to my app using password-protection user-access. So i can directly add new record to source file. Also need to know if There's any way of eliminating Access from the picture entirely....
View 1 Replies
Sep 21, 2009
I have a form that has around 4 txtboxes. Data is inserted into these boxes and then a "Save" Button is pressed. I have a GridView added to my form and want to view the entries. The issue I am having is that when I click the save button the data doesn't show up in the DataGridView until I close the application and then re open it.
[Code]....
View 8 Replies
Jul 7, 2011
I'm trying to connect a VB application (2010) to an MS Access DB by adding a data source from the data menu but I receive this error message "The connection you selected uses a local data file that is not in the current project.Would you like to copy the file to your project and modify the connection ?
If you copy the data file to your project, it will be copied to the project's output directory each time you run the application" and the options are (yes , No , Help)
If I choose Yes I will not be able to make the application 'device independent ' since it will not be copied under the bin , and if I choose No , changes won't be applied to the DB
View 5 Replies
Jan 13, 2009
I have sqlserver database in my server folder c:data How can i access this data from other computer with my vb application?
View 8 Replies
Mar 12, 2011
I'm working on this project and i need to retrieve data from my access database and display it on my vb.net windows application
i tried the code below..but there are still some errors on it..
[Code]....
View 2 Replies
Apr 11, 2009
How do I make a basic Data Access application (Next, Previous, First, Last, Update, Delete, Insert, Save)?
View 1 Replies
Apr 8, 2011
I have added some files that I need to be downloaded to the Application start up path. So I set Build Action as content now the files have been copied some where [code]...
How can access file from the application.
View 1 Replies
Sep 21, 2010
I have an application half built which accesses a Access (2003)Database File. From within the application I am able to change the data in the Access File using a Data Grid. The changes to the Data File are saved and can be recalled, changed or otherwisemanipulated however, when I add too or change any of the applicationcode the Access file reverts back to it's original state losing any data or changes that has been made.
View 3 Replies
Nov 8, 2009
Basically I want to know how to access a particular website from my application. I have used System.Net Namespace to request HTML from a website, It returns a complete HTML code which is used by Browsers to render the content on the screen but what i want is to interact with the website only without the use of a browser. I currently dont know how to do that.
I have a application which displays a Image when a user enters a keyword, lets say user enters a word "Envelope", the application will go to Google Images and search for this keyword. Now google returns images as results, the application now needs to download the first result ( which is a image) and display it on a form ). Everything here is done without a browser but via my application.
View 2 Replies
Apr 8, 2011
I have added some files that I need to be downloaded to the Application start up path. So I set Build Action as content now the files have been copied some where
C:Documents and SettingsTestUser.ANNAMLocal SettingsApps2.0DataHVDRBMY5.8AA858AT9VM.TNP est..tion_2d7cfc137d9c2c74_0001.0013_432bd4561850d290Data
How can access file from the application. My problem since it is a dynamic path will it be same folder count so that we can use like ....Data Some think like this
View 1 Replies
Mar 31, 2009
Is there a need to explicitly close the connection in this Microsoft Data Access Application Block for .NET? i am encountering timeout expired pooling errors in the sql server 2000. I am wondering if the unclosed connection is the problem
View 2 Replies
Jul 13, 2009
We are working on an ASP.Net/VB.Net application using Enterprise Library for our data access (DAAB).
We are trying to store DateTime values in an Oracle Date field. However, the precision is being lost. Currently only the year, month, and date are being stored. We need better precision than this.
Oracle Dates are supposed to "includes not just the month, day, and year, but also
the hour, minute, and second. "
View 1 Replies
Oct 15, 2011
I have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 Replies
Sep 28, 2009
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it?
View 1 Replies
Sep 27, 2009
I recently switched to V.Studio 2008 and using VB. I can not find in the data toolbox the connection and data adapters. Should I do something else to make this appear so I can drag them in my form.
View 2 Replies
