I have a windows desktop app I'd like to release that would access data from a database on the web. Never done this before, so not sure what's needed either on the client side or the server side.
View 1 RepliesI am trying to import data from an access database to a access database that my project uses I am having problems with combo box fields in the database with the data. I want to import what is displayed instead of the numerical key value. Example: The combo box displays employee names but the value stored is the key value from the employee table so instead of importing John Doe it imports 2 is there a way to make the actual name instead of the number?
View 4 RepliesI have difficulty in removing the LDB generated by the "CREATE" method of ADOX in the following code segment.Aims: Create (on the fly) a new access database and then export data (says Arena modules) to that newly created database.
Expected: The newly created access database should be able to be used by some external operations, say Access.exe, after the end of the subroutine and without exiting the current VB program.
1) I tested that the "Arena code" do nothing about the create/release of the ldb file.
2) I tested the "Exclusive Mode" in connection string, but the access file is still locked by the vb program.
3) I tested under both inside the VB environment, and directly invoke the generated from Explorer, and same results.
4) Other database formats is not the options to me. (due to Arena export limit)
5) It is not a web app.
Code:
Sub Method1()
Dim logs As New System.Collections.Generic.List(Of String)
Dim arenaApp As Arena.Application = Nothing
Try
[code]....
Platform:
Windows 7 64bit, Office 2010 (32)
VB 2010 express
Lib: MS ADO Ext. 2.8 for DDL and Security
I coded a program to access a Microsoft Access 2010 database. The program is written using Microsoft Visual Studio 2010. I get the error message that the database I'm trying to access is in an invalid format. look at the code below to see what I missed. The error is in the datasource statement.
[Code]...
quite new to database queries through VB. I have just created a DB using MS Access and I need to write data to it from my VB Application.Can anyone point me on which objects should I use to execute these write transactions?
View 6 RepliesI have developed a small window application, having lot of insert and select scripts. It runs fine for 3 times but when i run it 4th time it gives me Error "Out Of Memory Exception". I observed that in my task manager Sqlserver.exe process occupies memory around 167000K. Then I killed it. and again run the code, this time it occupy 12000K memory. Again I run it...the memory increases and stops at 87125K. All It means i the C#.net objets are not disposed well.
I have tried for
GC.GetTotalMemory()
But failed? How can I release objects?
it's just for a program registration. i would store all of the registration codes in the access database, then export it to XML, then upload it to my web host. I would then somehow connect it to my Visual Basics login form (Which I have already made). If this can't be done, having them register through the form and having all the allowed codes on the internet (So i can easily edit them)!
View 5 RepliesI'm trying to make sure that I don't leave any loose ends open in my application and am concerned about a few but might get my answer from this one. I've "overriden" some functions so that way I can try and keep all the resources as clean and free as possible. So in this instance, I have a function called ExecuteReader which returns a DbDataReader as normal, but all I had to pass to it was a SQL string rather than recreating a DbCommand every time. I want to make sure that even though I'm unable to call dbCommand.Dispose() that it is actually doing so.
[code...]
In here, I set the _dbReader to what I'd get from the function and eventually I close the _dbReader. I do not close the connection as I don't open it each time I make a query. This is a SQLite database that only one user will be using at a time (small application with very very very little likeliness it will grow) so I didn't think it necessary to close and open the connection all the time. Maybe I'm wrong, not sure. Using it this way though, it is potentially ok for cleaning resources?
I programmed an app with an Access 2010 database, I installed the app and the database on a computer with office 2007. The app can't open the database. Do I need to copy some extra file on the user's PC?
View 15 RepliesI've built my program a database in Access 2010. Works very nice. But I've had a thought. When my program is compiled and I give it out to users. Will those users need a copy of Microsoft Access to use my program. If so, How could I make it so that no install of Access is needed.
View 3 RepliesWhen the user releases the left mouse button (MouseUp) anywhere on the screen (whether it be outside of the form or not), I want a message to be shown. How do I do this?
View 5 RepliesHow do I make a release build in visual studio express 2010 (VB) ?
View 1 RepliesI've searched the VS settings and haven't discovered why the bin.Release folder is empty after a build. The bin.Debug folder output is normal. The same occurs with the obj.* folder.
View 4 Replieshow to connect vb.net 2010 to ms access database to get the data and display it in vb.net application that I am doing right now. My project is that I am doing dictionary application with vb.net so every time i put new word in search box, I want the vb.net to get the definition from ms access and display it in the application.
View 1 Repliesfirst of all here is the code that populates the fields when the user logs in. This code is correct and works fine.
Dim passwordrow() As Data.DataRow
passwordrow = MyDBDataSet.Tables("Customer").Select("Username = '" & txtusername.Text & "'")
'This try statement checks to see if a row has successfully been found
[Code].....
I have connected the database itself without much issue but i want to be able to edit, add and eventually delete from the database using Visual basic interface. This is for an A Level computing course that i teach, i remember a long time ago when i did the course this was fairly simple to do however i cannot for the life of me figure out how to do it at the moment. This is further confused by office 2007 and VB 2010 both of which didnt exsist the first time i did this.Connect 2010 to an access database?
View 4 Repliesi am having a issue with my database connection. I have connected the database itself without much issue but i want to be able to edit, add and eventually delete from the atabase using Visual basic interface. This is for an A Level computing course that i teach, i remember a long time ago when i did the course this was fairly simple to do however i cannot for the life of me figure out how to do it at the moment.
View 1 RepliesI'm new to Visual Basic. I came across a random number generator tutorial. Got it working fine and then I thought, Is there a way to get it to access a database Here's the thing
1. Generate the random number.
2. looks at the database and finds the corresponding id number.
3. Takes the field for that number and enters it into a text field in the program.
So for example the number generated is 32. Then the program looks at the database and looks for id number 32. then takes the text in line 32 and enters it into a textbox in the program.Now I have my database and the program. But just can't seam to figure out how to get the two connected like I want. I have looked and searched but have found nothing like it I am using Visual Basic 2010 and Access 2007.
I've tested an application (one that I'm developing) that utilizes MS Access database (.accdb) on a backup machine. And I consistently get an unhandled exception error saying 'The Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. I suppose I get this error because the backup machine doesn't have a driver or whatever to read the Access database file. Reading
this topic titled "How to deploy VB 2010 application as a standalone without MS Access", I understand that I can just specify a prerequisite for this component (driver or whatever...) in the project designer window in reference to this page. I wonder if there is a simpler way of delivering the database component to users? Or should I abandon the Access database and use a different one for easier accessibility?
update access database from vb 2010?
[Code]...
I just started learning VB 2010 through a book. I'm learning vb to design a program which can manage customers of a small company as a homework. It'll store data (Company Name, Phone N. and Adress) at an Access Database. (I'm using Access 2007)
I have a little background with programming but none with databases. According to the book there is no way I can delete, add or update a data from an Access Database without installing SQL Server or Express. But this program should work at a computer which may or may not have SQL server or MS Access (Any computer with Windows OS).
After a little digging only thing I could find was Walkthrough: Saving Data to a Database (Multiple Tables) from MSDN and did every step and at the end, I can delete or add rows and change values of the cells but cannot save them (when I click save, close the program and re-open it, changes are gone).
I don't get that how can I view all the data from database without SQL server but can't save changes to the database file without SQL Server.
Is there a way to do this without SQL Server? If so, can you give the right code for the MSDN Walkthrough's Save button? Or point me to a page where can i learn the right code?
I am having problems writing to my .accdb database. Here is the code, any input would be welcome. I am also trying to avoid using a pure MYSQL.
VB.net
Sub Add_to_database()
Dim connString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data
[code].....
I want to connect to a mdb file but i have never did that before. i don't know where to start. heard something about ado.net and some other things.
the file is a 2003 access file if i am not mistaken. and it is shared on network. so multiple users (not too many, max 50) will use it at same time. what is the best connection to use? i have to mention that i don't want to use data controls. i want to use sql commands to fetch data and manipulate data on the form controls myself. i know there are various connection ways like strings and adapters. not sure which one is better.
I don't know how to take input from user in sql statements, i'm learning from different sites so i don't know how to do it. Here's the code.
Public Class Form1
Dim con As New OleDb.OleDbConnection
Dim dbProvider, dbSource, sql As String
[code].....
I got an Syntaxerror in my INSERT INTO but i cant figure out why.
[Code]...
I am trying to update my access database after changing one of the values of a dataset I loaded from it..[code]I already created a dataset called "Address" using the DataAdapter.fill method. Name and ID have values assigned to them in my program and ID corresponds to the ID# in my Access database.I receive the following error:Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information.I am completely new to working with databases
View 2 RepliesI have part of an application that reads from a database makes changes to the data then saves the changes to the database.
[Code]...
An application that has 3 Webbrowsers instantiated at design time navigates to webbrowser2 15 times every minute with a different webpage. Webbrowser2 is disposed of after each web page is received and processed. The size of the private application memory continues to grow as when the disposal was not instigated. The application memory grows to 1GB and then the program stops responding. Any suggestions? [Code]
View 1 RepliesI have a function which return the Dataset and my question is that, is dataset memory release automatic when function work finished if not please suggest me how i release memory in below sample question?
public function givemedataset()
dim keepme as new dataset
'grabbing record into dataset
return keepme
end function
Private Sub forumbrowsebtn_Click
dim getme as dataset=givemedataset
end sub
Will setting the DLL to release hide descriptive names & class info?
View 4 Replies