Thi?t L?p Quy?n Truy C?p Cho File CSDL

Ch�ng ta bi?t r?ng, c�c thao t�c c?p nh?t hay x�a d? li?u tr�n CSDL ch? c� th? th?c hi?n ???c b?ng VBScripting Language khi t?p tin ?� ?� ???c c?p m?t s? quy?n truy c?p nh?t ??nh. Th�ng th??ng ?� l� quy?n Vi?t(c?p nh?t-write) v�o CSDL.


Trong b�i tr??c ch�ng ta ?� t?o file CSDL v?i t�n l� Login.mdb, trong ?� ch�ng ta c� b?ng tblMembership v?i 3 tr??ng, 1 tr??ng LoginID gi? ID c?a m?i User v� 2 tr??ng Text: Username v� Userpassword, gi? t�n ??ng nh?p v� m?t kh?u.

Ch�ng ta bi?t r?ng, c�c thao t�c c?p nh?t hay x�a d? li?u tr�n CSDL ch? c� th? th?c hi?n ???c b?ng VBScripting Language khi t?p tin ?� ?� ???c c?p m?t s? quy?n truy c?p nh?t ??nh. Th�ng th??ng ?� l� quy?n Vi?t(c?p nh?t-write) v�o CSDL.

Do ?�, ?? c� th? thao t�c tr�n CSDL Login.mdb, ch�ng ta c?n thi?t l?p m?t s? quy?n truy c?p(read/write) cho File n�y. T? Windows Desktop, Click Start --> My Computer, trong h?p tho?i My Computer, click Th?c ??n Tools, Ch?n Folder Options, h?p tho?i Folder Options m? ra nh? h�nh d??i:

Thi?t l?p thu?c t�nh chi s? t�i nguy�n.

Click Tab View, d�ng chu?t k�o thanh cu?n (scroll bar) xu?ng v� Click b? ch?n Use Simple File Sharing (recommended), nh? h�nh tr�n, Click OK.

Tr? v? c?a s? My Computer, t�m ???ng d?n ??n File login.mdb m� b?n ?� l?u tr??c ?� nh? h�nh minh h?a d??i:

Thi?t l?p thu?c t�nh cho file login.mdb.

Right Click l�n File login.mdb v� ch?n Properties. C?a s? Properties m? ra, Click ch?n Tab Security nh? h�nh d??i:

C?p quy?n truy c?p cho File login.mdb.

? h?p tho?i Group or Usernames, Click ch?n Users , ? h?p tho?i Permissions for Users, Click ch?n nh? h�nh tr�n, Xong Click Apply, Click OK.

B�y gi? File login.mdb ?� s?n s�ng cho vi?c c?p nh?t d? li?u v�o ?�.

Submit Article :- Digg + Technorati + del.icio.us + Stumbleupon + Reddit + BlinkList + Furl + Yahoo+ Blogmarks + Ekstreme Socializer

|