im using ms access 2003 and vb 2010, i already have 3 different vb apps, and i want to access a single database over the lan. but i dont know how. is this possible using a client-server type or is there much simpler way to access the database?
View 4 RepliesI am developing desktop search engine. For that i am maintaining indexed database with file name and their path. The indexed database is created at once by scanning all hard disk. This indexed database is further updated when user creates, deletes or renames file. The updation task is carried out by an windows service application and for searching files on hard disk I have created another windows aplication. The problem is that when windows service is updating database, windows application can not read database. It gives error 'Cannot open user default database. Login failed.Login failed for user 'WINXPSwapni'.
View 1 Replieshow to connect different vb applications to a database server.like accessing data from one database by different applications...
View 4 RepliesI have a program that is running with a Data Connection to Database MS Access Office 2007. I maxed the Database at 1.97 GBytes of memory. I then inserted the Database into my VBasic Program and tried to compile. The compiler gave an error at the Me.ChemicalsTableAdapter.Fill(Me.Chemistry2aDataSet.Chemicals)
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.ChemicalsTableAdapter.Fill(Me.Chemistry2aDataSet.Chemicals)
radPrefix.Checked = True
[code]....
I am needing to be able to access excel and adobe acrobat menu items and popup Windows (mostly acrobat). Is there a way to do this besides using mouse clicks and sending key strokes (come on, this aint applescript). There are some menu actions I need to automate and I need to be able to discover if a window did open and if so I need to do things in it.
View 1 RepliesI have some friends who are 'old-school' VB6 database developers and I was telling them about .NET and its features, specifically ADO.NET. In our conversation, they brought up the following reasons why they would rather stick with ADO than move to ADO.NET: The Dataset is disconnected (What if power fails?)
The same amount of code still has to be written The new options of Dataset, BindingSource and TableAdapter seem confusing the same code is written programatically access the Database, all that changes is how that command is laid out. Why ADO.NET is 'better' than ADO with regards to data access when it comes to Windows Forms applications. What does ADO.NET provide that ADO does not? What does it do better than ADO? I'd like examples that do not involve LINQ.
is it possible to use same database for both vb.net appplication and asp.net??and if is possible, how can to connect it?now..i'd build vb.net application and asp.net in my laptop...it can connect..but i wonder how to make the database connect for vb.net and asp.net in real..
View 2 RepliesHow can I Access the Enty point method of Form Based Applications?How can I set their attributes?
View 2 RepliesI can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 Replieswhich method is more efficient to use: DataAdapter and DataSet Or DataReader when importing data from a certain database table???
View 6 RepliesI'm a first time visitor and poster, but I'm definitly going to stick around. I'm running an old version of Visual Studio .Net Academic 2002 and the .Net framework 2.0. I'm stuck on an issue regarding the deployment of a few programs I've thrown together. They all work fine on my development machine, but the problem they all use SQL Server databases, and I can't find any specific help on deploying a windows application with a database on a machine that isn't set up basically just like my development machine.
I know that I need the .net runtime bootstrapper on the target machine, so I can run basic programs that dont use SQL databases. That's no problem. But what about programs that make heavy use of databases? How does one go about deploying it on target machines? Is there a SQL server bootstrapper?
[Code]...
Recently i had a discussion with someone about the proper way to develop a database driven (SQL Server) application.In his opinion i should design also the database inside the application.At this moment i design the database in SQL Managaement tool and use a custom class to connect to this database (or the one of the client) in my application.What are the cons and pro's of using the VS database designer inside my IDE?
View 4 RepliesI have an application which takes input on a local machine and sends it to a database stored on a server. I'd like to be able to deploy my application over a number of computers (all on the same network), all of them updating the same database (on the network server).First of all, will this be possible without putting together a completely new application to handle all connections to the database and sorting the entries?
View 7 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 RepliesWhen I try adding a new data source to my project I get a prompt saying "The connection you selected uses a local data file that is not part of the current project. Would you like to copy the file to your project and modify the connection?"This sounds rather obscure to me, as I'm new to VB.NET and programming non-script apps in general. The data source in this case is a .sdf SQL CE file.
Question 1: If I say that I want to copy the database to the project, what will happen after I compile the app, where the database will be? (how will I edit it from another app?)
Question 2: If I do not include it, how the data source will still keep linked? Can I link using filesystem enviroiment variables like %ProgramFiles%MyAppDir?
Question 3: Can I just tell it to use a read-only (Just needs to read it) data source on the web, like on an FTP?
Do users of windows applications have to have the database application installed if your program uses databases to store information? For example, when making VB2008 programs, if I use the visual studio express database (.sdf), or maybe a MSAccess database, to store information within my visual basic program...when I deploy the application to the users, can they run the program okay even if they don't have MSAccess installed on their computer?Also, do I need to have MSAccess installed in order to write programs that use MSAccess databases?
View 1 Replieshow to i iinclude sql2000 database in vb.net desktop applications setup
View 2 RepliesWinFormsApp Login passes information to .php (server based) Login (provided credentials are correct) to DB to retrieve Decryption Key. WinFormsApp then uses Decryption key on Hardcoded encrypted connection string and renders application usable.This would then eliminate the necessity to encrypt/decrypt a connection string at runtime, virtually rendering any unauthorized person with a useless software.
View 1 RepliesI'm am wanting to get out of access dbs and into something more solid, ive heard that sqlite or mysql are great database tools for your applications. I am also looking for a database with a GUi to manage the database more easily and links on how to incorporate the database into my projects, etc. So any links,videos, suggestions i'd like to hear them all.
View 9 RepliesI am working on a project that is used for key broadcasting. Don't worry nothing illegal, I'm making a multibox application for world of warcraft. However I am having trouble when it comes to launching and manipulating other applications from another.
[Code]...
I have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset
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'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
I am using the code shown below to compare two Access databases with two fields each and write the results to a third Access database. I am getting an error at the "Do While DMReader02.Read = True" line: "Invalid attempt to call Read when reader is closed." Why would the reader be closed at this point if I am using different DataReaders in the two loops?
Imports System.Data.OleDb
Partial
Class Form1
[code]....
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]...
(using VB2008) I am trying to automate Access from VB.Net. To do this, I added two libraries to my project, Microsoft.Office Interop.Access v12.0.0.0, and dao v10.0.4504.0. This seems to give me all the necessary commands, yet when I tried to open up an Access database via the following code:
CODE:
I have a similar problem posted in the forum similar to this : started learning VB. I am not able to get my example code to work to access an Access database through automation. The author of my book suggested that I might not have the correct Jet 4.0 engine. The specs I have are: MSJet40.dll, Dated 7/14/2009, Prod Ver 4.00.9756.0.
View 3 RepliesI have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset. However, there should be something simpler and faster than that, shouldn't it? Any idea?
View 6 RepliesI have this problem, I can create a setup for my app/database but everyone can open the backend file which is an MS Access database. I want it so we can only access the database using the frontend app.
View 2 RepliesI 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]...