RSS Forums RSS
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 2111 | Replies: 3 | Thread Tools  Display Modes
Reply
•
•
Join Date: Sep 2007
Location: Nigeria
Posts: 14
Reputation: damson is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
damson damson is offline Offline
Newbie Poster

Connecting VB 6.0 to microsoft access

  #1  
May 16th, 2008
Can anybody help me in on how to connect my VB interface to a database.
I have already designed the interface but I do not know how to connect it to Dbase.

Damson
AddThis Social Bookmark Button
Reply With Quote  
•
•
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,602
Reputation: Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light Jx_Man is a glorious beacon of light 
Rep Power: 12
Solved Threads: 239
Jx_Man's Avatar
Jx_Man Jx_Man is offline Offline
Posting Maven

Re: Connecting VB 6.0 to microsoft access

  #2  
May 16th, 2008
This following code to connect vb 6 with access
place this code in module :
vb Syntax (Toggle Plain Text) 
  1. Global Conn As ADODB.Connection
  2. Global rs As ADODB.Recordset
  3.  
  4. Sub Access_Connector()
  5.     Set Conn = New ADODB.Connection
  6.         Conn.Provider = "microsoft.jet.oledb.4.0"
  7.         Conn.CursorLocation = adUseClient
  8.         Conn.Open App.Path & "\SIS.mdb"
  9. End Sub
  10.  
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
Reply With Quote  
•
•
Join Date: Sep 2007
Location: Nigeria
Posts: 14
Reputation: damson is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
damson damson is offline Offline
Newbie Poster

Re: Connecting VB 6.0 to microsoft access

  #3  
May 17th, 2008
Thanks. I mean to connect to microsoft access and creation of the table .
Reply With Quote  
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,502
Reputation: debasisdas is on a distinguished road 
Rep Power: 5
Solved Threads: 91
debasisdas's Avatar
debasisdas debasisdas is offline Offline
Posting Virtuoso

Re: Connecting VB 6.0 to microsoft access

  #4  
May 19th, 2008
you want to connect to anexisting database or create a new one at run time ?
Share your Knowledge.
Reply With Quote  
Reply

Quick Reply to Thread
•
•
•
•

Only community members can participate in forum threads. You must register or log in to contribute.

Register


Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

•
•
•
•
Thread Tools Display Modes
Linear Mode Linear Mode
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 11:11 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC