Accessing secured databse(access)
:WAVE:
hi,
i am working on project with access2000 as backend.The databse will be on centralise place and application wil be on 2/3 computers.We are working on windows2000 server and pc's have winxp as os.
Pc's have network login as Process,Ites,project etc.
i like to use access set database password feature or user level security wizard to secure databa.se
Can anybody guide me how to use userlevel security wizard with such logins and with vb 6.
i use adodb for non-secured databse like;
dim conn as new adodb.connection
conn.open"provider=microsoft.jet.oledb.4.0;" & _
"data source=path.databse.mdb;"
i don't know anything about password protection.So please guide me
can you suggest good book or link on this issue
[821 byte] By [
ganesh4u] at [2007-11-11 7:14:46]
# 1 Re: Accessing secured databse(access)
Hi my friend, Actually Im using SQLServer, so, when I was working with Access with password, I was using ADO Connection different with you... about is an exemplo..
--------------- OPEN DATABASE
Global gblCn As New ADODB.Connection 'from a module
gblDB = "\\192.168.0.1\publicdocs\lekkuscm.mdb"
With gblCn
.CursorLocation = adUseClient
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & gblDB & ";Jet OLEDB:Database Password = lekkus20062002"
.Open
End With
-----------------------
Tip: Using IP from computer database, you not need map drive and you will difficult the other users know where you database is hosted.
------------------- OPEN RECORDS
Dim rProducts as As New ADODB.Recordset
Dim sSql as String
With rProducts
.Open sSql, gblCn, adOpenStatic, adLockOptimistic
Do While .EOF = False
Debug.Print !PRODUTO
.MoveNext
Loop
.Close
End With
Set rProducts = Nothing
----------------------
I hope I did help you.
Have a good luck
Best Regards
Biruel
biruel at 2007-11-11 17:27:18 >
