Lm th? no ? lu tr? SQL c s? d? li?u ng nh?p ID v m?t kh?u t?i ?a phng

D?ch tiu ? D?ch tiu ?
ID c?a bi: 209502 - Xem s?n ph?m m bi ny p d?ng vo.
?i v?i m?t phin b?n Microsoft truy c?p 97 c?a bi vi?t ny, xem 101084.
Nng cao: ?i h?i chuyn gia m? ha, kh? nng tng tc v multiuser k? nng.

Bi vi?t ny ch? p d?ng cho m?t c s? d? li?u Microsoft Access (.mdb/.accdb).

Bung t?t c? | Thu g?n t?t c?

TM T?T

Lu tr? SQL c s? d? li?u ng nh?p ID v m?t kh?u t?i ?a phng yu c?u ng?i qu?n tr? c s? d? li?u t?o m?t b?ng duy nh?t trn my ch?.

THNG TIN THM

Trong Microsoft Access, khi b?n lin k?t m?t b?ng c s? d? li?u SQL, b?n c th? ch?n cho d b?n mu?n truy c?p Microsoft ? lu tr? ID ng nh?p c?a b?n v m?t kh?u t?i ?a phng. N?u b?n khng lm nh th?, Microsoft Access s? nh?c b?n cho ID ng nh?p c?a b?n v m?t kh?u m?i khi b?n k?t n?i v?i c s? d? li?u SQL c ch?a cc b?ng.

N?u b?n mu?n truy c?p Microsoft ? lu tr? k?t n?i thng tin trong Microsoft Access c s? d? li?u do b?n khng c?n ph?i g? n m?i th?i gian, b?n c th? b?m ? ch?n cc Lu m?t kh?u ki?m tra h?p trong cc Lin k?t b?ng h?p tho?i khi b?n lin k?t b?ng c s? d? li?u SQL.

Cho Microsoft SQL Server, Sybase SQL Server v ORACLE Server c s? d? li?u, SQL c?a b?n c s? d? li?u qu?n tr? vin c th? ch?n ? v hi?u ha tnh nng ny, yu c?u t?t c? ng?i dng ? nh?p ng nh?p ID v m?t kh?u c?a h? m?i khi h? k?t n?i t?i m?t SQL c s? d? li?u.

? v hi?u ha kh? nng lu tr? ng nh?p ID v m?t kh?u t?i ?a phng, qu?n tr? c s? d? li?u SQL c?a b?n ph?i t?o m?t b?ng g?i l MSysConf c s? d? li?u SQL. Khi m?t ng?i s? d?ng k?t n?i c s? d? li?u SQL, Microsoft Access trng cho b?ng ny trong c s? d? li?u, v n?u n t?m th?y n, truy v?n b?ng. N?u cc gi tr? trong b?ng ng ch? ra r?ng lu tr? ?a phng ng nh?p ID v m?t kh?u ph?i ?c v hi?u ha, Microsoft truy c?p nh v?y, b?t k? c?a cho d cc Lu ng nh?p ID v m?t kh?u t?i ?a phng ch?n h?p ki?m. N?u b?ng khng c ho?c khng xc ?nh v hi?u ha tnh nng, ng?i s? d?ng Lu ng nh?p ID v m?t kh?u t?i ?a phng.

B?ng c s? d? li?u SQL MSysConf nn c c?u trc sau.
Column name   Data type                                 Allows Null?
   --------------------------------------------------------------------
   Config        A data type that corresponds to a         No
                 2-byte integer, for example SMALLINT

   chValue       VARCHAR(255)                              Yes

   nValue        A data type that corresponds to a
                 4-byte integer, for example INT           Yes

   Comment       VARCHAR(255)                              Yes
				
N?u ngu?n d? li?u b?n ang lm vi?c v?i ch?, s? d?ng cc b?ng v c?t tn chnh xc nh ?c hi?n th?. T?t c? ng?i dng ph?i c quy?n s? d?ng nh?ng tuyn b? ch?n trn b?ng ny v c th? ch? l ng?i qu?n tr? h? th?ng c quy?n s? d?ng tuyn b? DELETE trn b?ng ny.

Trong ORACLE, c m?t vi i?u khc nhau. V d?, t? "B?nh lu?n" dnh ring trong ORACLE, do , b?n s? c?n ph?i thay ?i n ? "? ki?n." Thay ?i khc lin quan ?n m?t s? khc bi?t trong cc lo?i d? li?u. ? y l lm th? no b?ng s? xu?t hi?n trong m?t c s? d? li?u ORACLE:
   CONFIG          NUM(4,0)         NOT NULL
   CHVALUE         VARCHAR(255)
   NVALUE          NUM(5,0)*
   COMMENTS        VARCHAR(255)
				
Nvalue c th? c ? chnh xc ln ?n Num(9,0).

? v hi?u ha lu tr? ID ng nh?p v m?t kh?u, b?ng nn c ch? c m?t hng nh sau:
   Column name     Value    Explanation
   --------------------------------------------------------------------
   Config          101      This value indicates that this record 
                            determines password properties.

   chValue         NULL     Reserved for future use.

   nValue          0 or 1   Use 0 to prevent the password and login ID
                            from being stored; use 1 to permit
                            password and login ID storage.

   Comment                  Enter your own comments here.
				
LU ?: N?u b?n thay ?i gi tr? nValue, b?n ph?i kh?i ?ng l?i truy c?p tr?c khi s? thay ?i th?c s? s? di?n ra.

THAM KH?O

Cho thng tin thm v? lin k?t b?ng, nh?p vo Tr? gip Microsoft Access trn cc Tr giup tr?nh n, lo?i C s? d? li?u SQL lin k?t trong vn ph?ng Tr? l? ho?c thu?t s? tr? l?i, v sau b?m Tim kim ? xem cc ch? ? tr? l?i.

Thu?c tnh

ID c?a bi: 209502 - L?n xem xt sau cng: 17 Thang Chin 2011 - Xem xt l?i: 3.0
p d?ng
  • Microsoft Access 2000 Standard Edition
  • Microsoft Access 2002 Standard Edition
  • Microsoft Office Access 2003
  • Microsoft Office Access 2007
  • Microsoft Access 2010
T? kha:
kbdatabase kbdesign kbhowto kbinfo kbusage kbmt KB209502 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:209502

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com