Groups > it.comp.lang.visual-basic > #18859

Re: VB6 e database *.mdb

From	GbC <info@gbcdepot.com>
Newsgroups	it.comp.lang.visual-basic
Subject	Re: VB6 e database *.mdb
Date	2016-09-01 09:43 +0200
Organization	Aioe.org NNTP Server
Message-ID	<nq8m82$kre$2@gioia.aioe.org> (permalink)
References	<npp13n$12js$1@gioia.aioe.org> <nppmgf$bs5$1@gioia.aioe.org> <nq2b6h$18rp$1@gioia.aioe.org> <nq8m5v$kre$1@gioia.aioe.org>

Show all headers | View raw

Option Explicit
Dim strUser As String
Dim strPassword As String


Private Sub cmdConnect_Click()

Dim cn As New Connection
Dim rs As Recordset

'Create the connection.
     cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Password=" & _
     <password> & ";" & "User ID=" & <utente> & ";" & _
     "Data Source=<il tuo db MDB>;Persist Security Info=True;" & _
     "Jet OLEDB:System database=<il file MDW per le credenziali>"


'Create recordset reference and set its properties.
     Set rs = New ADODB.Recordset
     rs.CursorType = adOpenKeyset
     rs.LockType = adLockOptimistic

rs.Open <tabella>, cn, , , adCmdTable

End Sub




-- 
GbC
www.gbc.uno

Back to it.comp.lang.visual-basic | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

VB6 e database *.mdb Gulp® <gulp@hotmail.it> - 2016-08-26 11:11 +0200
  Re: VB6 e database *.mdb Gulp® <gulp@hotmail.it> - 2016-08-26 11:22 +0200
  Re: VB6 e database *.mdb GbC <info@gbcdepot.com> - 2016-08-26 17:16 +0200
    Re: VB6 e database *.mdb Gulp® <gulp@hotmail.it> - 2016-08-29 23:58 +0200
      Re: VB6 e database *.mdb GbC <info@gbcdepot.com> - 2016-08-30 10:05 +0200
        Re: VB6 e database *.mdb Gulp® <gulp@hotmail.it> - 2016-08-30 10:24 +0200
          Re: VB6 e database *.mdb GbC <info@gbcdepot.com> - 2016-08-31 11:55 +0200
      Re: VB6 e database *.mdb GbC <info@gbcdepot.com> - 2016-09-01 09:42 +0200
        Re: VB6 e database *.mdb GbC <info@gbcdepot.com> - 2016-09-01 09:43 +0200
  Re: VB6 e database *.mdb Greg <greg@alicie.com> - 2016-08-28 23:01 +0200
    Re: VB6 e database *.mdb Gulp® <gulp@hotmail.it> - 2016-08-29 23:27 +0200
  Re: VB6 e database *.mdb Greg <greg@alicie.com> - 2016-08-31 18:51 +0200
    Re: VB6 e database *.mdb Gulp® <gulp@hotmail.it> - 2016-09-01 12:33 +0200
      Re: VB6 e database *.mdb Greg <greg@alicie.com> - 2016-09-01 14:30 +0200
        Re: VB6 e database *.mdb Greg <greg@alicie.com> - 2016-09-01 19:18 +0200

csiph-web