[k4t1kai]

I have to know that can VB6 able to access remote database?
In my project I want to establish Client-Server hierarchy.
The database should be in server and client must be able to view the data.
Is this possible in VB6 ?
I am using MS Access database and VB6
pls tell me how to do this or any link that will help this problem
Thanks in advance

This post has been edited by k4t1kai: 19 October 2009 - 06:35 PM

[vb5prgrmr]

Yes
Yes
Data Form Wizard, http://www.connectionstrings.com, search for vb6 ADO Tutorial using one of your friends (yahoo, google, ask, answers, bing) or just to the right of these posts see if there is one on this site if you happen to see the section to the right that says VB Tutorials...



Good Luck

[Philip Munce]

www.connectionstrings.com should be your place to go. The way I would typically approach it is to add a reference to the Microsoft ActiveX Data Objects library (ADO) to the project I am working on. I have added a screen dump below. This will then allow me to create code similar to the following to connect to a database and read fields out.

Dim conn As New ADODB.Connection
Dim results As ADODB.Recordset
Dim value As Integer

	conn.Open "<insert conn string here>"
	Set results = conn.Execute("SELECT FIELD FROM TABLE")
	
	results.MoveFirst
	While Not results.EOF
		
		value = results("FIELD")
		
		results.MoveNext
		
	Wend
	
	results.Close
	conn.Close

(It's been a while since I've used ADO so make sure you read up on it)

Attached image(s)

•