Article View: free.it.visual-basic
Article #1482DB ACCESS CON PASSWORD E VB
From: Max
Date: Tue, 11 May 2004 14:41
Date: Tue, 11 May 2004 14:41
26 lines
1892 bytes
1892 bytes
Ciao a tutti,
cerco di stabilire una connessione ad un DB Access protetto da password di
seguito il codice che uso :
Option Explicit
Private cnnDatiSoc As New ADODB.Connection
Private strSQLDatiSoc As String
Private strConDatiSoc As String
Private rstDatiSoc As New ADODB.Recordset
Private Sub Form_Load()
Resize Me
strConDatiSoc = App.Path & "\db1.mdb"
cnnDatiSoc.Provider = "Microsoft.Jet.OLEDB.3.51"
cnnDatiSoc.Open strConDatiSoc, "Admin", "password"
strSQLDatiSoc = "SELECT * FROM datisocieta "
Set rstDatiSoc = cnnDatiSoc.Execute(strSQLDatiSoc)
Set txtragsoc.DataSource = rstDatiSoc
txtragsoc.DataField = "ragsoc"
cnnDatiSoc.Close
rstDatiSoc.Close
End Sub
Questo codice genera un errore quando deve passare la password del DB..... ?
Se elimino la password al DB va tutto bene, ma per motivi di sicurezza ho
bisogno che il DB sia protetto da password.
Come posso risolvere il problema ?
Technical Details
Message-ID:
<c7qolu$i3d$1@newsread.albacom.net>Path:
arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!tiscali!newsfeed1.ip.tiscali.net!irazu.switch.ch!switch.ch!newsfeed.nextoneserver.com!news-out.tin.it!news-in.tin.it!news.caltanet.it!newsfeed.albacom.net!newsread.albacom.net!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ITALIAN,ASCII-7-bit X-Google-Thread: f94ee,7b3222b8aff5bf34,start X-Google-Attributes: gidf94ee,public Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!tiscali!newsfeed1.ip.tiscali.net!irazu.switch.ch!switch.ch!newsfeed.nextoneserver.com!news-out.tin.it!news-in.tin.it!news.caltanet.it!newsfeed.albacom.net!newsread.albacom.net!not-for-mail From: "Max" <icetrap73@yahoo.it> Newsgroups: free.it.visual-basic Subject: DB ACCESS CON PASSWORD E VB Date: Tue, 11 May 2004 16:41:51 +0200 Organization: Albacom S.p.A. Lines: 28 Message-ID: <c7qolu$i3d$1@newsread.albacom.net> NNTP-Posting-Host: 213.255.118.143 X-Trace: newsread.albacom.net 1084286462 18541 213.255.118.143 (11 May 2004 14:41:02 GMT) X-Complaints-To: abuse@albacom.net X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165