Search : in
By :

How to connect vb6.0 to ms access 2003

Last answer on May 7, 2009 1:59:54 pm BST Kolmail, on Jan 21, 2009 4:54:54 pm GMT 
 Report this message to moderators

Hello,Can someone explain to me how to connect vb6.0 to ms access 2003. I know to how to connect at tall.
Thanks.

Configuration: Windows XP
Firefox 3.0.5

Best answers for « How to connect vb6.0 to ms access 2003 » in :
How to connect VB6 to MS Access 07 Show
Coding to link Visual basic to MS Access Show Coding to link Visual basic to MS Access Issue Solution Note Issue Hello, Please I need to know the coding, how to link visual basic to MS Access! Solution You can try this: Option Explicit Dim conn As ADODB.Connection, rec...
Convert system in access 2003 to acces 2007 Show
How to use a driver ODBC 32 BITS under the Window 2003(64 bits)? ShowHow to use a driver ODBC 32 BITS under the Window 2003(64 bits)? You have a Windows 2003 server (64-bits) and you want to use a 32 bits ODBC driver: one that is usually found in the administrative panel for ODBC on Windows or an external...
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...
Connected to the network but unable to access internet ShowConnected to the network but unable to access internet Issue Solution Notes Issue I'm having a problem access to the internet with IE/Mozilla firefox and i'm prompted by an error message saying cannot display web page. I can...
Download MS Access database viewer Show
Download DBSync for Access & MS FoxPro Show
Download Ms Word Excel Cracker ShowMs Word Excel Craker allows recover lost or forgotten passwords for .xls and .doc reated with Microsoft Office 97, 2000, 2003, XP or other word and excel compatible programs. This application will be necessary in case you should have received an...
USB/USB 2.0 connector ShowUSB Connectors USB (Universal Serial Bus) is an input-output interface which is much faster than standard serial ports. There are two kinds of USB connectors: "Type A" connectors, which are rectagular in shape and are generally used for devices...
WPA - WiFi Protected Access ShowIntroduction to WPA WPA (WiFi protected Access) WiFi network security solution offered by the WiFi Alliance, in order to fill gaps in WEP. WPA - WiFi Protected Access WPA is a "light" version of the 802.11i protocol, which relies on...
Ask your question Reply

1

rine012, on Jan 22, 2009 11:13:23 am GMT
   
Reply to rine012

2

 ajit, on May 7, 2009 1:59:54 pm BST
  • +12

(In the General Declaration Area)
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
(in Form's Activate Event)
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=EMP.mdb;Persist Security Info=False"
cn.Open
rs.Open "select Eid,Ename,ppfSub,Basic From EmpData Order By Eid", cn, adOpenStatic, adLockPessimistic
Text1.text=rs.Fields(0)
etc

   
Reply to ajit
Ask your question Reply
They need your help