Search : in
By :

Connecting vb to database

Last answer on Sep 14, 2009 10:55:08 am BST Sorghurm, on Jun 26, 2009 10:32:56 am BST 
 Report this message to moderators

Hello,
am unable to connect my vb code to access tables from ms access database.Please help me to go through.

Configuration: Windows XP
Firefox 3.0

Best answers for « connecting vb to database » in :
Connect a database (MDB) to excel Show [VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
ASP.NET using C# - How to Connect/Retrieve in database to web a Show ASP.NET using C# - How to Connect/Retrieve in database to web application Issue Solution Note Issue I am doing my project work, I have one problem My project doing in asp.net but I don't know how to connect the database in asp.net...
Installing DB2 Express V9 ShowInstalling DB2 Express V9 Prerequisites Installation Configuration Here below is a guide for the installation of DB2 Express V9.5 available from IBM. Prerequisites First of all download the version to install from the following...
Connecting to Oracle via php ShowConnecting to Oracle via php Settings Requirements Example of code Settings Below is an article based on an example of connection to an Oracle database through a php script. However it is not designed to configure your oracle...
Connecting to an Ingres database with PHP ShowConnecting to an Ingres database with PHP Getting started Download PECL Installation Windows Linux & Unix Getting connected This tip is based on following Ingres documentation: Getting started Ingres® 2006 Release 2 for...
Download Aqua Data Studio ShowAqua Data Studio is an advanced SQL editor. It can create, edit and execute SQL scripts. This software provides an integrated database with only one interface for connecting to databases. Query Analyzer enables users to work on RDBMS synthax and auto...
ODBC ShowWhat is ODBC? ODBC stands for Open Database Connectivity. This is a Microsoft-defined format for communicating between Windows database clients and consumer DBMSs. The ODBC managier can be found in Windows 3.1 and 9x. In Windows 95 and 98, it is...
Databases - Using forms ShowUsing forms In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or...
Sharing an Internet connection ShowAdvantages If you have a local area network (two or more computers connected in a network) with one computer connected to the Internet (via a modem, using a cable, etc.), it may be useful to make the connection accessible to the other computers on...

1

 prad, on Sep 14, 2009 10:55:08 am BST
  • +1

If u r using ms access 97 then use adodc connection drag this from tool box then make a right click and do the connection then test ur connection if it is donn then go to ur module code and write there code as Set cn = New Connection
cn.ConnectionString = "provider=Microsoft.Jet.OLEDB.3.51;data source=" & App.Path & "\name of database.mdb;"
cn.Open
n if using 2003 then
Set cn = New Connection
cn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=" & App.Path & "\name of database .mdb;"
cn.Open

Reply to prad