Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


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

Re: VB6 e database *.mdb

Path csiph.com!aioe.org!.POSTED!not-for-mail
From GbC <info@gbcdepot.com>
Newsgroups it.comp.lang.visual-basic
Subject Re: VB6 e database *.mdb
Date Thu, 1 Sep 2016 09:43:58 +0200
Organization Aioe.org NNTP Server
Lines 32
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>
NNTP-Posting-Host z9WxV/I7T0HNhE4/W/qEMQ.user.gioia.aioe.org
Mime-Version 1.0
Content-Type text/plain; charset=iso-8859-15; format=flowed
Content-Transfer-Encoding 7bit
X-Complaints-To abuse@aioe.org
User-Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.2.0
X-Notice Filtered by postfilter v. 0.8.2
Xref csiph.com it.comp.lang.visual-basic:18859

Show key headers only | 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 | NextPrevious in thread | Next in thread | Find similar | Unroll thread


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