I've a created a website using asp.net (vb). For data I used ms access. I am developing a window application in vb.net using visual studio 2005. Now how can I access and use my website's ms access database in my window application.
View 11 Replies
I've been working on a website with database access in ASP.NET, VB.NET and SQL server for a University project. I've been able to build and test all my forms and they all work as they should so now has come the time to submit my work on a CD. I've been told that I have to explain to my Lecturer about how to open the files/project but I went to test that the default page opened (using Firefox), but unfortunately they won't open and I get the following error: XML Parsing Error: not well-formed Location: file:///C:/Users/NAME/Visual%20Studio%202010/WebSites/FOLDER/Default.aspx
Line Number 1, Column 2:<%@ Page Title="Home Page" Language="VB" MasterPageFile="~/Site.Master" AutoEventWireup="false"-^
Is there any way that I can get the files to open from the CD (obviously after amending the file locations in the code) in a web browser? Would making a extremely simple HTML page with a hyperlink to the ASPX page work, or would it require "building"/"compiling"?I've been using Microsoft's Visual Studio Web Developer 2010 Express to write and build my code and the pages then open in Firefox.
I am trying to toy with an idea, but I haven't really done much database work as of yet. I already have my database up and running, but what I am trying to figure out is what is the best way to attach a query from the database so that the pictures will actually show up? I thought that I could use a gridview, but it doesn't seem to be able to handle the image. I next thought maybe I could an image control,but I have no idea how to attach that to a database.
View 3 RepliesI 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 RepliesI'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]...
I am doing a project on window application but the problem is that I want to connect the connection of database to the SQL Server database. Does anyone knows the connection strings of the connection.
View 10 Repliesit'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 RepliesHow can i connect my vb.net application to MS access database
View 3 Repliesi want to connect access 2007 database with vb.nett 2008 application ?
View 2 Repliesi have created an application that uses an Access Database. Each time the application closes i tell it to repair and compact the database. The problem is that because the database is stored in the program filesapplication_name folder it requires administrator rights because of UAC. What should i do ? Should i store the database somewhere else where no adminstrator rights are required ?
[Code]...
Is it possible to write to an access database that is an MDE, from a .net application?
View 2 RepliesI am using the following code
[code]...
The arguement -new is not being passed and the window that shows the website will open if no other windows are open. However, if any other windows are open, the last opened window gets the website.I have IE6 on my system. Is there any special syntax that will open a new browser window without using one that is currently open?
My application has Binding source to an acess db, how can i distrivbute the application and db as one exe file?
View 3 RepliesI am developing an application on VB.NET 2010, I am planning to make an online activation system, the idea behind is that Whenever someone installs my application, the application presents user an activation form, user will be entering product key, name and email address, and then system will establish a connection to a database which contains all the keys on WEB. So how should I make an efficient program to get rid of that.
View 2 RepliesI'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'm trying to make an application using ms access database. This application is for our class, simply to enter students data and institutions details. However, i got stuck with combo; here is my question and the application background?
I have a database named "StudentData" with table "StudentDetails" with "RECNO" which is Auto Numbered (and is Primary key) and a number of different fields which accepts Students Name, class, accedemic year and so on.
What i want to do with the RECNO is, i want to make a combobox which will be filled with the record number of the students, when i click on any number from the dropdown list, i want the other fields like the txtName (for students name), txtClass, txtACYear etc to be field with each RECNO they belonged to.
Windows form application Access database Is it best practice to restrict user entry via keypress event
then validate all info entered & show error control message
or use dataset partial class columnchange as cannot restrict user entry here Could an experienced programmer suggest best way i actually prefer restricting keypress then loop through and validate all entrys
but want to be right
Excuse me for posting this, but I have searched both Google along with this forum before asking this question, maybe I'm not using the right keywords but I apologize if it's easy to find.I would like to know how one could close a third-party window (application) if a specified string was found in the window title.
View 2 RepliesI would like to know how one could close a third-party window (application) if a specified string was found in the window title.
View 4 RepliesIf you have ever noticed in the Task Manager, when you right-click on the running task, you have many options which include 'Minimize' and 'Maximize'. Is there anyway to do achieve this in vb?
View 1 RepliesI want to connect a database that is located on centralized server. How can I use a windows form VB.NET application to access it? Is this possible?
How can I maintain a single user entry (e.x== used of INSERT command)?
Are both of the above things possible? If so, how can I go about implementing them?
I have a vb.net 2005 application that connects to an access database. I use Access Database Engine 2007 to connect to to this database.
Everything worked fine until i install MS Office 2010. After this, the application started to crash, returning the error 'application has stopped working'.
I've a Windows Seven Enterprise SP1 32bits.
When i debug the application, visual studio also crashes. I get the following error, closing an OleDbConnection: 'vshost.exe stopped working'.
I decided to run some tests. I installed my application on 2 virtual machines: a windows xp sp3 and a windows 7. When i installed ACE 2007 everything worked fine, but when i installed ACE 2010, thats when the problems began. This behavior ocurred on both machines.
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 Repliesi have an application with access .accdb as backend.How can i convert the backend to OracleBL (Visual Studio 2010 Ultimate)
View 3 Repliesi've got a free mysql database online hosted by 000webhost, i'm just wondering if i could connect to the mysql database, and if so what would the connectionstring be like? when i connect using php its something like this: new mysqli("mysql13.000webhost.com", "user", "password", "database1"), how do i translate this into a vb connection string, i can't decide what to put as the data source [code]if there's no way to connect, is there anyway for me to create an application that can store and access database online?
View 7 RepliesI trying to create an application using vb 2010.This application handles booking of airline customers. i am using ms access 2007 where i have created a table that stores customer information and another that stores and updates seats available in different flying classes. Am trying to develop an interactive application in visual basic 2010 where customers can book. i want to add this data to the database in real time and communicate to customers the seats available,prices and so forth. In otherwards the application communicates with database and updates accordingly. Firstly how do i connect to my database? I tried ADO.net but seems better equiped to work with sql server which i have no idea how to use. Is there a tool that can make my interaction with the access seamless
View 1 RepliesI have to deploy my VB.NET application, and create a new access database with 5 tables, some filled in with values on installation in a specified folder in the C: drive which also needs to be created. I have found using google havent seemed to work for me. I am using Visual Basic 2008 Express Edition, so maybe I need to use a proper copy of Visual Studio 2008 to do this.
So basically I am looking for a way to create a .exe file that will be used to install my program on a user's computer, and create a folder and database with some values on instalation. Could anyone tell me how I can do this or point me in the right direction? EDIT - Also would you be able to answer this question for me. Will the computer that the program will be installed on require visual studio or any other software to run my program?
The problem has been simplified for the purpose of clarity. I want to make a windows form application that uses an access database. The application will store the list of person's basic details such as name, age and country. The database contains two related tables ie person(id, name, age, country_id) and country(id, country_name) My windows form contains TextBox, DateTimePicker, ComboBox for Name, Age and Country respectively. Now I want to make CRUD operation Programmatically (Not using Visual tools) in the same form with some navigation buttons.
View 1 Replieshow to publish an application with an access database file on vb 2005?
View 2 RepliesI have an application that uses an access database to fill datasets. My problem is that I have three related tables, when I add a new users to the customers table The parts table fills with data saved in the database with a cust_id of -1.
I discovered that this is caused by adding a part, not saving it and deleting the customer. I Can add code to stop the user from deleting a customer that has parts but I do not have access to the live database to delete the record that are incorrect.
Is there something I can do to delete the rows that have an id of -1 on the load statment?
