Click here to Skip to main content
15,909,051 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Create a Serial code Pin
DaveAuld27-Mar-11 22:24
professionalDaveAuld27-Mar-11 22:24 
AnswerRe: Create a Serial code Pin
Herboren7-Apr-11 5:16
Herboren7-Apr-11 5:16 
Questioncreation of table Pin
basheer.j26-Mar-11 7:51
basheer.j26-Mar-11 7:51 
AnswerRe: creation of table Pin
Dave Kreskowiak26-Mar-11 17:56
mveDave Kreskowiak26-Mar-11 17:56 
GeneralRe: creation of table Pin
basheer.j27-Mar-11 6:14
basheer.j27-Mar-11 6:14 
GeneralRe: creation of table Pin
Dalek Dave27-Mar-11 6:29
professionalDalek Dave27-Mar-11 6:29 
GeneralRe: creation of table Pin
Dave Kreskowiak27-Mar-11 6:47
mveDave Kreskowiak27-Mar-11 6:47 
GeneralRe: creation of table Pin
Dalek Dave27-Mar-11 6:52
professionalDalek Dave27-Mar-11 6:52 
AnswerRe: creation of table Pin
Dalek Dave27-Mar-11 6:28
professionalDalek Dave27-Mar-11 6:28 
AnswerRe: creation of table Pin
Ravi Sant27-Mar-11 8:14
Ravi Sant27-Mar-11 8:14 
QuestionCopying File From Network [Solved] Pin
εїзεїзεїз26-Mar-11 1:26
εїзεїзεїз26-Mar-11 1:26 
AnswerRe: Copying File From Network Pin
Luc Pattyn26-Mar-11 5:10
sitebuilderLuc Pattyn26-Mar-11 5:10 
GeneralRe: Copying File From Network Pin
εїзεїзεїз27-Mar-11 22:26
εїзεїзεїз27-Mar-11 22:26 
QuestionGetting Error while Copying File From Local Network [Solved] Pin
εїзεїзεїз26-Mar-11 0:43
εїзεїзεїз26-Mar-11 0:43 
QuestionRe: Getting Error while Copying File From Local Network Pin
Eddy Vluggen26-Mar-11 2:10
professionalEddy Vluggen26-Mar-11 2:10 
AnswerRe: Getting Error while Copying File From Local Network Pin
εїзεїзεїз26-Mar-11 3:49
εїзεїзεїз26-Mar-11 3:49 
GeneralRe: Getting Error while Copying File From Local Network Pin
Dave Kreskowiak26-Mar-11 6:19
mveDave Kreskowiak26-Mar-11 6:19 
GeneralRe: Getting Error while Copying File From Local Network Pin
εїзεїзεїз27-Mar-11 22:27
εїзεїзεїз27-Mar-11 22:27 
QuestionExport DataGridView to PDF Pin
ivo7525-Mar-11 7:45
ivo7525-Mar-11 7:45 
AnswerRe: Export DataGridView to PDF Pin
Dave Kreskowiak25-Mar-11 8:13
mveDave Kreskowiak25-Mar-11 8:13 
QuestionData1.DatabaseName = from network server Pin
loid grey manuel25-Mar-11 5:58
loid grey manuel25-Mar-11 5:58 
i have problem with data1, i am trying to network a project of mine in VB6..
the scenario is this,

i have an MS Flexgrid and i want to fill it with data from a Data1. the problem is that the ms access DB is located at the Local Server from our network at office.

i was able to manage at least to connect the DB using the code below

Option Explicit
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
---------------------------------------------------------------------------
Private Sub Form_Load()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim strsql As String

'-- get db path
Set cn = New ADODB.Connection
     cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data Source=\\IP Address or Computer Name\DIR\masterFile.mdb ;Persist Security Info = False"
     
     cn.Open
     Set rs = cn.Execute("select * from dataTable")

End Sub


but i can't figure out how set the database name for data1

Data1.DatabaseName = "WHAT Should be the Path?"
Data1.RecordSource = ("select * dataTable order by Title")


how am i going to access the database and save it's content's to data1?

thanks in advance.
AnswerRe: Data1.DatabaseName = from network server Pin
Dave Kreskowiak25-Mar-11 6:24
mveDave Kreskowiak25-Mar-11 6:24 
GeneralRe: Data1.DatabaseName = from network server [Resolved].. Pin
loid grey manuel30-Mar-11 20:13
loid grey manuel30-Mar-11 20:13 
Questionconnecting Access v. 95 DB over LAN vb6 win7 OS Pin
loid grey manuel24-Mar-11 6:11
loid grey manuel24-Mar-11 6:11 
AnswerRe: connecting Access v. 95 DB over LAN vb6 win7 OS Pin
Luc Pattyn24-Mar-11 7:09
sitebuilderLuc Pattyn24-Mar-11 7:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.