I have made a project(made a new data set and forms made by dragging data set entries to form ) in vb.net in which i used ms access as database and now i created a setup file for it but when i run is its giving error regarding some connection to database.?
View 3 RepliesWIth vb 2010 beta2, is it possible to use a Microsoft access save file instead of sql server (with no reduced functionality)?
View 2 RepliesFriends I have Developed my Data base Project on vb6, using adodc and datagrid using ms access database file, it was working nice in vb6, I also put Search box there and used adodc1.recordsource="select * from table" sql query.
later i needed to convert it in vb.net I converted it, every thing is working fine, but one problem appears, an adodc's Recordsource query for searching records is not working, it only works if there is data in dataset (Datagrid),suppose once i pressed search button to search record and if no record found then dataset / datagrid becomes empty, now i wanted to search an other record with other name, but this time it does not work and following error appears Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
[Code]...
I'm very new at using Visual Studio (about 3 days!). I want to create a project that I created into an executable file. The help menu states that I should go under the 'File' drop down menu and select 'Make' to convert into an .exe format. However, the 'Make' selection is not present under the 'File' drop down menu. How can I make a project into an executable file??
View 9 RepliesI am making a project on VB.NET, after the completion of project, is it possible to install it in anyone's computer?I mean to say, the project which I have made in VB.NET 2008, can be only run through Visual Studio,
View 2 RepliesI have access to a database table that has been added as a datasource in project (A). Is there any way to refer to this database table from project (B) WITHOUT adding it to project (B)'s datasource?
ProjB.databasetable.GetDataSetSchema
I'm using VS 2010, and I did a project using VB and a database in Access. The problem is that when I try to put that "application" on other computers, sometimes, is not working. I thought it can be because on these computers they don't have access, but on one computer, is running another app which is using Access and there is no Access installed. How can I check if my application requires Access to be installed or not?
Here is a example of how I did the connection:
Public AccessOLEDBConnString= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & myfullpath & ";Jet OLEDB:Database Password=password"
Function getConnection() As OleDb.OleDbConnection
[CODE]...
And when I want to have access at the data I'm doing like this:
dim conn as Oledb.OledbConnection
dim sql as string
dim ds as Dataset
[CODE]...
Not sure if this is the right Forum to post this question. If not guide me where to post... I have an Access database that I would like to be able to share with Multiple user cuncurently... I have seen it is being done but I am not sure how? Or may be I should be using SQL Express.
View 1 RepliesIn my Microsoft access database I have a table called Picture and 3 fields: ID, Name, Image. I was wondering if it was possible to get all the images from the field 'Image' and display them into SlideShowExtender.
View 2 Replieson my program i have an activation in it and in order to activate the program you need to enter a code that is stored in the settings. so i was looking through my computer and i found the programs config file. and so I opened it and i found all of the codes for the activation. I need to find out how to make the file so the user doesn't have access to it and then how to move it to a more hidden place in the C: drive.
View 3 RepliesI'm using VB 2008. I'm making a project which stores patients name, reason for visit etc in a text file using filestreaming like:
Dim fs As New FileStream("H:/ICS3U Final Project/Betolli.txt", FileMode.Append, FileAccess.Write)
Dim textfile As New StreamWriter(fs)
Is there any way the doctor can literally open up the text file by a click of a button. I don't mean like : read all lines or a STREAMREADER.I want to physically be able to open the text file which is located on the computer harddrive so the doctor can read it.
I have my project all set up but I can't seem to fiqure how to put the Access Datbase on it. I am running Windows 7 OS and I am working with VB 2008. I select SERVER EXPLORER and connect to a Data base and choose Access Database file. I click browse and I can find anything.
View 10 RepliesMy vb2008 project is connected ["PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = C:MyProductMyInvest.mdb"]to an access database. The numerous searches and filters are sql select coded. The database has been added using the Data Source Configuration Wizard. My problem is when published and loaded on another machine it fails due to being unable to locate the database. I have tried the configuration alternative of making a copy and not.
View 11 RepliesI have a single form in VB with an Access database. The form is used to browse the database and works perfectly, however when I compile it into a a single exe file, the database still has to be separate file in the same directory.
Is there a way I can include or embed the Access database as "part" of the exe file so that I have a single exe instead of having an exe AND a separate database file?
I am taking Computing at A Level and need to create a solution for a business.I have thought of my solution which is a log of all the cars that go out on test drive for my dads motor company, i have created a database in Microsoft Access and have saved it as the usual mdb file. i have then imported this into the project and would like to use it.I have created a login form which i would like to use along side the database in the sense i would like it to check when a user enters their name and password for those two things in the database and respond accordingly. I also have created forms in which employees would enter information and then click the submit button, i need this to then place the information into a database as records under the right headings.I have tried using the program and play about a bit but i just can't understand it easily, even when i search for help i have trouble understanding what it all means.If someone could help me that would be great cheersLongy1259
View 4 Replies1. Form created in VB2008
3 Textbox [Name(string), Company(string), Contact(number)]
3 Buttons [New Record, Update Record, Delete Record]
2. Database created in MS Access 2003
File Name: Contact.mbd
Fields:
ID [Primary key]
Name [Text]
Company [Text]
Contact [Number]
How to Create Connection?How to get data on form load from database in textboxes?How to insert, update, delete data?
i am trying to publish a vb.net project that has is connected to a database. the project can be published and installed and runs fine without the data base part. i get following error message: System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
i assume that it simply cant find the database. where do i need to adjust the database file settings to make this work.
I am using Following Codes to connect my project to Access Database:-
CODE:
I want to use Database which is located on My Solution Explorer So My Question is that how can i connect Database which is located on the solution explorer
CODE:
I'm using vb2008 and database ms access.
I want to know if exist in the Debug folder in my project Database access
When a vb project is connected to ms access(DB) whenever u make any changes in d db using addNew or insert or delete follwed by update command the changes are reflected in copy of original db in the debug folder of our project.in which updated values chnges with each run .. no changes are reflected in d original db.is dere any command to make dese changes permanent.
View 8 RepliesI would like to access to a SQL Server Database from my Visual Studio project.
I have SQL Server 2005 Express Edition installed on my PC and I have a database with some tables.
In Visual Studio, I open the Database Explorer and I try to create a database connection.
The Add connection dialog box proposes to enter a database *file name* but I cannot select a database *server* and a database *name*.
Perhaps, is it a restriction because it is a free version ?
Within Visual Web Developer 2008 Express Edition, I can select a database *server* and a database *name* !
After trawling around the net for a good few days, i decided to post something here.
Basically, i've got a problem linking a data source (Access 2007 database) to a VB 2008 project.
I've broken it down to having a problem dragging a table onto my form, when it generates the nav bar, it says "0 of {0}", and the table is empty (despite the actual database containing values)
However, this happens only at home, at college it works totally fine. The only difference that's obvious is that i'm using Windows 7 at home, and Windows XP at college.
i am trying to connect to a password-protected MS Access 2007 database. I don't have any problems connecting to the database when the database is stored on the C drive, the following command works for me:
View 2 RepliesI have added an XML file (File.xml) into a project (I can see it in the Solution Explorer), it resides at the root directory level of the project i.e. the same level as the VB program (.vb), the bin directory and the References directory etc..
[Code]...
I have a project that I have created, it something like a contact database.It is complete with its own sql server database, and controls and forms.I kinda of understand that I can include this project into another project.This is the tricky part,Can I include my contact project into another project and add more items to the database and forms in a new project?What I'm after is like using classes.My contact database would be like the base class, and the new project would be adding more features to that project.
View 10 Repliesany one to make a complete exe file of my vb project its urgent need for me.
View 2 Repliesdim cn as oledbconnection
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:valid.mdb")
[code]......
i'm making a VB 6.0 project to copy files to WCE 5.0 Device. i copied a code i found in msdn but when trying to compile it send me an error: Expected: Identifier[URL]..
Private Declare Function WaitForSingleObject Lib "kernel32" ( ByVal _ hHandle As Long ByVal dwMilliseconds As Long) As Long
I need to make an array of images using references to the resources folder. The following is my code which does not work:
Dim imgPictures(8) As Image
imgPictures(0) = Image.FromFile(My.Resources.cat_1.ToString)
How do I reference the images sitting in the resources folder for this task?
I am making a calculator for a school project, I want to have it so it looks similar to windows calc ( with one button for each number & only one text box),My code has a few blank spots but so far it is :
Public Class calc
Private Sub Btn1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn1.Click
IOBox.Text = IOBox.Text + "1"
End Sub
[code].....